alter table table_name move tablespace target_TS storage (initial bloody_big_number rest_of_Storage_clause) pctfree nn ;
HTH. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia -----Original Message----- Sent: Thursday, 6 June 2002 1:28 AM To: Multiple recipients of list ORACLE-L 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. -- Alexandre > 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@beaconhouse To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > .edu.pk> cc: (bcc: Jack van > Zanen/nlzanen1/External/MEY/NL) > Sent by: Subject: Urgent: Retrieving > Disk Space > [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
