If you need to name the Oracle tablespaces according to your organizational policy, the existing tablespaces in your Oracle database or the new ones that you would create must be allocated with sizes as suggested in step 5 of Oracle Server. When you are ready with tablespaces, perform the following steps:
- Open Windows command prompt, connect to the Oracle database, and navigate to the directory
%ORACLE_HOME%\admin\agl\dpdump. - Execute the following command:
impdp system/agiliance@agl SCHEMAS=agiliance REMAP_SCHEMA=agiliance:target_schema REMAP_TABLESPACE=AGLDATA:tablespace1 REMAP_TABLESPACE=AGLINDEX:tablespace2 REMAP_TABLESPACE=AGLTEMP:tablespace3 TABLE_EXISTS_ACTION=REPLACE DUMPFILE=AGLBASERELEASE.DMP NOLOGFILE=y;
