Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving objects between schemas

Status
Not open for further replies.
BigM

BigM

Programmer
Aug 30, 2000
39
GB
Hi Each,

I have two schemas, lets say schema1 and schema2. I am wanting to move all objects and any data from schema1 to schema2.

Any quick easy ways?

TIA

Big M
 
Sort by date Sort by votes
Export / import using fromuser / touser - look in the utilities manual

Alex
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
76
johnherman
johnherman
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
100
Beilstwh
Beilstwh
AlStl
  • Locked
  • Question
Accessing Objects in another schema under same database 1
Replies
4
Views
102
Beilstwh
Beilstwh
SantaMufasa
  • Locked
  • Question
How to estimate UNCOMPRESSED size of tablespace segments for COMPRESSED objects
Replies
5
Views
152
fredericofonseca
fredericofonseca
droodle
  • Locked
  • Question
Invalid Schemas
Replies
15
Views
206
carp
carp

Part and Inventory Search

Sponsor

Back
Top