-
Hello,
Can a full import be run over an existing database? I am wanting to bring my test database up to date with the production database.
Thanks.
-
Yes, run as user system and compile the invalid objects. you will be fine.
Reddy,Sam
-
Hallo
you make a full export under
exp user/pwd file=xxx.dmp log=xxxx.log
and the other commands are optionally
full=y raws=y indexes=y owner=y
and the you import the data in you database under following commands.
imp user/pwd file=export.dmp ignore=y
This is the simple commands. You can better export your data and with another export your indexe.
So so they come again into your db.
Regards
Thomas Schmidt
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
|