SQL> select file_name, bytes/1024/1024 "MBYTES"
2 from dba_data_files
3 where tablespace_name='SYSTEM';

That will show you all of the data files in your SYSTEM tablespace.

Which makes me wonder. . . why do you need such a big SYSTEM tablespace? Are people writing stuff to it?

Brian

Sikyala Raquel <oracledba-ezmlmshield-x75461693.[Email address protected] wrote:
How do I find out what the size is and add the 10M?

-----Original Message-----
From: Brian Mays [mailto:[Email address protected]
Sent: Wednesday, January 31, 2007 4:40 PM
To: Sikyala, Raquel
Subject: RE: alter size of system tablespace

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


That's because you're trying to shrink the size of an existing data file
that has data in it.

Brian

Sikyala Raquel [Email address protected] wrote:
Thanks. Now I get a different error:
ORA-03297: file contains used data beyond requested resize value


-----Original Message-----
From: Zuniga, Victor [mailto:[Email address protected]
Sent: Wednesday, January 31, 2007 4:35 PM
To: Sikyala, Raquel
Subject: RE: alter size of system tablespace

Make sure you provide the whole path to the datafile.

Victor Zuniga
Database Administrator
AIM: vezuniga429


-----Original Message-----
From: Sikyala, Raquel [mailto:[Email address protected]
Sent: Wednesday, January 31, 2007 4:33 PM
To: Zuniga, Victor
Subject: RE: alter size of system tablespace

I just tried it and got another error:

ORA-01516: nonexistent log file, datafile, or tempfile "system01.dbf"

-----Original Message-----
From: Zuniga Victor [mailto:[Email address protected]
Sent: Wednesday, January 31, 2007 4:28 PM
To: Sikyala, Raquel
Subject: RE: alter size of system tablespace

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


I think the command should be

Alter database datafile 'system01.dbf' resize 10M;

Good luck.

Victor Zuniga
Database Administrator
AIM: vezuniga429


-----Original Message-----
From: Sikyala Raquel
[Email address protected]
Sent: Wednesday, January 31, 2007 4:24 PM
To: LazyDBA Discussion
Subject: alter size of system tablespace

I am trying to resize my system tablespace to at least 10M I tried the
following command and got an error:

alter tablespace system resize datafile 'system01.dbf' size 10M;

What is wrong with this statement? I get this error:

ORA-02142: missing or invalid alter tablespace option

Raquel Sikyala



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page