Home » RDBMS Server » Server Administration » Objects created in Tablespace
Objects created in Tablespace [message #162139] Wed, 08 March 2006 23:24 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
I created a user VIKRAM & he's assigned quota in USERS tablespace.

Then the user VIKRAM created two tables named EMP,DEPT.

Now,i wants to know what are all the objects created in USERS tablespace & who created it.Is there any view to get the reqired result?

Please anyone reply as soon as possible.

Report message to a moderator

Re: Objects created in Tablespace [message #162159 is a reply to message #162139] Thu, 09 March 2006 00:43 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Please read the manuals as soon as possible.

Report message to a moderator

Re: Objects created in Tablespace [message #162607 is a reply to message #162139] Sat, 11 March 2006 23:55 Go to previous message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
see dba_tables

Report message to a moderator

Previous Topic: init.ora file format question
Next Topic: Question about MTS_DISPATCHERS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 17:10:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.