Re: Installing Designer

cooldude wrote:
> Guys,
> I used this SQL stmt:
>
> CREATE TABLESPACE tabletemp datafile
> 'C:\oracle\product\10.2.0\db_2\database\tabletemp01.ora' size 10 M
> temporary
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE;\
>
> and still got the same error message
>
> I then used this:
>
> CREATE TABLESPACE tabletemp datafile
> 'C:\oracle\product\10.2.0\db_2\database\tabletemp01.ora' size 10 M
> temporary
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
>
> and still got the same error!!
>
> What am I doing wrong?
>

Are you creating a temporary tablespace? Why - you have one?

create temporary tablespace tabletemp
tempfile 'C:\oracle\product\10.2.0\db_2\database\tabletemp01.ora' size 10 M autoextend on
next 1M maxsize 2000M;

Note the temporary before tablespace, and tempfile, in stead of datafile

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...