date:20010828

Re: strange problem with v$recover_file ???

2001-08-28 Thread Rukmini Devi


Hi ,

  ONLINE is a reserved word.  It should not be used as a column name. I
think it is bug.

rukmini
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 3:51 AM


 All, I got a problem with v$recover_file.  Somehow the
 query failed if selecting is on ONLINE column.

 SQL desc v$recover_file;

  Name  Null?Type
  - 
 ---
  FILE#  NUMBER
  ONLINE VARCHAR2(7)
  ERROR  VARCHAR2(18)
  CHANGE#NUMBER
  TIME   DATE



 These are OK:
 ---
 select  CHANGE#  from v$recover_file;
 select TIME from  v$recover_file;
 select * from v$recover_file;

 However these gave me error:
 
 select  ONLINE from v$recover_file;
 select online, ERROR from  v$recover_file;
 select  FILE# , ONLINE,ERROR , CHANGE#,TIME from
 v$recover_file;
  *
 ERROR at line 1:
 ORA-00936: missing expression

 SQL select v.name, b.online
   2  from v$datafile v, v$recover_file b
   3  where v.file# = b.file#;
 select v.name, b.online
  *
 ERROR at line 1:
 ORA-01747: invalid user.table.column, table.column, or
 column specification


 What's happening?!  Thank you.

 Andrea

 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrea Oracle
   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 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 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: Rukmini Devi
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: FROM SRINIVAS -HELP

2001-08-28 Thread Nirmal Kumar Muthu Kumaran

If those records are able to retrieve by a query, then u can use export with
query option too.

Nirmal.

 -Original Message-
 From: Jared Still [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 28, 2001 6:06 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: FROM SRINIVAS -HELP

 Some requirements please:

 is it ok if a row is chosen more than once?

 it will be statistically impossible to pick 10 million
 rows from a set of 44 million without many duplicates.

 if it is ok, just write a pl/sql script to loop through
 the table, skip a random number of rows, grab one, repeat.

 you will likely have to scan the table multiple times.

 not very efficient.  but hey!, I'm just the idea man here.  :)

 if you don't want duplicates, you will need to track those that
 you have already chosen and skip them.  this has the potential
 to be a very long running script.

 why not just go throught the entire table once, pick every 4th
 row, and be done with it?

 Not random, but just how important is randomness to you?  you 
 didn't state the purpose of this exercise.

 Jared

 On Monday 27 August 2001 09:00, [EMAIL PROTECTED] wrote:
  I have 44 million records in my table.I need to extract the 10 million
  records randomly,how to retrieve these records randomly. I used the
  dbms_random.sql ,but I have a doubt that I was correct or not.
  can U please guide me or just send a piece of code.
  Thanking U
  srinivas
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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 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 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: Nirmal Kumar  Muthu Kumaran
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: strange problem with v$recover_file ???

2001-08-28 Thread Reardon, Bruce (CALBBAY)


Andrea,

From Metalink, the column is defined in uppercase:

SQL select online from v$recover_file;
select online from v$recover_file
   *
ERROR at line 1:
ORA-00936: missing expression


SQL select ONLINE from v$recover_file;

no rows selected

Also, online is a reserved word and that is why you originally get the
ora-00936 error:

SQL select * from v$reserved_words where keyword ='ONLINE';

KEYWORD  LENGTH
 --
ONLINE6

SQL 

Regards,
Bruce Reardon.

-Original Message-
Sent: Tuesday, 28 August 2001 8:22 

All, I got a problem with v$recover_file.  Somehow the
query failed if selecting is on ONLINE column.

SQL desc v$recover_file;

 Name  Null?Type
 - 
---
 FILE#  NUMBER
 ONLINE VARCHAR2(7)
 ERROR  VARCHAR2(18)
 CHANGE#NUMBER
 TIME   DATE



These are OK:
---
select  CHANGE#  from v$recover_file; 
select TIME from  v$recover_file;
select * from v$recover_file;

However these gave me error:

select  ONLINE from v$recover_file;
select online, ERROR from  v$recover_file;
select  FILE# , ONLINE,ERROR , CHANGE#,TIME from 
v$recover_file;
 *
ERROR at line 1:
ORA-00936: missing expression

SQL select v.name, b.online
  2  from v$datafile v, v$recover_file b
  3  where v.file# = b.file#; 
select v.name, b.online
 *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or
column specification


What's happening?!  Thank you.

Andrea
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Burning game CD's

2001-08-28 Thread Jared Still



Please reread my previous post.

Jared

On Monday 27 August 2001 22:00, Jenkins, Michael wrote:
 Sorry, I was just observing our fine country's fair use laws.  If I pay
 for a CD then I should be allowed to back it up just in case the disc
 becomes unusable.  Please don't use the information I've provided if you
 intend to pirate CDs.  After all Thomas Jefferson would be very happy to
 know that we are reverting back to his original concept of copyright law
 which only entitled exclusive ownership of your works for a limited time -
 - after that it went into the public domain!

 --Michael

 -Original Message-
 Sent: Monday, August 27, 2001 11:00 PM
 To: Multiple recipients of list ORACLE-L



 Please, let's not distribute copyright infringement
 schemes via this list.

 Opinions on fairness of the law, etc., are really
 not important here either.

 Jared

 On Monday 27 August 2001 08:46, Kevin Kostyszyn wrote:
  Actually, I have the crack to AOE, you want it?
 
  -Original Message-
  Tom
  Sent: Monday, August 27, 2001 10:55 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Off Topic:  I bought a PC this weekend that had my first every CDROM
  burner. I
  couldn't wait to use it.  I burned several game CD's (Age of Empires,
  Return Fire II, Roller coaster Tycoon) and none of them worked.  The
  games just hung
  when I ran them.  Bummer.  Is it not possible to make copies of my CD's
  or am I
  doing something wrong?
 
  Tom
 
  Tom Terrian
  Oracle DBA
  WPAFB - DAASC
  [EMAIL PROTECTED]
  937-656-3844
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Terrian, Tom
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 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 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: Jared Still
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DBMS_JOB Help

2001-08-28 Thread Paul Drake


Rangachari Sundar wrote:
 
 Hi All,
 
 Can Anyone tell me how to stop a background job initiated through a
 DBMS_JOB package when it is no longer required?
 
 Thanks in advance.
 
 Regards
 Sundar
 
 --

desc dbms_job

I believe that this will have some effect:

exec dbms_job.isbroken(:job_id,true); 

- and - you could kill the SNPn process that is executing the job. 
Use orakill for best results.
Just killing the session is too ineffective.
If you just kill the SNPn process without breaking the job first, the
next SNPn process will start it back up again.

disclaimer: posting from memory without reading anything.

Paul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: svrmgrl, sqlplus question ???

2001-08-28 Thread Nirmal Kumar Muthu Kumaran


in dos prompt,
c:\ sqlplus /nolog

sqlconnect / as sysdba
sql sho user
SYS

now you can do all dba activities in this account.

Nirmal.
 -Original Message-
 From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 28, 2001 12:21 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  svrmgrl, sqlplus question ???
 
 Hi all,
 
 In sqlplus, you can use col ... format ... to make
 the output pretty. Can we format columns, make title
 in svrmgrl?  
 
 Also I read that sqlplus can be used to mount, open
 database in 8i, but I don't see how.  
 
 The db is 815 on Sun 5.6.  
 
 Thank you!
 
 Janet
 
 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Janet Linsy
   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 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 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: Nirmal Kumar  Muthu Kumaran
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Efficient way to monitor table growth...

2001-08-28 Thread Jonas A Wetterberg


I hade to make a little script a while ago to figure out the numbers of
rows/table. 

Declare
  cursor tables is
   select object_name, owner
   from all_objects
   where object_type = 'TABLE'
   order by owner;

  stmt_ VARCHAR2(2000);
  rows_ NUMBER;
 begin

  For rec_ IN tables LOOP
stmt_ := 'SELECT count(*) from ' || rec_.owner || '.' ||
rec_.object_name;
EXECUTE IMMEDIATE stmt_ INTO rows_;
   
Dbms_Output.Put_Line('Table: ' || rec_.owner || '.' || rec_.object_name
|| ' has ' || rows_ || ' rader');

  END LOOP;

end;

-Ursprungligt meddelande-
Från: Denmark Weatherburne [mailto:[EMAIL PROTECTED]]
Skickat: den 28 augusti 2001 0:59
Till: Multiple recipients of list ORACLE-L
Ämne: Efficient way to monitor table growth...


Hi DBA's

Does an Oracle Stored Procedure or function exist that returns the row count

by table in each tablespace?
I've observed that one of our production tablespaces is has only 8% free 
space. Perhaps it could be fragmented. I'll have to find a script that can 
provide these statistics. I know I'll need to add another datafile to the 
tablespace soon.
However, I'd like to find out which are the active tables in each tablespace

and track the row insert growth on a daily basis.

Any ideas?

Thanks for your help.

Denmark Weatherburne
Belize
Knowledge is power, but it is only useful if it is shared!

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denmark Weatherburne
  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 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 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: Jonas A Wetterberg
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: creating the database from another

2001-08-28 Thread Bunyamin K. Karadeniz




Ok Thomas , 
thank you but another question rises here for me. 

  The drive of 
soucedb is E but my targetdb will be on D drive. How will I manager that 
?
  And in 
the control file backup , there is "reuse" keyword . will I neglect it? 


Thank you
Bunyamin

Fwd: OT: Magazines for Oracle unix performance

2001-08-28 Thread Viraj Luthra


Hello all,

Any recos. for this? I am subscribed to Oracle Mag. but any others out there, which I 
can make use of on a day to day basis!

rgds,

raja 
--

- Forwarded Message -

DATE: Sun, 26 Aug 2001 23:35:42
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Hello all,

I want to subscribe to some top magazines for oracle  unix performance. Do you have 
any recommendations for this, I need the best one for both of them. Please while 
recommending explain what you liked about the magazines, like eg you like magazine x 
because it carries performance issues and they are explined in detail month after 
month, or magazine y because it is trnedy and explains technology features soming in 
the market for unix or oracle. 

This is just an example, but feel free to comment, why you recommend what you are 
recommending. 

TIA,

raja


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

- End Forwarded Message -



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: svrmgrl, sqlplus question ???

2001-08-28 Thread Paul Drake


yes, if you can get console access, this is how you log in as a member
of the ORA_DBA group.
So what's your point?
If you had console access, you could have just deleted and recreated the
password file.
Those extra 75 characters typed by typing orapwd ... would slow the
would-be cracker up just a bit - but not alot.


Nirmal Kumar Muthu Kumaran wrote:
 
 in dos prompt,
 c:\ sqlplus /nolog
 
 sqlconnect / as sysdba
 sql sho user
 SYS
 
 now you can do all dba activities in this account.
 
 Nirmal.
  -Original Message-
  From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
  Sent: Tuesday, August 28, 2001 12:21 AM
  To:   Multiple recipients of list ORACLE-L
  Subject:  svrmgrl, sqlplus question ???
 
  Hi all,
 
  In sqlplus, you can use col ... format ... to make
  the output pretty. Can we format columns, make title
  in svrmgrl?
 
  Also I read that sqlplus can be used to mount, open
  database in 8i, but I don't see how.
 
  The db is 815 on Sun 5.6.
 
  Thank you!
 
  Janet
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-10027 in ps/sql block

2001-08-28 Thread Thomas, Kevin


What does the code look like?

-Original Message-
Sent: 27 August 2001 18:56
To: Multiple recipients of list ORACLE-L


I have a developer here who is trying to populate a cursor.  Every time he
runs his code he gets the above error stating that the buffer is too small.
We have tried explicitly setting the buffer to 1,000,000 bytes.  This is FAR
greater than needed for the amount of data requested.  No matter what buffer
size we set he still gets the overflow.

We have tried both of the following ideas from metalink

Any ideas?

Rodd Holman

Doc ID:   Note:1005230.6Content Type:
TEXT/PLAIN
26-AUG-1994
Type: PROBLEM   Last Revision Date:
13-JAN-1995
Status:   PUBLISHED


Problem Description:



Problem Explanation:



NEW PROBLEM

Solution: INCREASE THE SIZE OF THE BUFFER


Solution Description: 
= 
   
Increase the size of the buffer.  The size of the buffer must be an integer 
between  
2,000 and 1,000,000. 
   
Solution Explanation: 
= 
   
Use one of the following two methods to increase the size of the buffer: 
   
1.  At the SQL*PLUS or SQL*DBA prompt, type 
SET SERVEROUTPUT ON SIZE n 
where n is an integer between 2,000 and 1,000,000.  
 
Example: To increase the buffer size to 10,000 type 
SET SERVEROUTPUT ON SIZE 1 
 
2. Inside the PL/SQL block type 
   DBMS_OUTPUT.ENABLE(n) 
   where n is an integer between 2,000 and 1,000,000.  
   
   See Appendix A of the Oracle7 Server Application Developer's Guide for 
   an explanation of the ENABLE command.
  .
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  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 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 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: Thomas, Kevin
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: tnsnames error

2001-08-28 Thread nlzanen1



Hi,


DBA-Studio is absolutly horrible with tnsnames.ora files. It expects the
exact formatting as done by the net assistant. Any manual alteration may
cause the behaviour you are experiencing.


Jack




Ravi R [EMAIL PROTECTED]@fatcity.com on 28-08-2001 03:55:21

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

  I am getting an error when I try to connect to the DBA Studio of Or9iAS
the error is  failed to parse tnsnames.ora file Error:100 --NLNV-NLNV
String
format error. I tried to recreate a new tnsnames,but again shows the same.
Do
any body know how to rectify the error.

Thanks
Ravi






Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravi R
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst  Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying,  distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst 
Young is neither liable  for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.
===





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Installing 73 and 816 on one NT server?

2001-08-28 Thread Paul Drake


maybe he's just a fan of dirty_region_logging :)

Mohan, Ross wrote:
 
  YES
 
 -Original Message-
 To: [EMAIL PROTECTED]; Mohan, Ross
 Sent: 8/27/2001 10:08 PM
 
 Are you an idiot?
 
 On Monday 27 August 2001 09:16, Mohan, Ross wrote:
  HELP
 
  -Original Message-
  Sent: Friday, August 24, 2001 3:51 PM
  To: Multiple recipients of list ORACLE-L
 
 
  nobody would be that dumb, would they? :)
 
   --
  
From: Mohan, Ross [EMAIL PROTECTED]
Date: Thu, 23 Aug 2001 11:13:04 -0400
Subject: RE: Installing 73 and 816 on one NT server?
 
  [via ORACLE-L Digest -- Volume 2001, Number 236]
 
   ... sw raid?
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mohan, Ross
   INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A quick pl/sql datatypes question

2001-08-28 Thread Thomas, Kevin


It may be better to name it specifically as INTEGER etc. but good practice
would dictate using the %TYPE option..

K.

-Original Message-
Sent: 27 August 2001 17:01
To: Multiple recipients of list ORACLE-L


Dear gurus !
What is better performance-wise - to declare a variable inside a pl/sql
block (or a trigger) as integer (number , Pls_integer etc..) or as
mytable.mycolumn%TYPE .
Again , i'm concerned ONLY about performance in this question.

Thanks a lot.

DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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 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 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: Thomas, Kevin
  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 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 mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT RE: RE: How do you audit a DBA?

2001-08-28 Thread Guy Hammond

Title: RE: OT RE: RE: How do you audit a DBA?

I
went to see that movie, The Mummy Returns, when it came out, 'cos The Rock was
in it, and I was hoping for some long, rambling monologues from the Scorpion
King about how he planned to lay the smackdown on the Egyptians' candy asses,
shut your mouth and know your role Imhotep, FINALLY the ROCK has come BACK to
CAIRO! and so forth.

Instead, he didn't say much at all. But that's OK,
I'llhappily watch any movie with Rachel Weisz in...
;0)

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001
3:25 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: OT RE: RE: How do you audit a DBA?
C'mon. I'd vote for The Rock
instead, along with all The Rock's "witty" comments. That would be
awfully darn distracting, and you could be sure your DBA would get NOTHING
done :)
Honestly, if there's a need to audit
the dba, maybe he or she should be replaced? Just curious.
Can you smell... what
huge awful mess the DBA... is cooking?
Sorry, couldn't resist
Lisa Koivu Oracle Database Administrator 954-935-4117

-Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: OT RE: RE: How do you audit a DBA?
I have all of them save two, one of which was
mailed to me last week...
I think I have way too many Conan novels, it's
like Harlequin for men!
I have many double copies, I think I'll post them
on eBay eventually to get rid of
them.
: )
Patrice Boivin Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 6:30 PM
To: Multiple recipients of list
ORACLE-L Subject: RE: RE:
How do you audit a DBA?
Why
don't you get some Conan the Barbarian lookinn fella to stand
behind
this
mistrusted dba all day?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Author:
Boivin, Patrice J 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 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 mailing
list you want to be removed from). You may also send the HELP command for other information (like
subscribing).

1 2 >

1 - 100 of 154 matches

Mail list logo