General information
Title:
Problem creating database in Oracle 9i
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only