-----Original Message-----
Hi Ari,

I'm trying to run Oracle Expert, but I'm getting the following error:

(image included)

Please help.

Regards
Marius de Beer
ATIO Corporation

---- Reply --------
You were getting the ORA-1658 error: unable to create INITIAL extent for segment
in tablespace TEMP.
This means that your TEMP tablespace is too small/fragmented or your default
storage parameters for the TEMP tablespace is too large.

1) To see the size of TEMP:

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'TEMP';

2) To see the default storage of TEMP:

SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'TEMP';

3) To see fragmentation of TEMP:

SELECT * FROM DBA_FREE_SPACE WHERE TABLESPACE_NAME = 'TEMP';

If there are many "FREE SPACE"s then you can try coalescing the contiguous free
space:

ALTER TABLESPACE TEMP COALESCE;

Try #3 again to see if the number of "FREE SPACE"s has been reduced.

Also, if the size of the INITIAL EXTENT in #2 is greater than the size of the
smallest datafile in #1, then you can either decrease the INITIAL size or
increase the tablespace size. To decrease the INITIAL:

ALTER TABLESPACE TEMP STORAGE (INITIAL 2M);

(or replace 2M with what is appropriate)

To increate the tablespace size:

ALTER TABLESPACE TEMP ADD DATAFILE '/u01/oradata/DB/temp02.dbf' SIZ E 500M;

You will have to specify the correct path and size.

Best of luck,

-Ari Kaplan
www.arikaplan.com                       

Back to Ari Kaplan's Home Page ="../index.htm"> Back to Ari Kaplan's Home Page