RE: BITAND need help

gt; SQL> > > You are trying to do a bitand on a varchar2 column. > > Scott Shafer > San Antonio, TX > 210-581-6217 > > "Common sense will not accomplish great things. Simply become insane and > desperate." > > > -Original Message- >

Index reverse Help

, int num2 ) { return ( int ) ( num1 & num2 ); } Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

RE: BITAND need help (Solved)

i, Can someone help me with this please What cause the error ? SQL> select bitand(4,4) from dual; ERROR: ORA-00932: inconsistent datatypes no rows selected Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED]

BITAND need help

Hi, Can someone help me with this please What cause the error ? SQL> select bitand(4,4) from dual; ERROR: ORA-00932: inconsistent datatypes no rows selected Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED]

Oracle Indexing

: http://www.orafaq.com -- Author: Sinard Xing 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

RE: bitmap index with nosort

dex bmap1 on emp(kill asc) nosort * ERROR at line 1: ORA-25110: NOSORT may not be used with a bitmap index Can I use nosort when creating bitmap index Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xi

bitmap index with nosort

bitmap index bmap1 on emp(kill asc) nosort * ERROR at line 1: ORA-25110: NOSORT may not be used with a bitmap index Can I use nosort when creating bitmap index Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Oracle Indexing

: http://www.orafaq.com -- Author: Sinard Xing 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

RE: Number / 0

ng an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Number / 0 (solve)

ient privileges I don't understand why Oracle throw such exception (reply). Do you have any idea what is Oracle doing when Oracle find out number / 0 Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network

Number / 0

emp(income/0) * ERROR at line 1: ORA-01031: insufficient privileges I don't understand why Oracle throw such exception (reply). Do you have any idea what is Oracle doing when Oracle find out number / 0 Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

RE: Uncle Larry is Number Five

oved 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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Ca

RE: Funny?

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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Netw

RE: Control File locks

NET: [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, send an E-Mail message to

Ms. buy Redhat

Hi guys, PCplus (Indonesia newspaper) said Microsoft bought Redhat (no URL link to this news), any URL on this news ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Set unused column back to normal (solved)

nd please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

Set unused column back to normal

Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services

Set unused column back to normal

Hi all, Any command setting back the unused column back to used ? Negate this command please ALTER TABLE mytable SET UNUSED mycol; Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services

RE: 8i Concept PCTFREE & PCTUSED are 0

uter Services [EMAIL PROTECTED] > -----Original Message- > From: Sinard Xing [SMTP:[EMAIL PROTECTED]] > Sent: Mon, February 18, 2002 11:08 AM > To: Multiple recipients of list ORACLE-L > Subject: 8i Concept PCTFREE & PCTUSED are 0 > > Hi all, > > Oracle 8i (81600) >

8i Concept PCTFREE & PCTUSED are 0

k at this: SQL> select * from mytable; COL COL2 COL4 --- abc abcd a Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: View for Procedure/Function SQL Code

nformation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: View for Procedure/Function SQL Code

LP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Manual convertion 8i ROWID

Hi guys, Beside using DBMS_ROWID.* is that a way (formula) to convert the base-64 encoding to normal decimal format ? Thanks Sinardy Happy CNY -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services

V$SESSION with no osuser and no username

q.com -- Author: Sinard Xing 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

RE: Hot Backup to Tape

What tape DDS3 or DLT -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Quamrul PolashSent: 04 February 2002 00:30To: Multiple recipients of list ORACLE-LSubject: Hot Backup to Tape Hi, I need a script for on-line backup to tape. M

RE: ALTER ROLLBACK SEGMENT rbs SHRINK

AQ: http://www.orafaq.com > > -- > > Author: Johnston, Tim > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > > Lists > > >

RE: ALTER ROLLBACK SEGMENT rbs SHRINK

10649600 > > > SQL> select rs.optsize, rs.extents > 2from dba_rollback_segs drs, > 3 v$rollstat rs > 4 where drs.segment_name = 'RBS17' > 5 and drs.segment_id = rs.usn; > >OPTSIZEEXTENTS > -- -- >

RE: ALTER ROLLBACK SEGMENT rbs SHRINK

7;RBS17' > 5 and drs.segment_id = rs.usn; > >OPTSIZEEXTENTS > -- -- > 22020096 10 > > SQL> > > 8.1.7.3 on Solaris 2.8 > > Tim > > -Original Message- > Sent: Wednesday, January 30, 2002 10:26 AM >

ALTER ROLLBACK SEGMENT rbs SHRINK

Hi, Assume INITIAL * MINEXTENT = 2M and also = OPTIMAL Do you think ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M; will work ? Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network

RE: Unix question

CLE-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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-

RE: ORA-01555 Mystery (Help)

RA-01555 Mystery > > (Help) > > > > > > > > > > > > Hi, > > > > > > > > > > > > A user in our data warehousing group is > > running > > > > into > > > > > > the old ORA-01555 (snapshot

RE: ORA-01555 Mystery (Help)

> > > > Subject: ORA-01555 Mystery > > (Help) > > > > > > > > > > > > Hi, > > > > > > > > > > > > A user in our data warehousing group is > > running > > > > into > >

RE: Oracle DBAs Needed in Boston

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://www.orafaq.com -- Author: Sinard Xing INET:

RE: Re: How can I tell if a procedure/package is running?

elling 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://www.oraf

RE: How to insert records into a Database table from an Email ?

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: RE: HP vs SUN for a UNIX box

] (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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http

Maximum number of redo log members

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

RE: Dig it - killer freeware editor

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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

How to change ORA error message ?

Hi, Can I change ERROR: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege Enter user-name: to Something else and quit to unix prompt Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL

RE: Becoming a DBA questions

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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Se

how delete "myfile*" in unix

com -- Author: Sinard Xing 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, s

RE: Unix mailing List

if what is the unix function for findThisFile() Thank you, Sinardy Hoping Peace in Middle East and the rest of the World -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Unix mailing List

f what is the unix function for findThisFile() Thank you, Sinardy Hoping Peace in Middle East and the rest of the World -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Delete slowing..

Title: RE: Delete slowing.. Hi,   Perhaps you check the Indexes against that table, you can drop the index first, you may consider a TRUNCATE TABLE command if you not need the rollback option.   Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behal

RE: backup unix script

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

RE: OEM for Personal Edition cannot connect

management server in oracle.  i tried many times to connect on it... the same error i got vtk-1000..etc.never i succeeded on it thanks. Nirmal. -Original Message-From:   Sinard Xing [SMTP:[EMAIL PROTECTED]]Sent:   Wednesday, November 28, 2001 11:45

OEM for Personal Edition cannot connect

lp Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: is there an archive for this mailing list...

formation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Other Database Mailling Lists

Hi, Please recommend me some good Ms SQL Mailing List that as good as here Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle on NT startup question

ike subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: NLS Support in Oracle..

I think you need some kind of function as translator to achieve that, my guru said is very difficult (almost not possible for people like me ??!?!?!!!) to change database NLS. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Arul kumarSent: Wed

RE: Oracle on NT startup question

ved 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: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Last day of the month unix

Hi, Is there any function that can display out "last day of the month" for example lastday(Oct,2001) return me 31 Or a variable that store this value. Is Date an object in unix ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard X

Oracle 9i CD

/www.orafaq.com -- Author: Sinard Xing 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 th

RE: Backup Strategy

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

Compare and Contrast 8i and 9i

Hi all, Do you know any source of this info -> why we have to go 9i instead 8.1.6 (everything quite ok) www.oracle.com is a bit bias. Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Netw

RE: ORA 235

Hi Steve, Can you please give some hint, what is even 10327 ? Regards, Sinardy -Original Message- Sent: Friday, 19 October 2001 3:38 PM To: Sinard Xing; Multiple recipients of list ORACLE-L Hi Sinardy, It probably means that a log switch was in progress at the same time as the

ORA 235

Hi, Can someone tell me what is the cause of this error FROM sys.v_$loghist lh1, sys.v_$loghist lh2 * ERROR at line 6: ORA-00235: controlfile fixed table inconsistent due to concurrent update Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard

8i and 9i in same Sun Box ?

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L

RE: Preventing user access

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

No Subject

test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists