Database

(Oracle) Howto import an oracle dump in an different tablespace

steloflute 2013. 5. 21. 23:30

http://stackoverflow.com/questions/61963/howto-import-an-oracle-dump-in-an-different-tablespace

 

If you're using Oracle 10g and datapump, you can use the REMAP_TABLESPACE clause. example:

REMAP_TABLESPACE=A_TBLSPACE:NEW_TABLESPACE_GOES_HERE

 

 

 

 

 

'Database' 카테고리의 다른 글

SQL AUTO INCREMENT Field  (0) 2013.06.05
ORA-39087: directory name is invalid tips  (0) 2013.05.22
(Oracle) ALTER SYSTEM SWITCH LOGFILE vs ALTER SYSTEM ARCHIVELOG CURRENT  (0) 2013.04.23
Oracle flashback  (0) 2013.04.10
manual reorg table  (0) 2013.04.08