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
>
>