Try this to get the full space of the system datafile

SELECT file_id, tablespace_name, file_name, BYTES / 1048576 total_mb
FROM dba_data_files
WHERE tablespace_name = 'SYSTEM';

After you get the space, use this to resize that datafile...make sure
the size is what you get above, plus what you want to add to it.

ALTER DATABASE DATAFILE '/fullpath to datafile/system.dbf' RESIZE 1000 m;

Sikyala Raquel wrote:
> 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
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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