import table with dependency

Posted on 16th Feb 2014 07:03 pm by admin

Hi

What is the best way to import table back which has dependency?

SQL> create table test (a number); Table created. SQL> create table test2 (b number); Table created. SQL> alter table test2 add constraint pk_test2 primary key(b); Table altered. SQL> ALTER TABLE test add CONSTRAINT fk_test FOREIGN KEY (a) REFERENCES test2(b); Table altered. exp system/**** file=C:/test2.dmp tables=test2 About to export specified tables via Conventional Path ... . . exporting table TEST2 0 rows exported Export terminated successfully without warnings. Sometime later, I want to import table test2. Inorder to achieve this I need to drop table first and then start import. SQL> drop table test2; drop table test2 * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign keys If I use cascade option, I will lose the foreign key in other table. What should I do in this issue?

Your Answer:

Login to answer

Other forums

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

I didnt code this but I need help with it
I'm sorry. i'm not a coder. I have this script for forcing download and previewing mp3. The guy that

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.