create control file failed

Hi All I am recreating the database from cold backup. But I am facing the following problem Oracle version : 8.1.7 Environment : HP SVRMGR CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 32 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 254 5 MAXINSTANCES 8

RE: create control file failed

is the size in bytes of /oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from backup? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote: I am recreating the database from cold backup. But I am facing the following problem Oracle version

RE: Problem starting Oracle on W2K

-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN: One Catalog DB .. different target db releases

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.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: windows application to show sql being executed by a client

Title: windows application to show sql being executed by a client program Hi Jacques The tool is very good and usefull. I suggest try to include explain plan for every SQL statement captured. Thanks Banarasi -Original Message-From: Deshpande, Kirti [mailto:[EMAIL

RE: Problem with LONG column

Hi allThank you very much for all your suggestions.I already experimented with copy command. But I failed Following is the output..SQL copy from qest/qest@ndlp to scott/tiger@test1 - append contacts_new using select * from contacts;Array fetch/bind size is 15. (arraysize is 15)Will commit

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Lisa There is no harm in using TIMED_STATISTICS=TRUE. I was using that on same environment thanks Banarasi -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 7:54

Problem with LONG column

Title: Which rollback segment is currently active? Hi everyone One of my development team is working on ORACLE 8 on NT (Because of client requirement they are working on that version). One Table was created with wrong column name. Nowthey wanted me to correct the column name. But real

Migration from SQL Server to ORACLE 9i

-- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: ORA-04098 Problem - Any Ideas??

Title: ORA-04098 Problem - Any Ideas?? Hi Denham EVa Try SQL ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ COMPILE ; -- If recompilation fails or if you are still not able to connect, disable the trigger SQL ALTER TRIGGER SYS.JIS$ROLE_TRIGGER$ DISABLE ; then your command thanks Banarasi Babu

RE: strange behaviour of sequence

(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.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: books recommendations

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: books recommendations

-- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: RE: Another simple question

-L Hi All Why name of the Database is restricted to 8 bytes. where as we can have long names for tablespaces, tables, views, etc ? thanks Banarasi Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network

Another simple question

Hi All Why name of the Database is restricted to 8 bytes. where as we can have long names for tablespaces, tables, views, etc ? thanks Banarasi Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network

RE: create tablespace problem

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.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

simple question on DDL

Hi friends Why DDL statements performs auto commit ? What is the exact reason behind that one? Anyone can share his/her opinions!! Thanks regards BanarasiBabu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City

question on tkprof

Hi gurus Anyone knows about the comparision of tkprof output of the trace files generated by same application in diffrent times and anyone have solution to Problem with pl/sql in insert script loading into tkprof_table. Thanks in advance Banarasi

RE: question on tkprof

have permission or space-quota to create a smalltemporarytable in which to place EXPLAIN PLAN output. Check the permissions of the user you are specifying; log into SQL*Plus using the same user and try to create a small dummy table... - Original Message - From: BanarasiBabu Ti

XML with ORACLE

Title: 100% CPU utilization, urgent Hi gurus One of my developerasked me to help in dealing with the database for XML output. I know nothing about XML. Can anyone suggest some beginers documents for XML on ORACLE. Banarasi

RE: MAX Length of Name for Table / Index ?

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.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Moving tables from one tablespace to another tablespace

.. then imp. There is any other way round for this.. thanks in advance Banarasi Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Trace file size...

in advance Banarasi Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Trace file size...

my main question is about the file size... Thank you very much... -Original Message- Sent: Monday, January 13, 2003 4:49 PM To: Multiple recipients of list ORACLE-L On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: My SQL_TRACE is on for instance. For the whole instance? Usually, we

RECORDLENGTH parameter in export...

: 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.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] Fat City Network Services