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_at_nl-den-lap0652>#1/1
Date: 1997/12/12
Message-ID: <01bd06e7$a35af0a0$147c100a_at_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);