| export/import [message #69047] |
Fri, 19 October 2001 02:30  |
Andrea Mainardi
Messages: 3
Registered: May 2001
|
Junior Member |
|
|
Hi,
I have to export some tables from one db Ora 7.3.4 to Ora 8.1.7.
While i'm doing this, i want to change the tablespace where the table i'm exporting resides, but this is a problem!!!
how can i change the tablespace of this tables???
----------------------------------------------------------------------
|
|
|
|
| Re: export/import [message #69052 is a reply to message #69047] |
Sat, 20 October 2001 04:27  |
D e e p a n k a r
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
create user in the new database and alot him the tablespace and then import the data there, ur data will be imported directly to the new tablespace
hope this works
regards
deepankar
----------------------------------------------------------------------
|
|
|
|
| Re: export/import [message #69067 is a reply to message #69047] |
Tue, 23 October 2001 11:53 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
After export
1. Create the new user
2. Create the table you want to import in the desired tablespace.
3. Import with the 'ignore=y' option
Good Luck.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
