[oracle12c@uit144 Desktop]$ cd
[oracle12c@uit144 ~]$ ls
5sep.txt cr8dball.sql Desktop Music runall.sql Videos
afiedt.buf cr8db.sql Documents Pictures run.sql wipdb.sql
a.txt dba_ts.sql Downloads Public Templates
[oracle12c@uit144 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 10 15:31:30 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from dba_tablespaces;
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSTEM 8192 16384 16384 1
505 50 0 ONLINE PERMANENT LOGGING YES
DICTIONARY USER NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSAUX 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING YES
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDOTBS1 8192 65536 1
2147483645 2147483645 65536 ONLINE UNDO LOGGING NO
LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO
LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
USERS 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SALES 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDO2 8192 65536 1
2147483645 2147483645 65536 ONLINE UNDO LOGGING NO
LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP1 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO
LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
8 rows selected.
SQL> col tablespace_name for a12
SQL> /
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSTEM 8192 16384 16384 1 505
50 0 ONLINE PERMANENT LOGGING YES DICTIONARY
USER NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSAUX 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING YES LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDOTBS1 8192 65536 1 2147483645
2147483645 65536 ONLINE UNDO LOGGING NO LOCAL
SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL
UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
USERS 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SALES 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDO2 8192 65536 1 2147483645
2147483645 65536 ONLINE UNDO LOGGING NO LOCAL
SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP1 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL
UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
8 rows selected.
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb//;
create tablespace production datafile '/u01/app/oracle12c/or
*
ERROR at line 1:
ORA-01756: quoted string not properly terminated
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production.dbf' size 20m;
Tablespace created.
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m;
create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m
*
ERROR at line 1:
ORA-01543: tablespace 'PRODUCTION' already exists
SQL> create tablespace production1 datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m;
Tablespace created.
SQL> create tablespace testing datafile '/u01/app/oracle12c/oradata/wiprodb/testing01.dbf' size 512kb;
create tablespace testing datafile '/u01/app/oracle12c/oradata/wiprodb/testing01.dbf' size 512kb
*
ERROR at line 1:
ORA-02180: invalid option for CREATE TABLESPACE
=====================================================================
[oracle12c@uit144 Desktop]$ cd
[oracle12c@uit144 ~]$ cd /u01/app/
[oracle12c@uit144 app]$ cd oracle12c/oradata/
[oracle12c@uit144 oradata]$ ls
lgdb moondb skydb testdb wiprodb
[oracle12c@uit144 oradata]$ cd wiprodb
[oracle12c@uit144 wiprodb]$ ls
c2.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
control.ctl redo2a.log system.dbf undo1.dbf
production.dbf sales01.dbf temp1.dbf undo2.dbf
[oracle12c@uit144 wiprodb]$ ls
c2.ctl production.dbf sales01.dbf temp1.dbf undo2.dbf
control.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
production01.dbf redo2a.log system.dbf undo1.dbf
[oracle12c@uit144 wiprodb]$ ls
c2.ctl production.dbf sales01.dbf temp1.dbf undo2.dbf
control.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
production01.dbf redo2a.log system.dbf undo1.dbf
[oracle12c@uit144 wiprodb]$
[oracle12c@uit144 ~]$ ls
5sep.txt cr8dball.sql Desktop Music runall.sql Videos
afiedt.buf cr8db.sql Documents Pictures run.sql wipdb.sql
a.txt dba_ts.sql Downloads Public Templates
[oracle12c@uit144 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 10 15:31:30 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from dba_tablespaces;
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSTEM 8192 16384 16384 1
505 50 0 ONLINE PERMANENT LOGGING YES
DICTIONARY USER NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSAUX 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING YES
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDOTBS1 8192 65536 1
2147483645 2147483645 65536 ONLINE UNDO LOGGING NO
LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO
LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
USERS 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SALES 8192 65536 1
2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO
LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDO2 8192 65536 1
2147483645 2147483645 65536 ONLINE UNDO LOGGING NO
LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR
----------- ---------- ------------ ---------- --------- --------- --------- ---
EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
---------- --------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP1 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO
LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
8 rows selected.
SQL> col tablespace_name for a12
SQL> /
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSTEM 8192 16384 16384 1 505
50 0 ONLINE PERMANENT LOGGING YES DICTIONARY
USER NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SYSAUX 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING YES LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDOTBS1 8192 65536 1 2147483645
2147483645 65536 ONLINE UNDO LOGGING NO LOCAL
SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL
UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
USERS 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
SALES 8192 65536 1 2147483645
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
UNDO2 8192 65536 1 2147483645
2147483645 65536 ONLINE UNDO LOGGING NO LOCAL
SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TABLESPACE_N BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------ ---------- -------------- ----------- ----------- -----------
MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
---------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC
--------- --- ------ -------- ----------- --- ------- ---
COMPRESS_FOR
------------------------------
TEMP1 8192 1048576 1048576 1
2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL
UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
8 rows selected.
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb//;
create tablespace production datafile '/u01/app/oracle12c/or
*
ERROR at line 1:
ORA-01756: quoted string not properly terminated
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production.dbf' size 20m;
Tablespace created.
SQL> create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m;
create tablespace production datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m
*
ERROR at line 1:
ORA-01543: tablespace 'PRODUCTION' already exists
SQL> create tablespace production1 datafile '/u01/app/oracle12c/oradata/wiprodb/production01.dbf' size 20m;
Tablespace created.
SQL> create tablespace testing datafile '/u01/app/oracle12c/oradata/wiprodb/testing01.dbf' size 512kb;
create tablespace testing datafile '/u01/app/oracle12c/oradata/wiprodb/testing01.dbf' size 512kb
*
ERROR at line 1:
ORA-02180: invalid option for CREATE TABLESPACE
=====================================================================
[oracle12c@uit144 Desktop]$ cd
[oracle12c@uit144 ~]$ cd /u01/app/
[oracle12c@uit144 app]$ cd oracle12c/oradata/
[oracle12c@uit144 oradata]$ ls
lgdb moondb skydb testdb wiprodb
[oracle12c@uit144 oradata]$ cd wiprodb
[oracle12c@uit144 wiprodb]$ ls
c2.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
control.ctl redo2a.log system.dbf undo1.dbf
production.dbf sales01.dbf temp1.dbf undo2.dbf
[oracle12c@uit144 wiprodb]$ ls
c2.ctl production.dbf sales01.dbf temp1.dbf undo2.dbf
control.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
production01.dbf redo2a.log system.dbf undo1.dbf
[oracle12c@uit144 wiprodb]$ ls
c2.ctl production.dbf sales01.dbf temp1.dbf undo2.dbf
control.ctl redo1a.log sysaux.dbf temp.dbf users.dbf
production01.dbf redo2a.log system.dbf undo1.dbf
[oracle12c@uit144 wiprodb]$
No comments:
Post a Comment