Hi,

About the error:

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

You don't have a tablespace with this name on your new server.
The default temporary tablespace is called TEMP so try that or create on
called TEMPORARY_DATA or leave it out because you don't need it..(It will take the default...

about the error

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

I can see that the she2000_data tablespace is very small...
Just make it bigger. (Use something like:

create tablespace she2000_data
datafile 'd:\orant\database\she2000_data_z.dat'
SIZE
10M DEFAULT STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS UNLIMITED);

This will cause it to extend when it needs more space...And preallocates
this intial extent it's complaining about to 10 instead of 5...

You could also just try...

HTH



I'm not sure why you used the reuse clause but I donh't think it's what you want.







> 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?