-
hm I wish we can do import direct=true as well heh so I can get more sleeps
-
I got it imported eventually.
Dropped the user (and their objects)
Re-created the tables, sequences, functions etc.
Did NOT re-create the constraints or triggers.
Did the import - fine!
Re-created the contstraints and triggers - and Hey presto! It works fine.
But there must be an easier way? If people use exports as a sort of back-up do they have disable constraints and db triggers to get the data back into the db?
Thanks anyway Guys
JMac
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|