Home » RDBMS Server » Server Utilities » moving schema from one tablespace to another in a database
moving schema from one tablespace to another in a database [message #260977] Tue, 21 August 2007 07:16 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64120
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
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:
  


Current Time: Tue Dec 06 10:42:59 CST 2016

Total time taken to generate the page: 0.09669 seconds