Results 1 to 4 of 4

Thread: How can I export data from Oracle 9i

  1. #1
    Join Date
    Jul 2009
    Posts
    3

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    you can use exp utility to export a schema and use imp to import it in another database.

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    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?

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
  •