hotbackup of a NOLOGGING tablespace

List, is it required to hot backup the tablespaces with status NOLOGGING ? , i plan to put all the INDEX tbs to NOLOGGING, am i correct in assuming that NO redo will be generated for these tbs's ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul

RE: process parameter

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

exsessive paging, which ora process ?

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

RE: ORA-00059: maximum number of DB_FILES exceeded

://www.orafaq.com -- Author: Rahul 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

RE: forgot Passwords

: Rahul 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, send an E-Mail

RE: Unable to create new user. Please help!!

you have to do an "alter user quota unlimited on tablespace users;" or do a "grant unlimited tablespace to test;" HTH rahul -- From: Kelly Ng Huey Ching[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, Mar

exsessive paging - from v$sysstat

, 2001 1:26 PM To: 'Rahul' Subject: RE: exsessive paging, which ora process ? File: topuser.txtFile: dub_kill_defunct.txt Ps -ef | sort -nr -k8,8 is a quick command to get cpu hoggers in sorted order. Go through the attached script and customize for your needs. topuser.txt

session commits when PC crashes

List, the oracle session will commit if the session is terminated by closing the window or re-booting the PC etc is there a way (parameter) to prevent this ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

RE: session commits when PC crashes

manager, clicking 'x' ) 3) in unix (rs/6000) the session DOES NOT commit when KILLED using kill -9 Now my windows sql*plus is acting wierd should i turn on the tracing on the client to debug ? Rahul -- From: Jeremiah Wilton[SMTP:[EMAIL PROTECTED]] Sent: Thursday

RE: Can not open DB :(

-04016: Error queuing an asynchronous I/O request. O/S-Error: (OS 23) Data error (cyclic redundancy check). SVRMGR What do i do ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

v$subcache - why objects appear many times ?

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

RE: Updating table2 from table1

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

RE: 8i - Seeing which columns disabled

table owned by SYS you see...the error returned is cannot DROP column.. !!! -- From: Voss, Tracey Lee[SMTP:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:40 AM To: 'Rahul'; Oracle DBA 2 (E-mail) Subject: RE: 8i - Seeing which columns disabled Hi

RE: Re:RE: very urgent

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

identify which logs are need to start recovery

usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

RE: identify which logs are need to start recovery

as the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul -- From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:02 PM To: '[EMAIL

TZ in AIX

://www.orafaq.com -- Author: Rahul 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: URGENT !!! ORA 604

! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul

space allocated vs occupied - procedure

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

RE: looking job

://www.orafaq.com -- Author: Rahul 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: Oracle Memory

://www.orafaq.com -- Author: Rahul 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: How to display a precedure from sql plus

://www.orafaq.com -- Author: Rahul 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

OEM website - cannot login ;-(

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

OT: fast tape drive for AIX

list, we are looking for a fast tape drive to backup all the volume groups on our IBM H70.. around 100GB+, our current backup takes around 5-6 hours !!! any ideas about a faster tape drive ? or an optical one ? regards -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

OT: IBM Ultrium tape drive for AIX

? how fast reliable is this ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

is this block cleanout ?

by the count(*) !! i would appreciate if anyone could explain further ! regards PS: 7.3.2 on AIX, the file is raw and async_io is true -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

how many async_io processes to invoke? - AIX ora 7.3

1) all files (17 of them) on raw volumes, spread over 4 disks 2) two files are hot.. both on separate hdisks 3) process inserts 20million+ records in two big tables TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat

can clustering help INSERTS ?

! regards -rahul Ora 7.3 on AIX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: can clustering help INSERTS ?

-- From: Tim Gorman[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 9:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: can clustering help INSERTS ? Rahul, It does no good to speculate; let's work

RE: can clustering help INSERTS ?

Rahul -- From: Jared Still[SMTP:[EMAIL PROTECTED]] Sent: Sunday, October 27, 2002 8:27 AM To: [EMAIL PROTECTED]; Rahul Subject: Re: can clustering help INSERTS ? *no* waits? How is this possible? Is intantaneous computing now a reality? Sorry

RE: can clustering help INSERTS ?

:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 9:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: can clustering help INSERTS ? Rahul, It does no good to speculate; let's work with facts... What wait-events are occurring

question on data warehouse tools by oracle

??? ) - OLAP - express server / analyzer TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 9iAS install problem

://www.orafaq.com -- Author: Rahul 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

OT: RAID 7137 configutation on AIX

list, we are trying to install the external disk array IBM 1737 to our J50 rs/6000 we do not have any documents/manuals .. this disk array can be configured as raid5 or raid0, but how to configure it ?? anyone ? TIA Rahul -- Please see the official ORACLE-L FAQ: http

strange (?) ora7 behaviour using CTAS

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

cant set multiblock read count 8 !!!

Rahul PS: i hv checked the multiblock reads using ixora script... always 8 !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

phyrds in v$filestat and sql trace not match !!

question is... why the physical reads in the v$filestat are equal ?? but the p reads in the sql_trace file are different ?? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: how to force the DB to SKIP tx recovery ?

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

RE: IO wait

) problems... !! regards Rahul -- From: John Kanagaraj[SMTP:[EMAIL PROTECTED]] Some remarks: (not an answer!) The first line of vmstat/iostat output is an average since restart. The 'wa' is 32 and you have 4 processes blocked on average. Was there a problem (or a large

d/w for a central bank

experience in desiging a d/w for a central bank !!! mainly we have to document the various possibilites of utilizing there current OLTP data !!! regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

test scenario # 1, dropped online redo logs

.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

test scenario # 1, dropped online redo logs - UPDATE

i am able to re-create the control file .. but on doing recover database using backup controlfile the database is requesting a change# which was in the deleted online redo log !!! now what ??? -- From: Rahul Sent: Friday, August 16, 2002 1:57 PM To: 'Oracle

RE: NFS mounts.

-- Author: Rahul 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, send an E

require info on OID / LDAP / LDIF

list, i have been learning about OID for the last couple of weeks.. i have managed to install and run the ldap server on my w2k, i can run the OID manager GUI, and can also do a ldap://wb-rahul:4034; from my IE5 now i want to pupulate the directory with some new info, and test the storage

RE: backup controlfile to trace

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

RE: backup controlfile to trace

;-( typed too fast the poster asked for the trace .. not the binary copy of the file me wrong.. me appologise... -- From: Rahul[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:03 PM To: Multiple recipients

RE: Why does my insert creates so many logs?

, 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: Rahul INET: [EMAIL PROTECTED] Fat City

RE: ORA_ENCRYPT_LOGIN

Subject: ORA_ENCRYPT_LOGIN Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL

RE: altering next extent

-- Author: Rahul 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, send an E

how to pick the lastes file using UTL_FILE package ?

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

RE: Advice needed please

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

RE: Urgent: Retrieving Disk Space

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

RE: urgent: production database won't be opened

-L FAQ: http://www.orafaq.com -- Author: Rahul 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

BEQ used for remote connections

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

RE: BEQ used for remote connections !!

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

RE: Dropping of user(Urgent)

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

is C compiler a must for oracle UNIX installations ?

://www.orafaq.com -- Author: Rahul 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: is C compiler a must for oracle UNIX installations ?

7.3.1 on AIX 4 WITHOUT the C compiler present.. !! and i was the one telling them how oralce requires to relink the executables after the installation. Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

RE: MOVE Tables from One Tablespace to Another Tablespace !!

-- Author: Rahul 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, send an E

RE: Users Schema's

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

RE: system tablespace?

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

RE: Stand By Database !!

mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: sysdba

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

this is how i created mount points - AIX

(complex?) way to do this.. ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: export to tape!!

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

top 5 segments from each tablespace...

i hv written a pl/sql to print out the 5 largest segments (max number of extents) from each of the tbs present in a DB... can this is done using sql too ? just curious... regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED

RE: Steve Adam's Removal

explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject: RE: Steve Adam's Removal

16 bit sqlplus cannot connect to PO8i

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

RE: 16 bit sqlplus cannot connect to PO8i

: etc... Jraed On Monday 28 May 2001 00:40, Rahul wrote: List, i'm trying to make a connect to 8i database (installed under orawin95) from a 16 bit sqlplus (installed under orawin) i tried to configure the IPC in listener, the sqlplus in orawin95 is able to connect

sqlplus cannot connect to PO 803 - more infp

!) and found errors reported how to interpret this trace... Regards Rahul ---+++++---+++++ nttcni: trying to connect to socket 5. ntt2err: entry -ERROR- ntt2err: soc 5 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nttcon

RE: how much ram per oracle process?

to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul

RE: ORA-01950: no privileges on tablespace 'DATA2_CPTF'

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

RE: Need a Help

://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: How to add Composite Primary Key in a Table

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

RE: Last Login

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

RE: How to drop a system event trigger - endless loop?

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

RE: find allocated and used space for a table

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

RE: set feedback off in procedure

-- Author: Rahul 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, send

RE: Enforced Costraints ??

Anshuman, whenever u add a constraint to a table, oracle will make sure all the data (if any) confirms to the constraint added you can enable or disable a constraint (even defer)... dont confuse urself with the term enforcing a constraint. Regards Rahul -- From

RE: Enforced Costraints ??

but if the tables already contains dup records, how can u make a unique constraint ? (even with enable novalidate) -- From: Anshumn[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 12:30 PM To: Rahul Subject: Re: Enforced Costraints ?? Hi Rahul

FW: Enforced Costraints ??

for the upcoming data only... Regards Rahul -- From: Anshumn[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 12:30 PM To: Rahul Subject:Re: Enforced Costraints ?? Hi Rahul, That is true. In Oracle 8, there is option to enable the constraint

RE: Enforced Costraints ??

values in a PK candidate column) 1) create a non-unique index on the pk candidate colunm 2) create the pk using enable novalidate clause this way the existing data will NOT checked for uniqueness, the constraint will be enforced for the upcoming data only... Regards Rahul

RE: Quer

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

solaris - no utmpx entry !

also... * have tried switching off /on the server... did not work.. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

advance backup recover (RMAN?)

List, one of our clients insists to isntall the advance backup and recover option of oralce... (8.1.6) (it's written on the back of the CD, CD includes advance backup and recovery) are they talking about the RMAN ? or something else ? Regards rahul -- Please see the official ORACLE-L FAQ

advance backup recover (RMAN?)

List, one of our clients insists to isntall the advance backup and recover option of oralce... (8.1.6) (it's written on the back of the CD, CD includes advance backup and recovery) are they talking about the RMAN ? or something else ? Regards rahul -- Please see the official

RE: rowcount and rowsize..

help regarding this. i need these 3 stats in a text file. namely table_name row_size rowcount to make them read by the c program and generate an output file. thanks saurabh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL

Flush shared poo;

Salman ! Any ideas Rahul Ankur Shah Oracle DBA DHR-GA - Original Message - From: [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 8:28 AM Subject: RE: Flush shared poo; query returned two rows, what does it mean?? TOTAL_SP

RE:

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

RE: How to size db_block_size?

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

RE: Latchs

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

OT - using winsock.dll from within forms 6i

list, sorry for this OT , but our development team is looking for resources/links on the web providing examples of sending/recieving data using winsock from oralce forms.. i tried searching google, but could not find any code samples...!! regards Rahul -- Please see the official ORACLE-L FAQ

my boss wants a report !!!

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

script to populate tables, i just wrote one

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

RE: Library Cache wait -- Who is holding this latch

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

alter table enable table lock hangs..

i can drop this table ??? (it would require enabling the table locks) seems like a bug to me... i'm on rs/6000 with 8.1.5.0.0 Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

ok to alter SYS tables/cluster (obj$/C_OBJ#) for buffer_pool KEEP

List, any known restrictions in doing an alter table obj$ storage(buffer_pool keep) ? or, would it be better to keep the entire C_OBJ# cluster in KEEP pool ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

11 disks to build a DB, suggestions

+ USER_TEMP + INDEX01 D6 - RBS-2 + INDEX02 + TEMP_TABLES D7 - solaris system + oracle engine. would really appreciate if someone could review this config , and suggest improvements. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL

RE: Standby database

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

can i place online redologs with oracle engine ?

list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also on the same drive) TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

  1   2   3   >