From: "Bart Breggeman" <bart.breggeman@cmg.nl>
Subject: Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces
Date: 1997/12/12
Message-ID: <01bd06e7$a35af0a0$147c100a@nl-den-lap0652>#1/1
Sender: nntp@atf.cmg.nl (NetNews Transport Daemon)
References: <3490ad31.150319158@news.visi.net>
X-Nntp-Posting-Host: 10.16.124.20
Organization: CMG Den Haag B.V.
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server



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