Re: Standby errors

2003-03-14 Thread Adriano Freire
--- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want

Re: Last access in table

2003-01-31 Thread Adriano Freire
interesting, you can post the ADDRESS into the SQL below to see more of the statement. select sql_text from v$sqltext where address = '83C984A4' order by piece Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original

Last access in table

2003-01-30 Thread Adriano Freire
DBA's,   How can i see the last(date) access(DML) in a table?   Thanks   Adriano

Re: EMC EDM backup utility and 9i

2003-01-24 Thread Adriano Freire
Title: EMC EDM backup utility and 9i Hi, Helmut   I worked whith backup's using EDM and ORACLE 8i but 9i no yet what's problems do you've?   Adriano - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Friday, January 24, 2003

ORA-24333

2003-01-17 Thread Adriano Freire
Anybody know thats ORA ORA-24333?   look: oerr ora 2433324333, 0, "zero iteration count"// *Cause:  An iteration count of zero was specified for the statement// *Action: Specify the number of times this statement must be executed When thats issue occur?   thanks   Adriano

Re: Urgent: Trigger problem...

2002-12-19 Thread Adriano Freire
- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note 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

Re: Export From INformix running on unix

2002-12-17 Thread Adriano Freire
Hi Walid Do you know the Oracle Migration Workbench? We did the same migration(informix to oracle) using thats tool. Adriano Freire. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 9:23 AM > >

Re: DB corruption question

2002-12-05 Thread Adriano Freire
Try, recreate the controlfile - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 04, 2002 10:09 PM Subject: DB corruption question   With Oracle 8.1.7, Solaris 8 OS.    I have a shared stor

Re: Configuring Kernel in Unix for install BD

2002-11-19 Thread Adriano Freire
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: Adriano Freire INET: [EMAIL PROTECTED] Fat City Netw

Re: replicate schemas

2002-11-13 Thread Adriano Freire
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: Adriano Freire INET: [EMAIL PROTECTED] Fat City Network Services-- 8

Re: creating a 9.2 database

2002-10-31 Thread Adriano Freire
Title: creating a 9.2 database normally in $ORACLE_HOME/admin//scripts - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Thursday, October 31, 2002 5:40 PM Subject: creating a 9.2 database I alway

Re: Informix gateway error

2002-10-14 Thread Adriano Freire
Bruno Are you using HSODBC for connections between ORACLE and INFORMIX? Adriano Freire -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adriano Freire INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: query for detect redundant index

2002-09-05 Thread Adriano Freire
PNAME    1 -----Original Message-From: Adriano Freire [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 03, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: query for detect redundant index HI all,   Do you've any pl/s

query for detect redundant index

2002-09-03 Thread Adriano Freire
HI all,   Do you've any pl/sql for detect redundant index?   thanks,   Adriano Freire  

Re: working with datafile > 2Gb in HadHat 7.3

2002-08-29 Thread Adriano Freire
res and you can put the datafiles into > different hard drives increasing i/o performance. > > ltiu > > Adriano Freire wrote: > > >Ok ltiu, > >REDHAT 7.3 kernel-2.4.18-10 > > > >- Original Message - > >To: "Multiple

Re: working with datafile > 2Gb in HadHat 7.3

2002-08-29 Thread Adriano Freire
Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 1:18 PM > What's HadHat 7.3? > > A new Linux distro pattered after RedHat 7.3? > > ltiu >

working with datafile > 2Gb in HadHat 7.3

2002-08-29 Thread Adriano Freire
Gurus,   I've some problems with datafiles > 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion?   Thanks   Adriano.

Re: No patches to install

2002-08-27 Thread Adriano Freire
hostname is stored - you could try > dragging one from another machine (assuming the > locations etc are the same) > > hth > connor > > --- Adriano Freire <[EMAIL PROTECTED]> wrote: > Hi > DBA's > > > > i'm trying to do upgrade the 8.1.7

No patches to install

2002-08-27 Thread Adriano Freire
Hi DBA's   i'm trying to do upgrade the 8.1.7 to 8.1.7.3 and when i start the runInstaller,  appers the message "There are no patches to install...". I missed my orainventory. How can i do the upgrade now?   Thanks.   Adriano