| import tablespace [message #73126] |
Sat, 07 February 2004 17:39  |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
|
i want to export one tablespace and import that tablespace into 2 tablespaces how can do it.
|
|
|
|
| Re: import tablespace [message #73130 is a reply to message #73126] |
Wed, 11 February 2004 02:39  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to pre-create your tables before importing the data. You may want to run an import with INDEXFILE=create.sql; then edit the indexfile and create the tables in the correct tablespaces; then import the data with ROWS=YES IGNORE=YES.
For more details - see the Import/ Export FAQ at http://www.orafaq.com/faqiexp.htm
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
