-
Run the SQL Plus utility.
-
In the Log On dialog box, enter the required values to log on as the System Manager.
-
In the Oracle SQL Plus window, type and then press Enter after each command:
SPOOL <result text file full filepath>
Press Enter.
Type the following:
SELECT TABLESPACE_NAME,FILE_NAME,BYTES FROM DBA_DATA_FILES
ORDER BY TABLESPACE_NAME,FILE_NAME;Press Enter.
Type the following:
SELECT USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE
FROM DBA_USERS ORDER BY USERNAME;Press Enter.
Type the following:
SELECT * FROM DBA_SYS_PRIVS ORDER BY GRANTEE,PRIVILEGE;
Press Enter.
Type the following:
SELECT * FROM V$NLS_PARAMETERS;
Press Enter.
Type the following:
SPOOL OFF
Press Enter.
-
On the target server, create a new Oracle instance with a new database. Follow the Installation Guide instructions to create the new instance compatible with . Note that the new database must have the same character set as the source database.
-
To improve the restore performance, create the Indexes, Data, and Temporary files on different physical disks if possible.
-
Create table spaces for Admin data, Admin indexes, Admin temporary data, Domain data, Domain indexes, and temporary data for each domain.
-
In the SQL Plus window, type and then press Enter as follows:
CREATE SMALLFILE TABLESPACE <tablespace name> DATAFILE '<full path and name of the data file>' SIZE 50M AUTOEXTEND ON;
CREATE BIGFILE TABLESPACE <tablespace name> DATAFILE '<full path and name of the data file>' SIZE 50M AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE <tablespace name> TEMPFILE '<full path and name of the temp data file>' SIZE 50M AUTOEXTEND ON;
-
Press Enter.
The size of the tablespace determines the size of the file:
-
Small file = less than 1GB.
-
Large file = greater than 1GB
-
-
-
Repeat the last two CREATE commands for each required domain (as in the source database).