Re: Create table right

create table <tablename>
(<columns>)
tablespace <tablespace_name>

that easy.

Reinier

Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:39b791d8.842005359_at_news.alt.net...
> How do you decide which tablespace the table is created in? Which
> schema?
>
> Imagine I have
>
> 1) two users.
> a) User_1
> b) User_2.
>
> 2) two tablespaces
> a) TB_1
> b) TB_2.
>
> 3)
> a) User_1's default tablespace is TB_1
> b) User_2's default tablespace is TB_2.
>
> i) How does User_1 create a table in TB_2.
> ii) How does User_1 create a table in User_2's schema.
>
>
> Brian
Received on Mon Sep 11 2000 - 04:51:23 CDT