Hi,

I have a setup script to create a database (which works in Oracle 8) but now I am trying to get it to work in Oracle 9i and I am having some problems.
I am not sure if it is the way I have set up Oracle 9i or if it is a problem with the script.

There are 2 setup scripts, 1 to create tablespace, user and roles and the other to create the tables.

I get an error when I run the first one.

The process that I am performing is:

1. Open SQL+ and log in as SYSTEM

2. call the setup script 1 (see below)

--------------------------------------------------------------------------
setup script 1
--------------------------------------------------------------------------

create tablespace she2000_data
datafile 'd:\orant\database\she2000_data_z.dat'
size 5m reuse
/

/* create user she2000 -- modify as required */

create user she2000 identified by demo
default tablespace she2000_data
temporary tablespace temporary_data
/

grant connect, resource to she2000
/

/* create she2000 role. All required permissions are granted to this role
in the table build script */

create role she2000_role
/

grant she2000_role to she2000
/

commit
/
--------------------------------------------------------------------------


I get the following error:

ERROR at line 1:
ORA-00959: tablespace 'TEMPORARY_DATA' does not exist

If I comment the line with "TEMPORARY_DATA" out then I can go on to log in as she2000 and run setup script 2. Setup script 2 (too long to include
here) gets so far and appears to create some tables then I get this error:

ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
SHE2000_DATA

Now the line that this happens at does not appear to have anything different in it compared to the previous lines that tables were sucessfully created for.

Any ideas?