Recent content by kwil38

Santa, My apologies, I had not noticed that feature but just utilized it for Dagon and also will in future posts. kwil38

Dagon - Thanks, that works perfect!

I have a table defined as follows: Row_id NUMBER Email VARCHAR2(50) Option_Name VARCHAR2(2000) Option_Value_1 VARCHAR2(2000) Option_Value_2 VARCHAR2(2000) Last_Update_Date DATE I need to create a function that will return all rows (there could be 1 or many) for a...

Sorry, I wasn't very clear on what I needed. I'm using Netbackup (which in turn uses RMAN) to backup my database. I don't want to create and run the backup from OEM, only to create a job which simply deletes archivelogs that have been backed up 3 times. Is that possible?

I am using Oracle 10g and RMAN on Linux. Is there a way to automatically delete archivelogs that have been backed up 3 times via OEM or a script? Currently, I'm deleting them manually with the following: rman catalog=rman/*****@RMAN target=netbackup/******@PROD RMAN> delete archivelog all...

I'm not aware of an equivalent to the UNIX command date, but I'm still pretty new to the Windows/Oracle game as well. Anyone else have an idea? As far as declaring a variable goes, you should be able to do anything in the .sql file that you can do in SqlPlus. So you declare a variable as...

Can you not use SYSDATE in your execute statement - execute my_proc(SYSDATE); Depending on which version of Windows you are using (I'm on Windows Server 2003 Enterprise Edition), it may be slightly different but - 1. Go to Start/All Programs/Accessories/System Tools/Scheduled Tasks 2...

IMAUser, Typically what I do is create a batch script which calls a sql script. Then the batch script can be scheduled to run accordingly via Windows Scheduled Tasks. For example, I have a batch script file called drop_employees.bat which contains the following line of code - sqlplusw...

Worked perfectly! Thanks a lot!

I'm testing my backup and recovery strategy and am stuck on the following scenerio - The production server crashes and I have to recover a database named 'prod' onto another server and a database called 'test'. I have successfully recovered from the last cold backup by restoring the datafiles...

Carp - Yes, I did have to rebuild the indexes associated with each table.

Just a follow-up.... I used the 'ALTER TABLE <tablename> MOVE PARALLEL NOLOGGING;' to give the space back to the tablespace and all worked fine. No adverse effects whatsoever. Thanks a lot guys!

Santa - After thinking on it, I may have changed my mind. The 'ALTER TABLE <tablename> MOVE PARALLEL NOLOGGING;' sounds like it would be the easiest approach and would free the space for other tables in the tablespace to use. At the rate our database grows, that space would be utilized fairly...

Thanks for the info guys. Santa - #2 is what I'd like to do. I've also been researching the ALTER TABLESPACE tablespacename COALESCE; command. However, if I'm understanding correctly, it won't actually decrease the size of my tablespace, it will just group free extents together.....sort of...

I have purged some old data out of a couple of tables, all of which belong to the same tablespace. After doing this, I expected my tablespace size to decrease, however it remained exactly the same. Is there another step or a compression utility that I need to run to reclaim this space...