Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    137

    Unanswered: When to create Tablespace?

    Hi,

    I would like to ask when do you recommend to create Tablespace? for example, what if my database is becoming large? should I create multiple tablespaces?


    Thanks,
    Jassim

  2. #2
    Join Date
    Sep 2016
    Location
    Pune
    Posts
    16
    The CREATE TABLESPACE statement is used to allocate space in the Oracle database where schema objects are stored.

    The CREATE TABLESPACE statement can be used to create the 3 kinds of tablespaces:

    1. Permanent Tablespace
    2.Temporary Tablespace
    3. Undo Tablespace
    create tablespace ts_something
    logging
    datafile '/dbf1/ts_sth.dbf'
    size 32m
    autoextend on
    next 32m maxsize 2048m
    extent management local;

Posting Permissions

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