Re: Current Tablespace

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Wed, 15 Dec 1999 19:16:04 GMT
Message-ID: <3857E9B1.70BE5EFE@lds.com>

To find out what is the users default TS look in dba_users.

To find out what is the table TS look in all_tables or user_tables.

elizabeth1000_at_my-deja.com wrote:

> I knew this is a beginner question, but I'm just begining in Oracel.
>
> How can I determine my current tablespace? The Oracle Migration tool
> from Access created a tablespace for each load, the data is now in the
> permanent table and I want to drop all the tablespaces except for one
> which I am currently using.
>
> Also when you drop user cascade is there a way to drop their tablespace
> too?
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--

---

Marc Weinstock
Logical design Solutions

55 Broadway - 21st Floor
New York, New York 10006

Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com Received on Wed Dec 15 1999 - 13:16:04 CST