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

Dbms_metadata.get_ddl

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

when all else fails Read The Fine Manual

DBMS_METADATA

http://download.oracle.com/docs/cd/E...a.htm#i1019414

aw no thanks a lot or your help ^^