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

Page not Loading After Test
Hey All

It seemed that an inlcude statement wasn't working for some reason, so I tried a more

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

LSB (PHP 5.3) problem with static value!
hello,

i'm having a problem. static::$text variable gets lost at some point. can someone plea

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I