Home » SQL & PL/SQL » SQL & PL/SQL » How to see all the tables create by me?
How to see all the tables create by me? [message #258360] Sat, 11 August 2007 05:30 Go to next message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
Hi, i like to double check if the tables i created in the tablespace are created by me( User KCM).

What should i type to view this data?

Thank you
Re: How to see all the tables create by me? [message #258361 is a reply to message #258360] Sat, 11 August 2007 05:45 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

select * from user_table;

here u can get all the tables created by the logged in user...

regards...
dipali

[Updated on: Sat, 11 August 2007 05:47]

Report message to a moderator

Re: How to see all the tables create by me? [message #258373 is a reply to message #258361] Sat, 11 August 2007 06:21 Go to previous messageGo to next message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
Hi, the user_table is it in the oracle or my table?

Sorry, dun seems to understand..

Actually i create eg: customer, order, country tables inside tablespace named tbs_sales. And these tables are create under my user account KCM.

I want to know if these tables customer, order and country tables are create by me.

What should i type in sqlplus to see if the tables are under my name?

Sorry for asking these questions. I'm quite new to ORACLE..

Thanks
Re: How to see all the tables create by me? [message #258376 is a reply to message #258373] Sat, 11 August 2007 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just execute "select table_name from user_tables;".
Just execute that and then come back.

Regards
Michel
Re: How to see all the tables create by me? [message #258378 is a reply to message #258360] Sat, 11 August 2007 06:39 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

dear..
user_table is not a table..
it's a data dictionary view..
this view contains the table information created by the user..
If you logged in as "xyz" user and execute above query then, you will get all the tables created by user "xyz"..
and i think this is what you need..

regards..
Dipali
Re: How to see all the tables create by me? [message #258382 is a reply to message #258378] Sat, 11 August 2007 06:58 Go to previous messageGo to next message
biz_me
Messages: 8
Registered: July 2007
Location: singapore
Junior Member
Hi thanks all...
Thanks for your answers...
Re: How to see all the tables create by me? [message #258873 is a reply to message #258360] Mon, 13 August 2007 12:32 Go to previous message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
Your original question was if there are any tables that are in the tablespace that were not made by you. See the following query.


select owner,table_name,DECODE(OWNER,'KCM',NULL,'<=== NOT KCM') FLAG
from all_tables
where tablespace_NAME='TBS_SALES';
Previous Topic: Diffference between two dates
Next Topic: table with a boolean column
Goto Forum:
  


Current Time: Sat Dec 03 20:03:04 CST 2016

Total time taken to generate the page: 0.04105 seconds