Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    16

    Unanswered: Export Data from Pl-sql prompt

    Is it possible to export data and data structure of all tables from
    PL-SQL in Oracle 8.
    i know utility available exp80.exe for it.
    i want to know from PL-SQL promp

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >i want to know from PL-SQL promp
    AFAIK, PL/SQL is not interactive & has no prompt.
    By using UTL_FILE you can output data.
    By using DBMS_METADATA you can output "data structures".
    It is easier just to use "exp" (export).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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