RE: SAME and separating disk and index tablespaces

nswer is an enthusiastic yes. This is purely >>from >>an administrative and manageability standpoint. For >>example, if you have INDEX and DATA segments >>separated >>in 2 different tablespaces, the backup of these >>tablespaces can be done INDEPENDENTLY. This is &g

RE: SAME and separating disk and index tablespaces

shops, unless you think you can re-re-build your indexes in the event of media failure and you lose your INDX tablespace. Hope that helps, Gaja --- vikas kawatra <[EMAIL PROTECTED]> wrote: > Guys, > > Does it make sense to separate data and index > segments into separate &g

SAME and separating disk and index tablespaces

Guys, Does it make sense to separate data and index segments into separate tablespaces if you create a single logical volume and all files are striped using the SAME methodology ? Thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: vikas kawatra INET

RE: Fast Refresh of Materialized views

gs based on the PK of the FACT table - and the > MV's are JOIN ONLY . > Any suggestions would be welcome ! > > vikas > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vikas Kawatra > INET: [EMAIL PROTECTED] > > Fat City Ne

Fast Refresh of Materialized views

.com -- Author: Vikas Kawatra 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-writing SQl:help needed

= nvl(cust_id,0) AND friendly_session_id =nvl(friendly_session_id ,0) AND (creation_date is NULL OR loc_to_utc(creation_date) between '21-JUN-2001' and '21-AUG-2001'); -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra I

RE: linux & Oracle -- best combination

JUN-2001' and '21-AUG-2001'); -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Setting environment varibales on Unix

How do I set the LD_LIBRARY_PATH and other general env variables on Unix ? Can someone help ? Syntax for setting these ? Is there a file I can edit ? vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network

RE: Setting PCTFREE & PCTUSED in a Datawarehouse

that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Vikas Kawatra INET

Setting PCTFREE & PCTUSED in a Datawarehouse

I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City

RE: Scripts to monitor databases

abase performance stats etc - Can you guys recommend good scripts /URL's etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Scripts to monitor databases

abase performance stats etc - Can you guys recommend good scripts /URL's etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

PC Net link 1.2

Anyone use this product to share disks between Solaris and NT servers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Moving tablespace across disks

Do I need to make the tablespace READONLY before cpying it to another disk location - ora can I simply - take the file offline - and copy the file across -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network

Migration of a database from MS Access to ORACLE

Has anyone done migration of a Access dbs to Oracle . The access dbs has OLE objects which need to be moved too. Any help would be appreciated ! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network

Listener problem

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

Migrating from 8.1.6 to 8.1.7

export ORAWEB_HOME=/u06/app/oracle/product/8.1.6 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: OEM 2.1 cannot contact agent on a node

2nd Street San Francisco CA -94107 Tel: 415-972-1045 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: How to prevent oracle from committing a transaction?

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

UTL_FILE pkg related issue

- how I can scan the binary file - and count the no of rows - before - processing the file ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Adding Indexes on Materialized views

Has anyone created indexes on MV's ? Syntax? URLs ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- P

RE: On the question of "What is a Large Database Anyway ?"

Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Point in Time recovery required !!

recipients of list ORACLE-L Vikas, re-reading your note, it appears you have tables that were dropped? logminer will not help you in that respect(at least not until 9i, when you have undo tablespaces and query flashback). joe Vikas Kawatra wrote: > > Our developers need the dbs to be restored t

RE: On the question of "What is a Large Database Anyway ?"

] (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://www.o

Point in Time recovery required !!

overwritten - so we have no HOT backup now ... We have no cold backups - I'm trying to figure out if we can use the LOGMINER - to do any recovery !! Any Suggestions /help would be welcome !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra

RE: ORACLE NAMES /LDAP

Thanks ! A very useful link ! -Original Message- Sent: Thursday, May 31, 2001 7:07 AM To: Multiple recipients of list ORACLE-L Vikas Kawatra wrote: > > Anyone using this product as an alternative to Local Naming ? How about LDAP > ? > > Any info /suggestions/comme

ORACLE NAMES /LDAP

Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Replicating data from SYBASE to ORACLE

ORACLE-L You really should check into Sybase Replication. Very powerful ( and complex ) replication product. It can replicate Sybase to Oracle. Jared On Wednesday 30 May 2001 18:25, Vikas Kawatra wrote: > Anyone have any ideas about replicating data from SYBASE tables to ORACLE > in rea

RE: Replicating data from SYBASE to ORACLE

ASE - which may be a way to do this - I have limited SYBASE exp - so I was wondering if there are any ideas out there thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Replicating data from SYBASE to ORACLE

orafaq.com -- Author: Vikas Kawatra 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 ma

RE: Installing Oracle on UNIX

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

Installing Oracle on UNIX

w software .I cannot even browse to the new source /destination locations ?? Any help to figure this out will be appreciated !! vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Vocabulary

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://

RE: NOLOGGING/LOGGING

e 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: Vikas Kawatra INET: [EMAIL PROTECT

RE: Reverse key indexes

Vikas Kawatra Rather than re-invent the wheel, I'll let Steve Adams explain it. Besides, his explanation is better than the one I was going to give. :) http://www.ixora.com.au/tips/design/synthetic_keys.htm Jared On Friday 11 May 2001 23:55, Vikas Kawatra wrote: > Reverse key indexes

Reverse key indexes

which are automatically created by Oracle. vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Turning off redo logging

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

Updating a table :Using dynamically generated table_Names

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

RE: Cool way to crash an Oracle database, any time, any place

n 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 F

RE: Inserts slowing down on OLTP systems

>From: Vikas Kawatra <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Inserts slowing down on OLTP systems >Date: Mon, 07 May 2001 16:55:28 -0800 > >Anyone have ideas on why OLTP database inserts w

Inserts slowing down on OLTP systems

Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET

RE: list table in schema

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

RE: Certification

Thanks a ton ! The code worked !! I got a 20% off ! -Original Message- Sent: Friday, May 04, 2001 3:51 PM To: Multiple recipients of list ORACLE-L mention the code S36 while registering. Its there in technet.oracle.com Raj -Original Message- From: Vikas Kawatra [SMTP:[EMAIL

RE: SQL question: possible to improve performance in these functi

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

Certification

Anybody know how to get a discount on the fees for the OCP exam from Prometric ? vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: images question

-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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and

RE: rename indexes

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