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?
GET * FROM _____ Except?
I have a site that is for stock photography.This section of the code calls images to display on the main page, based on several variables (new images, featured images, most downloaded, highest rated,
Mysql error message
help me find out what this error message means:"Duplicate entry '0' for key 'PRIMARY'"the sql for it is Code: INSERT INTO accounts (firstname, lastname, username, password, joined, email,
Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tiers.I've got it working so it only displays a tier if the quantity is greater than 0 but I end up
Onclick problem in Firefox
Hi, I am using a <label onclick="myfunction(this)"></label>. It doesn't seem to trigger in Firefox but works fine with ie. Does anyone know why?Thanks
using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the button and it puts the name into the database and into a list on my page. it works fine. Now, I wanted to
unserialize help, getting errors
hi all , I got a form with 6 fields (2 input and 4 select box), when the page loads one block is shown and through javascript all the fields can be copied multiple times so I need to store the data in
some query on multilingual website
Hi all,Which is the simplest and easiest method to make a website multilingual,is it putting files in different folder for different languages? or something else ?any suggestions will be
Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to check if a session is currently running of my app, like maybe using a cookie or something?
Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?After dealing with numerous very well qualified programmers to only turn down the project due to difficulty
CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect and start from next sentenceI am splitting into two sentences"This is first sentence." This
