-
IMP problems
Hi all
Sun 5.8 and 9.2
I did a EXPORT using System account with FULL=Y option. Now i just need to overwrite all objects owned by user RSMITH. His id already exists in both the Databases.
So i did an IMPORT like this :
IMP system/password@abcdb1 buffer=10000 file=c:\scc.dmp fromuser=rsmith touser=rsmith
But it doesn't update the tables with new data and doesn't create new Tables if Source has new tables...
Where am i going wrong ?
I need to overwite existing records if exists or add new records if not exists or create new tables if not exists.
How do i do it in EXPORT ?
thanks
-
Re: IMP problems
Originally posted by vr76413
But it doesn't update the tables with new data and doesn't create new Tables if Source has new tables...
This can be done with an ignore=y
I need to overwite existing records if exists
To my knowledge Imp won't do this.
-
Ignore=Y will create any structures that are not present, it will NOT
affect ("update") the data.
Why not just truncate all of the tables that the user owns and then run your import, this is easy to do with dynamic SQL. Or if the user is identical drop it and do a schema level import, that is another option but may be overkill for this particular application.
MH
I remember when this place was cool.
-
One other thing when imorting...
I usually use BUFFER= in conjunction with COMMIT=Y
The commit is good to use especially when you have larger tables since Oracle will by default, commit after the entire table is imported. If the table is large you can blow out your rollback.
I usually set my buffer at 4000000, this way a commit is issued at roughly every 3MB's.
Just a suggestion.
MH
I remember when this place was cool.
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
|