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?
please, need help coding this voting for your favorite car polling system.
hi, my code needs a lot of work, but i want to be able to let users vote on their favorite car, update the database, and display the new updated data for the top ten cars listed. i want to prevent
Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.In a nutshell, the first page is entirely html and calls a php script to process an uploaded file and some form fields using POST. After validating the
Help Import Animoto and Youtube
CAn someone help me urgently want to allow users on my website to import youtube/revver/dailymotion and very important animoto videos into the site.This feature will come in the upload window.Can this
Effort Estimation Template for Steady State Support
Hi Everyone,
Receive Rosettanet Message to SAP 4.6c
Dear all ,
Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so I don't quite understand what they're talking about or what the code means.Here's the situation: I
what does this mean? +=
is anyone able to explain what this code is saying?i had it written for me awhile back and now that i wanna change it about to make it my own etc i dont really know what each part is doing...
check_changed_data - I can't get data from the called method event
I use check_changed_data to trigger my event method.
Create PHP table grid help, please
I have a MySQL database setup, now it's time for the table (gridview) design in php. Here's the problem i'm having. I have about 22 colms, but from colm 10 to 16 I want to place in one colm from 1 up
storing video files into mysql in php
hi i have my video files in my folder ,i have to store the path of the videos into db and the play it in the player from the database.thanking in advance