Reducing datafile size

Hi all, I've dropped a couple of tables from my DB -how do I coalesce the tablespace to have the associated datafile reduced in size ? Thanking you, ___ CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network

Media Recovery needed

-01110: data file 5: '/data1/oradata/flag/userdata01.dbf' How can recover datafile to get DB Up in the next 2 hours or else Thanking you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Media Recovery needed

, 2002 4:43 AM To: Multiple recipients of list ORACLE-L On 2002.05.25 19:48 Simon Waibale wrote: Hi all, In dire need of help right now -leave all that U R doing and help!! Hot Backup process cancelled and while re-starting the DB, following errors occur: 1)ORA-00304: requested

RE: snapshot too old error - strange

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Recreating TEMP

; CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RMAN DB startup/shutdown scripts

by the instance Recovery Manager complete. Wed Jul 3 15:59:10 EAT 2002 End of Script-- exit 1 ===EOF(*.sh.out)= === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale

LGWR Error

Hi all, My instance was terminated by the LGWR bg process and the trace files reference error 7211, which I don't think is an oerr. Any clue about the possible cause ? --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat

RE: LGWR Error

files to Oracle support. Has your database restarted OK? Regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: How to read user dump file

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: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network

RE: HELP HELP HELP HELP !!!!!!

FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

ORA-00600: internal error code, arguments: [qkaPIdsqkn1]

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT - Linux question

') 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: Simon Waibale INET: [EMAIL

Partitioned oracle tables

: Oracle 81700 on Tru64 Unix Thanking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Constraints

(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: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

UNIX Courses

Hi all, What Unix courses/modules would you recommend for a budding Oracle DBA Thanx, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: UNIX Courses

with the command interface, and looking to move beyond the user tutorials? Simon: Much Linux, Little Unix Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] Simon: Thanking you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City

RE: UNIX Courses

ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Paging problem in SunOS

Hi Pradyut, Check the distribution of your DB on your disks: -Do U have multiple /raided Disk sub-system ? -If so, what is your lay out in as tablespace datafile(s) location, index datafile location, redo logs file location etc If possible post the above for an analysis of the same.

DB Size

Hi all, How could one collect data from an Oracle Server to respond to the question: How big is (what is the size of your) Database ? Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network

RE: DB Size

, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

TEMP tablespace growing abnormally -Sort Area

further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

TEMP tablespace growing abnormally

still has PARALEL_SERVER=TRUE, only one node is active. I've seen a refernce to OPS in relation to de-allocation of extents but can't get further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED

RE: TEMP tablespace growing abnormally

: Simon Waibale 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

RE: TEMP tablespace growing abnormally -Sort Area

will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: TEMP tablespace growing abnormally -Sort Area

, only one node is active. I've seen a refernce to OPS in relation to de-allocation of extents but can't get further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services

Compressing Export Dumps

Hi all, My export dumps are too big (80 GB) for my filesystem and I'm looking for a way to compress them on the fly -ie without taking *.dmp to disk first but straight *.dmp.gz Anybody with an idea on how to archive this ? Thanking you, --- CSW •æ¬zǞ¶¨}øœ‰©ND‹±@Bm§ÿðÃ

RE: Compressing Export Dumps

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: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network

RE: Re[2]: Compressing Export Dumps

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Compressing Export Dumps

as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared Simon Waibale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/16/2002 02:38

Calling SQL statement

+---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Failed login attempts

+---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Cronjob misbehaving

. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City

RE: Cronjob misbehaving

ORACLE-L Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH. Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated every day ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Simon Waibale [EMAIL PROTECTED

RE: Cronjob misbehaving

, etc.) -- James Simon Waibale wrote: Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh /ops/scripts/recompile.log 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh