How to get the info about the table

[oceanju]

I want to know the info of the table,includes column name,column type,etc.And I want to export the info into a xml file ,how to do?

[agasimani]

desc tablename

[oceanju]

desc tablename ?I use it,but no info.and I want to know the tablename from database.
I means I want to know all the info about table,view,package,trigger,etc.and import all the info to a xml file.I want to get a data dict.
which sys table record the info about that?

[oceanju]

thanks

[SANJAY_G]

DBA_OBJECTS

[jovery]

If your using 9i you can get the schema DDL from the DBMS_METADATA package (GET_DDL) the following link will help:

http://download-west.oracle.com/docs...eral.htm#14343

Regards

[agasimani]

I want to know the info of the table,includes column name,column type,etc.And I want to export the info into a xml file ,how to do?

You said you want column name, type and I said DESC tablename. And for your info this command gives both column name and type. If you want more info, then you should specify that clearly in your post. Dont expect people to read your mind.

If you want more details then analyze the table and look into USER_TABLES view.

[Thomasps]

Hi

Have a look at the DBA_IND_COLUMNS

Name Null? Type
------------------------------- -------- ----
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
DATA_TYPE VARCHAR2(9)
DATA_LENGTH NOT NULL NUMBER
DATA_PRECISION NUMBER
DATA_SCALE NUMBER
NULLABLE VARCHAR2(1)
COLUMN_ID NOT NULL NUMBER
DEFAULT_LENGTH NUMBER
DATA_DEFAULT LONG
NUM_DISTINCT NUMBER
LOW_VALUE RAW(32)
HIGH_VALUE RAW(32)
DENSITY NUMBER
NUM_NULLS NUMBER
NUM_BUCKETS NUMBER
LAST_ANALYZED DATE
SAMPLE_SIZE NUMBER


From this table you will get column definition for any tables as a single table or a group of tables. Hope this solve your issue..

Regards

[sgodbole]

To get the DDL statements for tables, indexes, constraints, and views you can export the database and then import with indexfile parameter and the file (which you specify for above parameter) will have all create statements. For PL/SQL objects you can query [ALL|DBA|USER_SORUCE] views.

Another option is to use script (shell script or sql script) to generate create statements for all objects in the database.