Oracle/Create tablespace

From YavInWiki
Revision as of 15:25, 16 January 2011 by Andy (talk | contribs)
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;