| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent: Retrieving Disk Space
Thank you all very, very much.
Indeed, ORACLE-L is a great place to share problems and the solution.
Ferenc, can you give the exact syntax of the command please?
Thanks,
Aleem
-----Original Message-----
Sent: Wednesday, June 05, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: Retrieving Disk Space
Why don't you try to 'alter table move' the table to the tablespace it should be in. If no other objects are beyond the block of the block 0 of the segment, you should be able to resize the system01.dbf file. If something else got created and is owned by SYS beyond the last block of this dubious segment, I guess you are SOL.
alternative is to export the entire DB, re-create it, and give NO mortal user any quota on SYS, period. The import it. Since you're only talking 7 GB of which most is crap anyway, this should not be a problem.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
-----Original Message-----
Sent: Tuesday, 4 June 2002 2:49 AM
To: Multiple recipients of list ORACLE-L
> The size of System01.dbf has grown from 1GB to 4GB
Try to never make a user with the SYSTEM as a default tablespace, neither
create files there, which is probaly your case.
-- AlexandreReceived on Thu Jun 06 2002 - 03:28:18 CDT
> The size of temp01.dbf is around 1GB now.
>
> Best Regards,
>
> Aleem
>
> -----Original Message-----
> Sent: Tuesday, June 04, 2002 1:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Urgent: Retrieving Disk Space
>
>
> Hi
>
>
> What has grown?
>
>
> you don't mention datafiles. So if there is only the three types of files
> you mention there I can only assume that the part that has grown is the
> number of archive logs. These are needed for recovery since last backup
and
> can not be thrown away. can be zipped though.
>
> If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses
direct
> load and does not create so much redo (archives) and is faster as well
>
>
>
> Jack
>
>
>
>
> Abdul Aleem
>
> <dmit_at_beaconhouse To: Multiple
recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> .edu.pk> cc: (bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)
> Sent by: Subject: Urgent:
Retrieving
> Disk Space
> root_at_fatcity.com
>
>
>
>
>
> 04-06-2002 09:58
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
> Hi!
>
> Our Oracle database is installed on second partition of the drive capacity
> 7GB. Last night one the developers executed a query to create and populate
> a
> table from another table. The query wasn't successful i.e., the table
> couldn't get created.
>
> However the database size has grown enormous almost occupying the whole
> disc
> space.
>
> There are control files, redo log files, archive log files.
>
> What to do?
>
> TIA!
>
> Aleem
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
> INET: dmit_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> ==================================================================
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de
verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =====================================================================
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable
for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> ===================================================================
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack van Zanen
> INET: nlzanen1_at_EY.NL
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
> INET: dmit_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: alexandre.gorbatchev_at_avermann.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: fmantfeld_at_siebel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: dmit_at_beaconhouse.edu.pk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |