Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78

    Unanswered: Best database export/backup?

    I'm new to oracle (9i with TOAD).
    I utilize a table to import data, manipulate it, analyze it and then delete it.

    I would like to have a simple way to export or backup the data from only that table to an external file that would contain the structure as well. I would love to do it via a DOS command prompt if possible.

    What I visualize is I would do this process, I could truncate the table or even delete it and I could get the table and the data back from something I could store on a CD (depending on table size of course).

    What is the best (quickest/most efficient) method to do this?

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Oracle Export / Import
    Oracle SQL*Loader

    Read up on the docs here:
    PHP Code:
    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm 
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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