Oracle/Create tablespace
Jump to navigation
Jump to search
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;