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?
Module pool selction screen parameters combination logic
Hi floks,
$action = "insert"; //$action = $_GET['action'];
$action = "insert";//$action = $_GET['action'];why is this invalid type? I am just modifying code that is there and want the action = insert so it will run all the parts of the code for
Problem with PHP code- simple contact form
Hi Folks, I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a contact form with PHP code in it- grabbed it from the sitemaster website. Unfortunately my form isn't
Help with captcha script needed
Hello, I am working on a script where reCAPTCHA or a similar form of CAPTCHA will be used, for the sake of this example I will talk about reCAPTCHA. I wanted to know how I could have the reCAPTCHA
Passing Arguments to execlp()
I'm writing a program that mimics a unix shell. It's supposed to take commands with arguments and execute them. I'm having trouble passing in the arguments into the execlp call to correctly execute
listcube issue
Hi
Prevention Help
How can I use PHP or any other language (feel free to move this thread) to prevent users doing screenshots of the website (maybe Java??) so if anyone knows how I can achieve this please post. Or how
insert/update functions for mysql, what do you think?
I am working on two really simple functions that automatically generate (and execute) insert and update mysql queries and I have some questions:Can there be any problems later on if functions treat
uploading video files into mysql in php
hi,I have the video files which i have to upload into mysql db. along with creating thumbnails from the video.can any one help me in this which will be greatful to methank u
Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of information from a database query and puts it in a sortable, filterable table. This all works fine and
