OraFAQ Forum: SQL & PL/SQL » Table Space Name

Home » SQL & PL/SQL » SQL & PL/SQL » Table Space Name

Mon, 25 February 2002 09:10

Ravinder J Reddi
Messages: 1
Registered: February 2002

Junior Member

What is the command to find the current table space name ?

Thanks

-- Ravindra

Mon, 25 February 2002 09:34

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Do you mean the default tablespace for the current user? If so:

select default_tablespace
  from user_users;

Sat, 02 March 2002 09:05

roberto
Messages: 10
Registered: February 2002

Junior Member

I have to create a tablespace for index(primary key)on tables and I'd like to know how calculate the size of tablespace.Thnk's

Previous Topic:	SQL INSERT INTO ERROR
Next Topic:	Numerical calculation problem...

Goto Forum:

]

Current Time: Tue Apr 23 03:51:59 CDT 2024