Create a tablespace script in oracle

Create a tablespace script in oracle

Preface:

Previously, we used oracle tools to generate tablespaces. Today we see a more convenient and fast way to use database scripts.

/* Divided into four steps * // * Step 4: create a temporary tablespace */create temporary tablespace airforce34 tempfile 'd: \ date \ airforce34.dbf' size 1st m autoextend on; -- delete temporary TABLESPACE: DROP tablespace airforce34 including contents and datafiles;/* Step 4: create a data table space */create TABLESPACE airforce34 datafile 'd: \ date \ airforce34.dbf 'size 100 m autoextend on;/* Step 4: create a user and specify the tablespace */create user airforce34 identified by airforce34default tablespace airforce34;/* Step 4: grant User Permissions */grant connect, resource, dba to airforce34;