Use of dba_constraints, dba_indexes, dba_objects will do it man.

Just query these tables and you can do it yourself.

Regards
Nikhil.

-----Original Message-----
From: Raj [mailto:oracledba-ezmlmshield-x1484456.[Email address protected]
Sent: Friday, April 04, 2008 12:52 PM
To: LazyDBA Discussion
Subject: $User database information

Dear experts







Its an urgent requirement :- I want to write a script which will
display me

User_name, table_name, tablespace_name, column_name , column_data_type,
constraint_name, constraint_type, index_name, index_type



Please try this subject to solve . thanks in advance







Rajendra kumar









---------------------------------------------------------------------
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



DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Oracle LazyDBA home page