| ashish |
Posted: Mar 08, 2008 08:46:48 PM |
Total Post: 14
Joined: Dec, 2007
|
hello friends
i just want to know that is there any command which shows every
view ,
index,
sequence created by me in my data base. |
|
|
 arun |
| Posted: Mar 10, 2008 01:57:55 AM |  |
|
Total Post: 28
Joined: Sep, 2007
|
try using
dba_views
dba_indexes
|
|
|
|
|
| arun |
| Posted: Mar 10, 2008 01:58:26 AM | |
|
Total Post: 28
Joined: Sep, 2007
|
|
|
|
|
| Mohammed Taj |
| Posted: Mar 10, 2008 02:27:59 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
except above.
dba_objects
|
|
|
|
|
| pammi |
| Posted: Mar 11, 2008 12:12:11 AM | |
|
Total Post: 21
Joined: Feb, 2008
|
u can try
select * from user_objects
|
|
|
|
|
| Raj |
| Posted: Mar 17, 2008 08:17:19 AM | |
|
Total Post: 17
Joined: Jan, 2007
|
If you want to get the details created by you only then go for user_views, user_tables, user_indexes. With user_objects you can get the details abt all the objects you created in your schema. Dba_views, dba_indexes etc are only accessed if you have a dba privilege too.
|
|
|
|
|
| Vish |
| Posted: Oct 10, 2008 12:52:12 PM | |
|
Total Post: 100
Joined: Jan, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
