Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: tablespace in CREATE table statement

    Hi,

    Below is an DB2 DDL :

    create table test(col1 int) in tablespace_name;

    Is there any equivalent for the above clause "in tablespace_name" in the CREATE TABLE syntax in Oracle.

    Please advice,

    Thanks,
    Sam

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Yes - but considering your other post about the CLOB storage it would be worth you looking up the 'STORAGE' clause of the create table command. It's too complex to go into here.

    Code:
    CREATE TABLE MYTABLE
      (
      SomeColumns....
      ) TABLESPACE SOME_TABLESPACE;
    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •