Search results for query: *

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...

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 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...

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...

I tried to kill a user session and it shut down my database!!!! Here's what I did - I had logged into Enterprise Manager, selected the session I wanted to end, and clicked the kill session button. I received an error to the effect of "can't close session" and I clicked the cancel button...

Last Friday, my Oracle 9i production database shut itself down during the middle of the workday...never happened before in the 4 months we've been live with Oracle. After examining the alert log file, I found the following error caused the database to shutdown: Fri Dec 30 13:51:16 2005 Errors...

I have an address string (ex. Rural Route 12 Box 204) that I need to break into individual address components - i.e. Rural Route 12 as the street and 204 as the box. The easiest way I can see to do this is to start reading the string at the beginning, somehow get the end position of the first...

I don't understand what the purpose of the "key string" is in the procedure...Can anyone fill me in? Here are the parameter names, mode, type, and description of the input parameters: input IN RAW Data to be decrypted key IN RAW Decryption key decrypted_data OUT...

I'm trying to create (what I thought would be) a simple procedure to Base64 encode a password using the utl.encode.base64_encode function. When I try to compile the procedure, I receive the following error on the "UTL.ENCODE.BASE64_ENCODE..." line - PLS-00103: Encountered the symbol "RAW"...

I've created a simple stored procedure in Oracle 9i which requires 1 input parameter (i_date_registered) and returns 1 output value (o_grant_access). The procedure works fine when running from sqlplus and seems to run fine from my ASP page until I try to access the o_grant_access value....then I...

I'm trying to use a function in the select statement for a view to return a value which will be a column in the view. The function compute and returns a value when I run it alone, but inside the Select statement it causes my view to not return any rows. Not sure what I'm doing wrong. Any...

I've got a select statement in a .asp page which retrieve information from a view. In some cases, the query will return more than 1 row. When this happens, I need to read all of the rows returned, not just the first row. How can I do this? Thanks!

I'm need to have a unique record number for each row that a Select statement returns (i.e. - 1 for the 1st record, 2 for the second record, etc.). I've been attempting to do this via "Count", however I am receiving the same record number (1) for each row returned. SELECT COUNT(*) "RecNum"...

I have a field in a view called 'cr_dr' which contains 'CR' (for credit) and 'DR' (for debit). I'm attempting to create another view that references the first view and would like it to contain '+' instead of 'CR' and '-' instead of 'DR'. I've tried to do this via the Replace and Translate...

I'm creating a .asp page in which a customer will enter his address info (house number, street direction, street name, street type, post direction, apartment, and zip). The page will then attempt to verify whether or not the address exists in a view via a Select statement on all of these...

I'm attemping (newbie) to create a view with the following statement: CREATE OR REPLACE VIEW vw_web_registrations AS SELECT addr.address.house, addr.address.fst_dir, addr.address.street, addr.address.street_suffix, addr.address.snd_dir...

A little background....I'm using Oracle 9i on a Windows 2003 server It seems like I've read somewhere that it is a good rule of thumb not to make datafiles over 2 GB for performance reasons. Can someone explain this to me in a little more detail? Currently, I have a datafile that is 4 GB, of...

Is it ok to do a full export of a database while users are connected to that database? Any drawbacks?

I'm new to Oracle so please forgive my ignorance... Is there a way to export the data from a single table of "database A" and then import it into an empty table that is structured the same in "database B"? I know a little about exporting/importing the whole database, so is there a different...

I'm receiving the following error after logging into Toad and selecting "Database" from the menu bar and then "Schema Browser": 26 is an invalid PageIndex value. PageIndex must be between 0 and 25. After clicking ok, I receive another error: Error reading lvTables.ShowColumnHeaders: Invalid...