Re: Two fold problem please help

On Sat, 15 Dec 2001 19:52:38 +1000, Pyro3k <mrp_at_hafatel.com> wrote:

>I have a two fold problem... Being new to Oracle I am apt to make
>mistakes but please bear with me.
>
>Problem 1:
>
>ORA-01658: unable to create INITIAL extent for segment in tablespace
>SYSTEM
>
>When attempting to run select queries I receive the following
>error.... In a attempt to repair this I caused my second problem.
>
>Problem 2:
>
>sql> CREATE TABLESPACE SYSTEM DATAFILE '/SYSTEM_02.DBS' SIZE 100M;
>
>which of course worked fine... But now I have a hard disk space
>problem.
>
>Question 1: Is it possable to remove the SYSTEM_02.DBS file?
>Question2: How can I PROPERLY fix problem 1 ?

2) definitely didn't work, as you are recreating the system tablespace, which is essential to correct operation. The statement above doesn't indicate you added a datafile, it indicates you destroyed the complete dictionary if it would have worked properly. If it did work properly your database was already screwed before you ran this statement

Question 1 alter database datafile '<datafilename>' offline drop; As this is the system tablespace most likely it will screw your database

Question 2:
select temporary_tablespace
from dba_users
where username = '<your user>'
If it lists 'SYSTEM', change it into TEMP by ALTER USER <username> TEMPORARY TABLESPACE TEMP

and, oh yes, just a small advice: Try to read some manuals.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Dec 15 2001 - 05:47:02 CST