| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Move schema and tablespace
Hi there,
To import into different tablespace,
do an import blah indexfile=blah.sql
Modify the blah.sql. Change all the Create Table ...Tablespace xxx to yyy that you want. Run the blah.sql and import again with ignore=Y
Allan W. Tham
Oracle DBA
Received on Tue Feb 26 2002 - 21:37:34 CST
 |
 |