Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2011
    Posts
    16

    Question Unanswered: Re-Create Other Users Tables

    If i have SELECT access to another users table, what would be the proper "DESCRIBE" i can use in order to see what are the constraints, primary keys, foreing keys, type of data, colums etc so i can re-code those tables myself ??? thanks a lot for your help I appreciate it

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Dbms_metadata.get_ddl
    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.

  3. #3
    Join Date
    Oct 2011
    Posts
    16
    SELECT dbms_metadata.get_ddl
    FROM PRESIDENT;
    mmm am i missing something perhaps ?

    ERROR at line 2:
    ORA-00942: table or view does not exist

    when i do :


    SELECT Table_Name
    FROM All_Tables
    WHERE OWNER = 'BOB';


    I get:


    TABLE_NAME
    ------------------------------
    MASTERTB
    PRESIDENT

    and when i do :

    SELECT SUBSTR(Owner,1,10) AS "Owner",
    SUBSTR(Table_Name,1,10) AS "Table_Name",
    SUBSTR(Grantor,1,10) AS "Grantor",
    SUBSTR(Grantee,1,10) AS "Grantee",
    SUBSTR(Privilege,1,10) AS "Privilege"
    FROM All_Tab_Privs_Recd
    WHERE GRANTOR = 'BOB';


    i get :

    Owner Table_Name Grantor Grantee Privilege
    ---------- ---------- ---------- ---------- ----------
    BOB MASTERTB BOB PUBLIC SELECT
    BOB PRESIDENT BOB MYNAME SELECT

    so im sure i have access im not sure whats wrong

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    when all else fails Read The Fine Manual

    DBMS_METADATA

    http://download.oracle.com/docs/cd/E...a.htm#i1019414
    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.

  5. #5
    Join Date
    Oct 2011
    Posts
    16
    aw no thanks a lot or your help ^^

Posting Permissions

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