RE: how to rename a database SID

Title: how to rename a database SID Hear are the steps (on Unix),   Correct me if i am wrong.   1. Connect to svrmgrl, 2. Execute "alter database backup controlfile to trace;" 3. Find the trace file in udump directory. Edit the file and remove all unwanted lines i.e up to line "create cont

RE: Oracle 9i Install

Title: RE: Oracle 8i database & ER diagram I did install 9i successfully Y'day on Sun. Here are the steps to Follow as (copied from OTN),   Directions   1. After downloading the software, gunzip it.   2. Create directories Disk1, Disk2 and

How to launch Oracle Management Server

Hi, Just installed 9i on Unix (sun Solaris). Can you tell me how to launch Oracle enterprise manager On Unix. I couldn't find svrmgrl. Where can I find the document on this (i.e. major changes in 9i with respect to 8). I am trying to find in OTN. Thanks in Advance Uday winmail.dat

RE: BACKUP CONTROLFILE TRACE

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

How to remove corrupted blocks from datafile.

Hi, I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows

RE: PL/SQL Exception

g: 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: udaycb INET: [EMAIL PROTECTED] Fat City Network Services--

client for Progress

Hi All, I want to know which is the tool for Progress (Where I can connect to database and create objects, insert data, query the data etc..), similar to SQL*Plus in Oracle?. Thanks in advance Uday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: udaycb INET: [EMAIL

RE: Urgent: How to Automate Procedure Execution

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

Need Help.

Hi All, Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now this database is going online very soon. When we were testing we observed that, the application (select statement) is running very slow. (I don't know how fast it was earlier). I have a feeling that it is not using in

RE: row count in table ?

-- Author: udaycb 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,

RE: Import issue..

te 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://w

RE: How to get rid off file permanently?

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

RE: index on table with 3 million rows ???

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

RE: Full import from Oracle 7.3.4 on NT to Solaris 8.1.7

ssage 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: udaycb INET: [EMAIL PROTECTED]

RE: Database / OS monitoring tool

orafaq.com -- Author: udaycb 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,