Create tablespace in Oracle

You can create a tablespace by using create tablespace command:
Create tablespace tablespace_name
        datafile 'file_name' size 10m
autoextent on next 5m maxsize 200m; 

We recommend that you include the following in the datafile name when you create the tablespace:
  1. The name of the database
  2. The name of the tablespace
  3. A number that makes the datafile unique
create tablespace tbs
     datafile '/opt/luck/tbs01.dbf ' size 100m
autoextend on next 5m maxsize 200m;

People who read this post also read :


Post a Comment


Twitter Delicious Facebook Digg Stumbleupon Favorites More