>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 Radia
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: Fri
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 PROTECTE
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'
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!
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!
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 w
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 RBO The way I read it is that you can still use it, it's just not off
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.
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 Papers Been off the list for a few days, anyone know if the papers fr
Hi Scott
Answer to Question 1 (answers Question 2, 3 too).
Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control fileIf 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 done, yo
>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 her react
>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
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:
_arguments
Raj
-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
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-
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
er describe *his* procedures and packages, you would need to use dba_% views as if the "other" 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 , Govindan K <[EMAIL PROTECTED]>wr
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_na
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 fir
>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 loads i would suggest
direct load.
>The s
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 K
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
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 considerin
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 Message
Hello ListWhen i am trying to create a database using DBCA , after 93%, the following message gets displayedFailed to retrieve the value of net service alias"DBSID". Please configure the net service entriesand run the "$ORACLE_hOME/ultrasearch/admin/wk0config.sql" script manually to configure the
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 exist
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 in
or. It could
>>> then
>> execute 300-400 times and will run all day.
>>>
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>> --
>>> Author: [EMAIL PROTECTED]
>>> INET: [EMAIL PROTECTED]
>> --
&g
of numbers
>at
>> runtime?
>> >
>> > Im using a cursor to determine which values need to be added to my
>inlist.
>> I think I can do some kind of cast, but im not familiar with it.
>> >
>> > Im on 8i. I do not want to j ust run this insi
name of mailing list you want to be removed from). You may
>also send 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
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 PACKAG
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 withi
global package for
sundry variables' might 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.
>
>Ta
essage 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://www
lter table drop column col1 afterwards and if
>needed, rename newcol to col1 using alter table rename column (or whatever the
>syntax was).
>
>You might want to do this in batches and commit meanwhile if
>your table is big.
>Also, if your table is big, then you shoul
--
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
document
>> > that has performance information for blob/clob storage and retrieval
>> > database performance information?
>> >
>> > TIA
>> > M.
>> >
>> >
>> >
Message sent via Zuvio Mail
Get your own FREE email account w
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-- 858-538-5051 h
ld like to convert the existing
>data in clob type also. The to_lob works only for select statements, cannot go
>through that pain of table creation.
>
>
>
>Thanks in advance.
>
>
>
>- Siddharth
>
>
Message sent via Zuvio Mail
Get your own FREE email a
the GLOBAL_NAME value rather than the database name.
>> >Admittedly the 2 should usually be the same but often (following a database
>> >clone for instance) it is not correctly set.
>> >
>> >Regards,
>> >Mike Hately
>
>Wolfgang Breitling
>Oracle7, 8,
---
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of
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 23-MAR-0
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 databas
--- 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 f
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'
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 constraint
47 matches
Mail list logo
