Difference between revisions of "Oracle/Create tablespace"
Jump to navigation
Jump to search
(New page: <source lang="oracle11"> CREATE TABLESPACE TEST LOGGING DATAFILE 'D:\Programme\oraclexe\oradata\XE\TEST.DBF' SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAG...) |
|||
| Line 1: | Line 1: | ||
<source lang="oracle11"> | <source lang="oracle11"> | ||
CREATE TABLESPACE TEST LOGGING | CREATE TABLESPACE TEST LOGGING | ||
DATAFILE ' | DATAFILE '/usr/lib/oracle/xe/oradata/XE/test.dbf' | ||
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED | SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED | ||
EXTENT MANAGEMENT LOCAL; | EXTENT MANAGEMENT LOCAL; | ||
CREATE TEMPORARY TABLESPACE TEST_TEMP | CREATE TEMPORARY TABLESPACE TEST_TEMP | ||
TEMPFILE ' | TEMPFILE '/usr/lib/oracle/xe/oradata/XE/test_temp.dbf' | ||
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED | SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED | ||
EXTENT MANAGEMENT LOCAL; | EXTENT MANAGEMENT LOCAL; | ||
Revision as of 15:25, 16 January 2011
CREATE TABLESPACE TEST LOGGING
DATAFILE '/usr/lib/oracle/xe/oradata/XE/test.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE TEST_TEMP
TEMPFILE '/usr/lib/oracle/xe/oradata/XE/test_temp.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
ALTER USER TEST
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE TEST_TEMP;