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

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,

login form can you find my error?
registrationform.php seems fine send data to registration.php
registration.php seems fine checks

HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need t