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

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

Confused with Loop
guys, i got confused with Looping...this is the case

I have 3 stocks, let say "Stock A&q

How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han

Looking for help on using joining mysql tables and php....
Does anyone have any good links to references on how to pull mysql data, through joining tables and

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data