Home » RDBMS Server » Server Utilities » Export from schema to another schema
Export from schema to another schema [message #204831] Wed, 22 November 2006 05:18 Go to next message
manna
Messages: 1
Registered: November 2006
Junior Member
Hi all,

This is my first massage in this wonderful forum..

And i hope some body answer my question in some details..

I need to export some tables with there related triggers and indexes and constraints and the data also from a test schema to the original schema..

i use toad 8.6 to export them but it doesn't export every thing.. it miss the PK and UQ and some other..

so please give me a help

thank you all
Re: Export from schema to another schema [message #204845 is a reply to message #204831] Wed, 22 November 2006 06:28 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i use toad 8.6 to export them but it doesn't export every thing.. it miss the PK and UQ and some other.
Support your claim by showing us something to start with. May be you have disabled them in the GUI options.
Why not just use exp utility?
Search the faq sections and this forum for numerous examples.
Previous Topic: Multiple references to same table in control file
Next Topic: Data Pumping in Oracle 9i
Goto Forum:
  


Current Time: Mon Dec 02 07:29:24 CST 2024