| Import FKs . [message #62724] |
Tue, 10 August 2004 23:01  |
Ach
Messages: 26
Registered: April 2004
|
Junior Member |
|
|
Hi,
How can one import the foreign keys of tables of a schema which is imported exactly from an other schema?
I want to have all the FKs in destinition table as they are in source table...
thanx for your help!
|
|
|
|
| Re: Import FKs . [message #62737 is a reply to message #62724] |
Wed, 11 August 2004 03:28  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
import the schema without data.
--
-- this will import only the tables
--
imp dba/passCode fromuser=a touser=b rows=n file=somefile.dmp
-- or
--
-- use indexfile option to get the source code.
-- myddl.sql will have the ddl for all the tables
-- u can recreate them manually
imp dba/passCode fromuser=a touser=b rows=n file=somefile.dmp indexfile=myddl.sql
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
