Results 1 to 2 of 2

Thread: export data

  1. #1
    Join Date
    Nov 2002
    Posts
    25

    Talking Unanswered: export data

    Hi All,
    What is the equivalent of informix's "dbexport -ss databasename" in oracle?. What are the tools/utilities in exporting data from Oracle instance?.

    Thanks,
    tungaw

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    There's EXPORT utility in Oracle. It should be run at OS prompt. For help, enter:
    OS> EXP HELP=Y

    A simple example would be:
    OS> EXP user_name/user_password FILE=my_exp.dmp

    which exports everything that user owns (tables, data, stored procedures, ...).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •