Oracle/Create tablespace
Jump to navigation
Jump to search
CREATE TABLESPACE TEST LOGGING
DATAFILE 'D:\Programme\oraclexe\oradata\XE\TEST.DBF'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE TEST_TEMP
TEMPFILE 'D:\Programme\oraclexe\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;