Re: How to shrink a table?

From: David Rueter <drueter_at_assyst.com>
Date: Thu, 30 Jul 1998 08:01:51 -0700
Message-ID: <6pq29h$eap$1@news01.deltanet.com>

I thought I might have to do something like that...

I haven't worked with multiple tablespaces. How do I specify the tablespace:
1) in the CREATE TABLE statement, and
2) in a select statement (i.e. if i want to do a join between 2 tables in different tablespaces)

Thanks for the help.

David.
drueter_at_assyst.com

>If you don't have the space in the tablespace for the temp_tab just specify
>in the create table statement
>another tablespace!!!
>
>I hope this helps!!
>
>Nevin Hahn
>ICG Communications
Received on Thu Jul 30 1998 - 10:01:51 CDT