I am at home now,  Tomorrow I will get the exact Oracle syntax and post
example commands for CREATE TABLESPACE, CREATE DATABASE, CREATE TABLE
and CREATE INDEX, CREATE USER.  



Jim





>  
> > Since "tablespace" is not part of the SQL standard, maybe it makes
> sense to
> > define a more specific syntax. The term "location" makes sense,
> because it is
> > not a tablespace as Oracle defines it.
> 
> It *is* an "OS managed tablespace" in terms of IBM DB2.
> Methinks the term "TABLESPACE" is perfect for PostgreSQL.
> The fact whether it is a directory, a file or even a raw device
> depends on how you create the tablespace.
> 
> The point is, that the syntax for "create table" and "create index"
> can be compatible in this case, imho without confusing many. 
> Not the "create tablespace" syntax, but that is imho not an issue.
> 
> Andreas
> 
> 



Thu, 8 Nov 2001 17:08:00 -0500
"Jim Buttafuoco" <jim@buttafuoco.net>
Re: Storage Location Patch Proposal for V7.3