Re: NEWBIE Q: Personal Oracle 7.3 and Tablespaces

Use the following SQL statement from a DBA account:

create tablespace custspace datafile 'XXX' size YYY;

Where XXX is the full drive, directory, and file name for the file you use for the tablespace and YYY is the number of megabytes followed by the character M for megs.

Michael Abbey
Co-author Oracle: A Beginner's Guide

davibal.removethis_at_removethistoo.regent.edu (DB) wrote:

>I'm going through _Oracle: A Beginner's Guide_ with PO7.3.3 and
>SQL*Plus 3.3.3 on Win95. I try the following SQL statement (from
>Chapter 5 if you're keeping track) and get an error:
>
>----------------------------------------------------------
>Personal Oracle7 Release 7.3.3.0.0 - Production Release
>With the distributed and replication options
>PL/SQL Release 2.3.3.0.0 - Production
>
>SQL> create table customer(
> 2 last_name varchar2(30) not null,
> 3 state_cd varchar(2),
> 4 sales number)
> 5 tablespace custspace
> 6 storage(initial 25k next 25k minextents 1);
>create table customer(
>*
>ERROR at line 1:
>ORA-00959: tablespace 'CUSTSPACE' does not exist
>
>
>SQL>
>
>----------------------------------------------------------
>
>For the life of me, I cannot figure out how to create a tablespace in
>addition to the SYSTEM table space that already exists. Any ideas?
>
>All help is appreciated.
>
>db
Received on Thu Jan 08 1998 - 00:00:00 CST