Re: 9i new feature on-line doc ???

Rel 1 -- http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90120/toc.htm Rel 2 -- http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96531/toc.htm HTH GovindanK-Original Message- From: Janet LinsySent: 10/31/2003 10:35:29 AMTo: [EMAIL

RE: Alter tablespace begin backup

http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:271815712711 HTH GovindanK <-Original Message-> From: Fowler, Kenneth R;Fowler, Kenneth R Sent: 10/31/2003 10:35:37 AM To: [EMAIL PROTECTED] That's an excellent article. Thanks! -Original Message- Sent:

Re: Finding overlapping time periods - suggestions please

>there has to be an "guess work theory" about where the stuff the black hole consumes >ends up Part of what is consumed is returned back to the universe in the form of X-Rays. > and does it have the ability the grow at a rate proportional the the volume it consumes? No. Refer to "Hawking

Re: dba interview questions

Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him because 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct?? By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains'

Oracle lowers price?

http://www.oracle.com/ip/deploy/database/oracle9i/index.html?Std_One.html ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

- - price? How will the market react?

http://www.oracle.com/ip/deploy/database/oracle9i/index.html?Std_One.html ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Re: Passed Net8 OCP Exam

Hi Dennis Congrats __ Keep the spirit flying GovindanK OCP-8,8i Brainbench Certified Master 8 DBA - Original Message - To: "Multiple recipients of list ORACLE-L" Sent: Thursday, October 16, 2003 12:24 PM > I just passed the Net8 Administration OCP exam. This

Re: Openworld Papers

Here is what you are asking for http://otn.oracle.com/ow2003/content.html HTH GovindanK -Original Message- From: Post, Ethan;Post, EthanSent: 10/7/2003 11:56:25 AMTo: [EMAIL PROTECTED]Subject: Re: Openworld PapersBeen off the list for a few days, anyone know if the papers from

Re: Software Download

If you are mentioning 9i download database then look at http://otn.oracle.com/software/index.html If it is about 9i papers which were presented during [EMAIL PROTECTED] then click on database, Application servers etc, scroll down and you will have 9i related articles along with download link.

RE: Desupport of RBO

Bit old but http://www.pro-dba.com/oracle_10i.html HTH GovindanK -Original Message- From: Cunningham, Gerald;Cunningham, GeraldSent: 10/7/2003 12:11:25 PMTo: [EMAIL PROTECTED]Subject: RE: Desupport of RBOThe way I read it is that you can still use it, it's just not officially

Re: Basic question about controlfile recovery

Hi Scott Answer to Question 1 (answers Question 2, 3 too). Bkp Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control filequoteIf you use a backup control file, you need to perform media recovery.Also, Oracle will force you to use the 'using backup controlfile' option.Once recovery is

RE: Cary's book - Waxing philosophic

They want to hire someone smart, but are irritated about having a smartie around. Some managers don't like Good DBAs. They don't like DBA's being independant (since they have good IQ and are able to solve the problems themselves , and , in the process - they gain the respect of others) - the

RE: Cary's book

when I went to the admin who had the keys of the stationary and asked her for a"rubber", instead of "eraser". In the English language they taught me at school, that little rubbery implement used to erase what someone has written down was known as "rubber". I was extremely annoyed by herreaction

RE: Describe privilege on procedures packages

-Original Message-From: Govindan K [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Describe privilege on procedures packages Hi Pete I see another restriction (as i choose to put it) with my code. In OUR setup, we use

Re: ORACLE CLIENT V816

AFAIK in Solaris V8.1.6, the client is part of EE download itself. When you invoke OUI just choose the Client option and install it in a different Oracle Home. May it is same in Linux. Just check. HTH GovindanK -Original Message- From: Seema SinghSent: 10/2/2003 12:00:38 PMTo:

Re: Describe privilege on procedures packages

uot; person had not been granted access to the OP's procedures then they wouldn't be in ALL_% for him or in user_% views. kind regards Pete In article <F001.00! [EMAIL PROTECTED]>, Govindan K <[EMAIL PROTECTED]>writes This was the closest i could get. set pagesize 60; set linesize 180; colu

RE: 8i OCP Net8 Exam

Hi Dennis I would suggest you by 8i Network guide book for OCP by Barbara Ann Pascavage. I believe it is from Corialis which exists no longer. Nevertheless it might be avbl. with some book shops/book seller website. The book is real good one with Networking concepts explained clearly. You will

Re: UNIX : script help/input

Thank God for Jared -Original Message- From: Tanel PoderSent: 10/1/2003 10:37:55 AMTo: [EMAIL PROTECTED]Subject: Re: UNIX : script help/input Thank God for Perl and Mladen ;) Tanel. - Original Message - From: Johan Muller To: Multiple recipients of list ORACLE-L

Re: COBOL TO ORACLE

Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. If you are using SQL*Loader make sure to check the log after load. For larger loadsi would suggest direct load. The second

Re: Big table, small table

Are you using any trunc functions while querying. Do this. SELECT column_name,count(*) from small_table group by column_name; Run this for all the tables. My guess is that atleast 30% of the rows in the small table is for the value that you gave. So the optimizer is forced to read the index

Re: Describe privilege on procedures packages

This was the closest i could get. set pagesize 60;set linesize 180;column position noprint;column sequence noprint;break on object_type skip 1;break on package_name skip 1;break on object_name skip 1;column object_type format A15 wrap;column package_name format A30 wrap;column object_name

Re: Replication from DB2 to Oracle

Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program which will in turn connect to Oracle and carry out DMLs. HTH GovindanK-Original Message- From: Govindan

Re: Replication from DB2 to Oracle

Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication across Databases of diff.vendors is still not avbl. though it seems you can do DMLs from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. Don't know about the reverse. Or you may considering

What is happening to OTN 9iRel2 page?

your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: wrapping packages

Coming to think of it, is the 3Mb size is for stripped or unstripped executable?. I know 3Mb if stripped is not likely to come to 40K. Nevertheless the memory addressing for UNIX is diff. from Windoz. May be someone else in the list has a better knowledge of it. GovindanK -Original

RE: RE: tuning a massive delete

I agree with Dennis Williams. Large deletes do have an overhead on indexes. Try this. - Create table new_table nologging as select * from existing_table where [condition] OR you may use COPY command in lieu of that - get the index definitions - exp grants,constraints,indexes=n ,rows=n for

Re: how to do a variable in-list of numbers?

://www.orafaq.net -- Author: Govindan K 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

Re: how to do a variable in-list of numbers?

Not sure if this reached the list. Reposting. On Sun, 14 Sep 2003 23:03:47 , Govindan K [EMAIL PROTECTED] sent: We have applications where are session active. I mean, lot of data needs to be inserted during the session, select based on various criteria, lots of intermidiate steps involved

Re: XDB,Context questions

Not sure if this reached the list. ReSending. On Fri, 12 Sep 2003 10:15:11 , Govindan K [EMAIL PROTECTED] sent: You need to use XMLType datatype / as CLOB. Check these links: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/toc.htm and within that (for storing data) refer

Re: ** package problem

This one too, i think didn't make to the list. ReSending. On Fri, 12 Sep 2003 10:20:12 , Govindan K [EMAIL PROTECTED] sent: Forgot to mention yesterday. I ran into a similar situation two weeks ago. Whenever this happens in a SQL*Plus session, just do a DESCRIBE PACKAGE. You should be able

Re: Checking for code using hints(from database)

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

Re: how to do a variable in-list of numbers?

and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: ** package problem

have to be discarded. Does anyone have a similar 'global package' and is there a way to deal with recompilation of package (not the body).   Thanks Govindan K [EMAIL PROTECTED] wrote: Surprising. Take a look at http://asktom.oracle.com/pls/ask/f?p=4950:8:3074025580820147889

RE: how can I see which database I am logged into without

the HELP command for other information (like subscribing). Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services

RE: how can I see which database I am logged into without

email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: converting long to lob - the easiest and fastest way ?

creation.   Thanks in advance.   - Siddharth Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services

Re: How to tell if XML option is installed in the db?

and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Documents in or outside the database.

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: URGENT REPORTS WONT START

One note I found on web said to comment out some tags.  Doesn't seem to help.  Any ideas? Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET

Re: (long and boring) converting long to lob - the easiest and

. Thanks in advance. - Siddharth Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: ** package problem

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

Re: recovery

Donot restore Online Redo Logs. It will be in sync with the current control file. However, your decision to do resetlogs is correct since it is an imcomplete (time based recovery). --- Basavaraja, Ravindra [EMAIL PROTECTED] wrote: Hi, I have to recover my database back to

Re: Large Export Problem ......

Babu Why not try 'direct=y' option. This has limitations regarding the platform. Not 100% sure of it. Check with Documentation. It does export very fast. HTH GovindanK --- Janardhana Babu Donga [EMAIL PROTECTED] wrote: Dear List, I have a large unarchived decission support database of

Re: How to enable Java on ORACLE 9ir2 database???

--- mike mon [EMAIL PROTECTED] wrote: We have ORACLE 9ir2 on SUN Solaris. We plan to use Java on ORACLE very soon and need you help. 1. how to check the database we have is java enable? connect as system/sys and SQL desc dbms_java 2. If database on java enable, which files we need

Updateable View with Select Union

Hi list I need help on this. Trying to create a view with select union all as part of it. SQL @view01b SQL create table t1 (ind1 varchar2(02) , rundate1 date) 2 / Table created. SQL create table t2 (ind2 varchar2(02) , rundate2 date) 2 / Table created. SQL insert into t1 values('T1' ,

Re: drop table vs truncate table -- performance

Is it because, truncate has to reset the HWM? GovindanK --- gmei [EMAIL PROTECTED] wrote: Hi: Oracle 8173 on Sun Solaris 2.8. I am running a program that creates and drops tables repeatedly in a schema. The table dropping part looks like this: drop table ypd.t1 cascade constraints; drop