Importing Steps
Create TableSpace
|
1 2 3 4 5 6 7 8 9 |
CREATE TABLESPACE test_TBS DATAFILE '/u01/app/oracle/oradata/smp/test01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 1024M LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON; |
On Releases 10G and later, apply FLASHBACK ON.
Drop Tablespace
|
1 |
DROP TABLESPACE TestTBS INCLUDING CONTENTS AND DATAFILES; |
Create User
10g
|
1 2 3 4 |
CREATE USER testuser IDENTIFIED BY "testuser" DEFAULT TABLESPACE example1 TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON example1; |
9i
|
1 2 3 4 |
CREATE USER Mehmet IDENTIFIED BY "mehmet" DEFAULT TABLESPACE TestTBS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON TestTBS; |
User Permissions
10g
|
1 2 3 4 5 |
GRANT "CONNECT" TO testuser; GRANT "IMP_FULL_DATABASE" TO testuser; GRANT "RESOURCE" TO testuser; ALTER USER testuser DEFAULT ROLE NONE; GRANT create session TO testuser; |
9i
|
1 2 3 4 5 |
GRANT "CONNECT" TO Mehmet; GRANT "IMP_FULL_DATABASE" TO Mehmet; GRANT "RESOURCE" TO Mehmet; ALTER USER Mehmet DEFAULT ROLE NONE; GRANT create session TO Mehmet; |
Imp
|
1 |
imp mehmet/mehmet file=/u01/ONDBA_15112006.dmp log=imp.log buffer=30000 touser=mehmet fromuser=ondb |
Kategori seçin...