-
How can I export data from Oracle 9i
Hello,
I am using the Oracle9i Enterprise Edition Release 9.2.0.1.0 on Windows server.
So I want to make backup for one schema only. Schema name is gc_auth.
How can I export data (including tables, views, trigers, functions, procedures, etc...) for user gc_auth?
After that I am planing to import it with different server there is also Oracle database.
Waiting for your comments.
Thanks in advance
Zurab
-
you can use exp utility to export a schema and use imp to import it in another database.
-
when I use exp utility I am getting an error that User not found. Is it necessary to create Schema owner user into another server where I want to import dmp file?
-
Did you use imp utility on the target server?. imp should create the user, if you are getting error then create the user.
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
|
|