Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    35

    Red face Unanswered: How to construct indexes from dictionary tables?

    Hi All,


    Oracle stores source code of procedure or function in "user_sources" table.

    Does oracle store the source code to for user constraints creation?


    I need to drop table and re-creates that table including necessary constraints dynamically in a certain periode of time. So i need to configure/reconstruct the "create table" statement including constraints.


    Any idea is appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: How to construct indexes from dictionary tables?

    Originally posted by msetjadi
    Hi All,


    Oracle stores source code of procedure or function in "user_sources" table.

    Does oracle store the source code to for user constraints creation?


    I need to drop table and re-creates that table including necessary constraints dynamically in a certain periode of time. So i need to configure/reconstruct the "create table" statement including constraints.


    Any idea is appreciated.
    RTFM on DBMS_METADATA

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    This script will recreate a table. Run it thru SQLPlus... It will ask for
    the owner and table_name. The end of the script will spool the output
    for you. Change the directory if you want....

    hth
    Gregg
    Attached Files Attached Files

Posting Permissions

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