Re: ORA-904 after table rename

Does his version of TOAD support your Oracle server version ? We tried to run our (outdated) version of SQL Navigator against a 9i DB and would get weirdness like this from time to time when accessing the Oracle data dictionary. mvg/regards Jo Norris, Gregory T [ITS] [EMAIL PROTECTED]

Re: D'oh, forgot my title! (Bit twiddling and bit manipulation...)

Maybe a lookup table filled once with 256 input/output pairs ? mvg/regards Jo Connor McDonald [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/06/2004 14:29 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

RE: OEM permissions

I believe a role 'OEM_MONITOR' is created in 9i when you create a DB; pre-9i you can create it yourself (via catsnmp.sql or something like that) and you can use that instead of granting specific other privileges. Oracle claims that it contains a minimum set of privileges for OEM use, but maybe

Re: Good news from Oracle

Or perhaps ora-600 [x] I didn't expect the Spanish Inquisition ! mvg/regards Jo Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/16/2003 17:19 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

(OT !!!!!!!) Re: Good news from Oracle

Most definitely ! Smoke me a kipper and all that. I'm heavily biased in favour of anything British as far as comedy goes : Blackadder (absolute no. 1), AbFab, ... mvg/regards Jo Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/16/2003 18:29 Please respond to ORACLE-L

Re: Oracle AS 10g

Anyone know if this includes the new OEM 4.0 ? mvg/regards Jo Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 18:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle AS

RE: Analytic bug in 9.2.0.4

ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] on 9.2.0.4 64 bit; Solaris 2.8 mvg/regards Jo Prem Khanna J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 03:14 Please respond to ORACLE-L To: Multiple recipients

Re: dba studio in oracle9.2

The functionality is now integrated in the console. mvg/regards Jo [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:29 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:dba studio in oracle9.2

Re: unix question

Something our Unix admins tend to do is move the files along different directories. E.g. they start in dir1; after succesfull backup, move them to dir2, etc. and after succesfull backup in dir4 delete them. So they should always get backed up 4 times even if you miss a run. Of course your backup

Re: How do you genrate primary keys?

I'm a bit surprised no one's mentioned it, but there's an article about the use of surrogate keys at Ixora : http://www.ixora.com.au/tips/design/synthetic_keys.htm mvg/regards Jo Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 14:19 Please respond to ORACLE-L

Re: question on comments -sanity check

user_col_comments, all_col_comments, dba_col_comments regards Jo Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 22:44 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:question on

Re: Tuning help required

Well, I'd start by writing the date part as : MEPAI.MPAI_AS_OF_DATE between to_date('03/01/2003','MM/DD/') and to_date('03/31/2003','MM/DD/') It will at the very least make the query easier to read and understand (also for the optimizer : it will know it's filtering on a range instead

Re: Bug in 9.2.0.4

I tried it on 9.2.0.4 in Win2k and it does indeed disconnect my session :( Nothing in udump, but it does write to core.log in cdump. regards Jo Munish Bajaj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/22/2003 10:19 Please respond to ORACLE-L To: Multiple recipients of list

Re: Undo Analyze Table

Analyze table ... delete statistics; regards Jo Hussain Ahmed Qadri [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/16/2003 08:54 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Undo Analyze Table

RE: Rebuilding MLOG tables

IIRC you need to lock the parent table in one session and then do whatever you need to do to the mlog table in a SECOND session (because, as another poster pointed out, the lock will be released too soon otherwise). hth, Jo Stephen Lee [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: SYS not able to GRANT -- Strange !

There's a new sys priv in 9i called grant any object privilege that can be used for this. regards Jo Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/13/2003 06:34 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: