OraFAQ Forum: Server Utilities » moving schema from one tablespace to another in a database

Home » RDBMS Server » Server Utilities » moving schema from one tablespace to another in a database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

moving schema from one tablespace to another in a database [message #260977]

Tue, 21 August 2007 07:16

safarulla
Messages: 3
Registered: June 2007

Junior Member

Hi all,
I want to move some schema's from one tablespace to another.
Can i use datapump for this
ie,export schema A
drop schema A
import schema A.

is this possible?or any other way?

[Updated on: Tue, 21 August 2007 07:31]

Report message to a moderator

Re: moving schema from one tablespace to another in a database [message #260987 is a reply to message #260977]

Tue, 21 August 2007 08:06

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

is this possible?

Yes, using remap_tablespace option.

Quote:

or any other way?

Yes, "alter table move", "alter index rebuild tablespace".

Regards
Michel

Report message to a moderator

Previous Topic:	All data not imported when doing full db import
Next Topic:	SQL Loader - Can I use 'fix11' through command line instead of INFILE?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:12:23 CDT 2024