Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

From: Bart Breggeman <bart.breggeman_at_cmg.nl>
Date: 1997/12/12
Message-ID: <01bd06e7$a35af0a0$147c100a@nl-den-lap0652>#1/1 







The system tablespace is only meant for system tables. So you have nothing
to do with it.


You have to create a new tablespace for the user data.



Like this:



CREATE TABLESPACE custspace DATAFILE 'lokation and name of your file'
SIZE 10M DEFAULT STORAGE (INITIAL 500K NEXT 500K MAXEXTENTS 100);


Good luck BB
Received on Fri Dec 12 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US