Home » RDBMS Server » Server Utilities » Why was some table imported to another tablespace? (oracle10gR2 Solaris5.9)
Why was some table imported to another tablespace? [message #307862] Thu, 20 March 2008 03:37 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

When I finished import data to tablespace 'A', but I found some tables in another tablespace 'B'.

Why was some table imported to another tablespace?

Re: Why was some table imported to another tablespace? [message #307867 is a reply to message #307862] Thu, 20 March 2008 03:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Because it was exported from that tablespace?

PS: You can always pre-create your tables in the correct tablespaces before the import.
Re: Why was some table imported to another tablespace? [message #307881 is a reply to message #307862] Thu, 20 March 2008 04:14 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Before import you can use indexfile=file_name or show=y to see the creation script.Always give quota in which tablespace the table resides in dump.
Previous Topic: export 10g & import 9i
Next Topic: oradim not working
Goto Forum:
  


Current Time: Wed Dec 07 16:47:54 CST 2016

Total time taken to generate the page: 0.10141 seconds