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?
Help with file_get_html
The following code gives the expected results:<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Linking with Foreign Keys
I have been getting an erro when I try and link:
checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that would be great. I have search google and this forum but have not found what i am looking for.thankswhen
Comparing two dates
Hi GuysI have two dates I want to compare. Below is my current implementation. The problem with it is it always returns false:if(date("d/m/y", $course->finish_date) >
At max how many columns is advisable to create in a table/view
Hi All,
extract data
Code: <div class="post hentry uncustomized-post-template"> <div id="post-title-wrapper"> <a
How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?Let's say I have:aaaaaaaaaaaaaaaaaaaaaaAll of the above should be replaces with a single 'z' character say for exampleI can do
Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Internet by just two people: Me & one client.When running in VS2008 it works perfectly fine but when
post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit button, when I set the type='image' it will not submit to itself. Can someone help me figure out
Output Full URL of Current Page
Let's say I am currently viewing a dynamic page: http://www.mydomain.com/directory/index.php?type=flowers I want this URL to be output on the page, but not including the end parameters.
