maybe u should use orasnap from a windows client???
bye
Paulo
-Original Message-
Sent: quinta-feira, 16 de Janeiro de 2003 18:36
To: Multiple recipients of list ORACLE-L
I have found many great SQL scripts to identify segments whose next extents
will not fit into their tablespace and
Title: RE: Unix Max Extent Script
search for smenu in Google ... it is a bunch of scripts with all sh interface.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
Run as stored procedure scheduled using DBMS_JOB and if an alert occurs send
it to the alert log using the procedure in DBMS_SYSTEM. I presume you
already have a system which monitors you alert logs so it should be pretty
easy to generate your email/pages without any further modification without
pace_name =
ai.tablespace_name
)order by 1,2/spool offexit
That's it!
Works Great!
R.Smith
Kerr-McGee
Corp
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday,
January 16, 2003 2:15 PMTo: Multipl
Or perhaps this...
Write a program that will manually allocate extents to each object until you
run out of space, then capture error and number of extents and write to a
flat file using UTL_FILE package. Then export object, truncate table and
import to recover the space you allocated during each
Post, Ethan wrote:
Or perhaps this...
Write a program that will manually allocate extents to each object until you
run out of space, then capture error and number of extents and write to a
flat file using UTL_FILE package. Then export object, truncate table and
import to recover the
My favorite is when people go nutty checking every possible variable in
their scripts before getting to the thing the script was actually written
for i.e...
Check to see if database sid is valid, check to see if user name is valid,
check to see if time zone on server is set, what is ambient