Home » SQL & PL/SQL » SQL & PL/SQL » Locally Managed TableSpaces
Locally Managed TableSpaces [message #19607] Mon, 01 April 2002 09:36 Go to next message
uma
Messages: 67
Registered: May 2001
Member
How do I know whether my tablespaces are Dictionary Managed Tablespace or Locally Managed Tablespace?

Thanks,

Uma
Re: Locally Managed TableSpaces [message #19608 is a reply to message #19607] Mon, 01 April 2002 09:41 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select * from user_tablespaces;


and look at the extent_management column.
Previous Topic: insert value into table is not working
Next Topic: Select Values from table A that are not in table B
Goto Forum:
  


Current Time: Thu Mar 28 18:39:34 CDT 2024