Home » SQL & PL/SQL » SQL & PL/SQL » How do i know the tablespace is using the current user?
icon2.gif  How do i know the tablespace is using the current user? [message #197169] Tue, 10 October 2006 05:54 Go to next message
txeriff
Messages: 2
Registered: October 2006
Junior Member
hi

is there any way to know the tablespace is using the current logged user? or what tablespace is using a table?
i mean:
i have 2 users. 'user 1' has some tables but dont know what tablespace is using and i would like the second user can access to these tables.(i supose are in different tablespaces)

any idea?


another question:
where oracles stores the logs after update, delete... a row??

[Updated on: Tue, 10 October 2006 05:56]

Report message to a moderator

Re: How do i know the tablespace is using the current user? [message #197171 is a reply to message #197169] Tue, 10 October 2006 06:01 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Access to tables has nothing to do with which tablespace they are on. If you want usr2 to have access to the tables, use the grant command to give it select access.

To find out which tablespace a table belongs to, do a select from all_tables or sys.dba_tables for the user.table in question.
Re: How do i know the tablespace is using the current user? [message #197172 is a reply to message #197171] Tue, 10 October 2006 06:05 Go to previous messageGo to next message
txeriff
Messages: 2
Registered: October 2006
Junior Member
ok thanks ill try.
do you know anything about oracle logs, (where stored etc)
any link?

thanks
Re: How do i know the tablespace is using the current user? [message #197176 is a reply to message #197169] Tue, 10 October 2006 06:09 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
"SELECT * from v$logfile" will tell you where they are. Consult the manual for more information.
Re: How do i know the tablespace is using the current user? [message #197179 is a reply to message #197176] Tue, 10 October 2006 06:33 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Although there's not a great deal you can do with the location of the Redo Logs, unless you want to use LogMiner (and I think that finds the logs for you)
Previous Topic: passing recorset as a parameter
Next Topic: validate address
Goto Forum:
  


Current Time: Sun Dec 04 06:20:34 CST 2016

Total time taken to generate the page: 0.10230 seconds