Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Kuwait
    Posts
    38

    Question Unanswered: SQL-Exporting table structures & data

    Hi guys

    As a beginner, I am using "Toad professional" to export the table structure, data etc.
    Is there any command set available with Oracle, which will allow me to export the structure of tables and data from the SQL prompt?

    Please advice.

    Regards.
    If it is a door, It will open.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Not from the SQL prompt, but you might use export utility (EXP) to achieve this goal. It is invoked from OS prompt. Type "EXP HELP=Y" to get instant help, or visit this FAQ page to read more about this issue.

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    depending on your version you can use dbms_metadata

  4. #4
    Join Date
    Feb 2004
    Location
    Kuwait
    Posts
    38

    Thank you guys!!!

    I really appreciate the prompt replies. Thank you guys. I already started "Experimenting" with the EXP command set.

    Regards
    If it is a door, It will open.

Posting Permissions

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