Home » RDBMS Server » Server Administration » export/import with tablespace info
export/import with tablespace info [message #56292] Mon, 17 March 2003 08:00 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello Everyone,

I need your valuable help for the following:-

1. Is there a way that while importing a table from *.dmp file we can import that table into a different tablespace rather than the one used while exporting the table?

2. Once the table is imported from the .dmp file how and can we move the table to a different tablespace. What would be the syntax for it.

Your help on this ASAP would be highly appreciated.

Thanks!

Report message to a moderator

Re: export/import with tablespace info [message #56293 is a reply to message #56292] Mon, 17 March 2003 08:17 Go to previous message
Remi
Messages: 28
Registered: December 2002
Junior Member
Hi Eric

1
Simply set the users default tablespace to be your desired tablespace!

2.

Alter table table_name move tablespace ts_name

Hope this helps!!

http://askremi.ora-0000.com

Remi

Report message to a moderator

Previous Topic: Errors during export
Next Topic: Index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:59:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.