Hi Parag,

If you want see the Orace object script you can use the USER_SOURCE
system table, In this system table you can get the following object
scripts

FUNCTION
PACKAGE
PACKAGE BODY
PROCEDURE
TRIGGER
TYPE

If you want to see the particular table script (column name,data type
and column size) then you can use the USER_TAB_COLUMNS system table.

USER_CONSTRAINTS --> You can get the particular table constraints
details

Let me know if you need more details...



Regards,

Siva.P

BirlaSoft, Bangalore. India

Mail to: siva.[Email address protected]

DC# : *318 - 5138

"You never achieve real success unless you like what you are doing"


-----Original Message-----
From: Parag Rajne
[mailto:oracledba-ezmlmshield-x38059564.[Email address protected]
Sent: Monday, December 31, 2007 2:31 PM
To: LazyDBA Discussion
Subject: How can I get the table scripts from database

Hi All,
Can anybody please help me on, which system table should be

queried to get the script for particular table ?
I wan't to get the script for particular table, but I could not see that

in my tool,
So please tell me where table scripts are stored in the database ?

Thanks,
Parag


Larsen & Toubro Infotech Ltd.
www.Lntinfotech.com

This Document is classified as:

L&T Infotech Proprietary L&T Infotech Confidential L&T Infotech
Internal Use Only L&T Infotech General Business

This Email may contain confidential or privileged information for the
intended recipient (s) If you are not the intended recipient, please do
not use or disseminate the information, notify the sender and delete it
from your system.

______________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page