Oracle/Create tablespace

From YavInWiki
Revision as of 08:23, 31 August 2010 by Andy (talk | contribs) (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...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;