1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

TAblespaceS

Discussion in 'General' started by krithika@2001, Jun 28, 2009.

  1. krithika@2001

    krithika@2001 Active Member

    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    80
    Can anybody tell me how to create table in a particular tablespace instead of default tablespace?
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    You need to specify Tablespace name specifically for creating in a specified table space.

    Code (SQL):

    CREATE TABLE <TTable_name> (
    <Field1> <Datatype>,
    <Field2> <Datatype>,
    .....)
    TABLESPACE <Tablespace_name>;
     
    Also you can move the existing tables to difference tablespace from existing tablespace by ALTER Statement ..

    Code (SQL):

    ALTER TABLE <table_name> MOVE TABLESPACE <New_Tablespace_name>;