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?

Report message to a moderator

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: 4580
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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: export 10g & import 9i
Next Topic: oradim not working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 06:47:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.