I tried it exactly the way it is in the email and got an error. I
removed the "MBYTES" and then I got the file_name and the
bytes/1024/1024 which has a value of 270. So would I resize to 280?

________________________________

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


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

"Sikyala, Raquel" <[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






Oracle LazyDBA home page