Hi Chris,
Is that you, bellow your main page?
I mean before that guy mutates to something else of course. : )
You have lot of experience and know lots of technology.
Sinardy.
-Original Message-
Spence
Sent: Saturday, 19 May 2001 4:00 PM
To: Multiple recipients of list ORACLE-L
Some
At 20:35 -0800 20/5/01, Seley, Linda wrote:
Oh, Perl gurus, is there a function in perl that will let me do connect
internal?
$dbh = DBI-connect(DBI:Oracle:, internal,,{ ora_session_mode = 2 });
But before you get carried away, it may not do what you want. If for
example you were hoping that
Hi All,
The May 2001 issue of Ixora News is now available online at
http://www.ixora.com.au/newsletter/2001_05.htm.
In this issue ...
Sin-onyms - Are synonyms really bad?
Not so fast - Incremental checkpointing can defeat commit cleanouts
@ Regards,
@ Steve Adams
@
Oracle itself suggests to analyze ALL SYS OBJECTS
before an upgrade to 8.1.6 from 7.x or 8.0.x versions.
This is because of default DB_BLOCK_CHECKING for
SYSTEM tablespace.
Just have a look at metalink note 100419.1
HTH,
Rajesh
-Original Message-
C.S.Venkata
Subramanian
Sent: Monday,
OK, i've got a table with 302068428 rows. Im in the process of creating a
nonunique index on this table, how much space do i need in the TEMP
tablespace for the creation of this index.
Name Null?Type
-
Hei Rachel.
I don't know whether you still remember me or not. Last time my x-company is
using oracle 6.x ,and I use to logto this oracle-list.after I resign and
jump over to a consulting firm doing informix developer.
Now I come back to Oracle,lucky I found a job where they are using Oracle 8i
Hi Waleed,
great tip to set sql_trace. See the last statement:
analyze table SYS._DEFAULT_AUDITING_OPTIONS_ COMPUTE statistics
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
Actually ADSM is the backup software. They moved it over to the Tivoli
brand last year and now call it their Data Protection product.
Tivoli generally specializes in network management products, much like
CA. See www.tivoli.com
Regards,
David A. Barbour
C.S.Venkata Subramanian wrote:
Well you asked the right question to the right person!! Grab yourself a copy
of the book Rachel co-authored - DBA 101!
Mark
-Original Message-
Meng Hong
Sent: Monday, May 21, 2001 10:45
To: Multiple recipients of list ORACLE-L
Hei Rachel.
I don't know whether you still remember me
Zabair,
Since you've got data in the table you must have an idea of how big the
actual index will be. Rule of thumb for me it 3 times the size of the actual
index for a normal b-tree index. Two times for a bit map. This has yet to fail
me.
Dick Goulet
Reply
Hi Glen,
A tablespace created with the CREATE TEMPORARY TABLESPACE command uses tempfiles
instead of datafiles, and as such is often called a tempfile tablespace. A
tempfile tablespace is equivalent to a locally managed datafile tablespace with
temporary contents, except that tempfiles do not
HI ALL,
while querying the v$option view, i
came to know thatPartitioning option is false.
due to this i'm unable to create
partitioned tables. how to enable such options. can i enable it
now.
i've oracle 8i version 8.1.5 on
NT4.0
thanks in advance.
saurabh.
On Mon, 21 May 2001,Raymond Lee Meng Hong scribbled on the wall in glitter...:
-
-Is there anybook for a beginner to start he' DBA knowledger/experience?
Well, by now you've probably gotten a lot of responses to this, but I'll stick in my
$0.02 anyway.
I recommend and have used to train the
Thank you, no actually it is Bill Gates mutating into the devil. Then
scaring the pants off the mouse.
Was bored :)
Christopher,
www.vampired.net
-Original Message-
Sent: Monday, May 21, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L
Hi Chris,
Is that you, bellow your main
Hi,
I performed an import job in oem 2.1 of some tables oracle database 7.3.2
into oracle 8.1.6 schema , the size of dump file is 10k, the dump file is in
an other server novell 5.1 in a volume NWFS, for the link i mapped a virtual
drive K, but the job failed in oem console with :
---
You may start with Oracle Concepts manual and move on Administrator's guide.
--
On Mon, 21 May 2001 01:45:23
Raymond Lee Meng Hong wrote:
Hei Rachel.
I don't know whether you still remember me or not. Last time my x-company is
using oracle 6.x ,and I use to logto this oracle-list.after I
I beleave that if sort_area_size is large enough to have only one merge pass
(see Steve Adams web site to calculate ) - you will need only a little more
space that needed for index.
Alex Hillman
-Original Message-
Sent: Monday, May 21, 2001 10:11 AM
To: Multiple recipients of list
Hi, I created a table with a LONG type. From what I read in the Oracle docs
LONG supports up to 2 gigs of data. But I am not able to insert more than
4000 characters into that field.
i have this message error : ORA-01704 String Literal Too Long
any help please.
--
Please see the official
Is it possible to check if a table first exist so I do not
get any error messages on my installation scripts?
*
ERROR at line 1:
ORA-00942: table or view does not exist
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
On Mon, 21 May 2001,benajam lhoussain scribbled on the wall in glitter crayon:
-Hi, I created a table with a LONG type. From what I read in the Oracle docs
-LONG supports up to 2 gigs of data. But I am not able to insert more than
-4000 characters into that field.
-i have this message error :
Hi!
I have the following problem: I create a procedure where I use
dbms_lob.writeappend function:
CREATE OR REPLACE PROCEDURE kelu.append_to_blob(name_of_index VARCHAR2, amt
BINARY_INTEGER, buffer RAW) AS
BEGIN
DECLARE
lob_locBLOB;
begin
SELECT app_blob INTO lob_loc FROM
Two ways to handle this in an installer:
1. Build everything in dependency order. This can be a pain because it
tends to change any time the schema is touched.
2. Create everything (specify force on indexes) ignoring the errors.
Spool them to a file and turn termout off if you don't want the
Using PL/SQL you can select by PK with rownum 2 and just catch an
exception.
-Original Message-
Sent: Monday, May 21, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Is it possible to check if a table first exist so I do not
get any error messages on my installation scripts?
All,
Anyone heard of this
utility for Oracle ?. Someone mentioned it today and I didn't have a clue. They
said it would be in $ORACLE_HOME/bin. Nothing there !!
Regards
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
Lee,
Copy is a SQL*Plus command as in
copy from username/password@database -
to username/password@database -
create/append/replace table_name -
using select column1, column2, etc... -
from table_name_at_source;
The arraysize and copycommit parameters control how often a commit
Benajam,
If you know it you can use Perl, with something like the code below which
will insert a string containing the value
I_inserted_a_long_abcd1234567890qweerrtrtyyuuiiioooppp
concatenated a 10 times, and replace $long_field with your own data or
do a loop to read it in from
You have wild imagination if after reading this note 100419.1 your
conclusion is that Oracle recommend to analyze SYS objects. I include text
of this document.
Alex Hillman
Doc ID:
Note:100419.1
Subject:
SCRIPT: VALIDATE.SQL to ANALYZE ..
VALIDATE objects in a
I disagree with the restriction of no users. After all, what better dietary
plan than all the users you can catch, kill, and eat! Otherwise, I'm in.
I can haul some of our ordinance in my F-150 - it'll even be dry with the
hardtop on the bed...
Scott Shafer
San Antonio, TX
210-581-6217
How about User Pot Pie?
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Glasrot, Nechama [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 3:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT: RE: job offer from SAUDI ARABIA
can we go back
Hi,
How do I calculate the amount of physical space
required for storing a number? (i.e. NUMBER,
NUMBER(5), NUMBER(10,5), etc.) I believe Oracle uses
2's compliment for storing numbers. A value of 1
does not seem to take up the same amount of space as
9.
TIA!
-wk
Yes, but you have to use a temporary tablespace or TEMPFILE tablespace.
LMT is not supported on datafile tablespaces. Also note TEMPFILE has more
performance as they do not do any redo generation.
-Original Message-
Sent: Monday, May 21, 2001 1:36 PM
To: Multiple recipients of list
I tend to agree, don't steal if you don't want to loose your hand.
But I think if it is less than $5 you should only loose a finger.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:24 PM
To: Multiple recipients of list ORACLE-L
Blame Canada! grin
In oracle financials 11.5.3, have table called fnd_lobs.
analyze table estimate statistics/compute statistics hangs.
validate structure hangs - drives cpu to 60-80 percent but never
finishes.
dbms_stats.table_gather - works!!!
Anybody else see this.
Jeffrey BeckstromDatabase
Walter:
You use the VSIZE() function. And you are right about 1 not taking the
same amount of size as 9. 1 uses 2 bytes and 9 uses 4.
SQL select vsize(1), vsize(9) from dual;
VSIZE(1) VSIZE(9)
24
Kevin
Howdy,
The only bulkcopy utility
that I know of is a Sybase utility. The Sybase bcp command moves data from a
flat file to a Sybase table and vice versa. I dont know of any such command in
Oracle.
Bill
Carle
ATT
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
Bulkcopy is a Sybase utility. You can do bulk loading via sqlldr and the
only way to do bulk extract in a readable format is to use sql*plus or some
other program.
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Oracle's Self-Praise Conflicts with Analyst
Findings http://www.internetnews.com/asp-news/article/0,,3411_767421,00.html
DB2, 9i war looms large
http://gethelp.devx.com/pubs/infoworld/vol23/issue20/010514hndbwars.asp
like sqlldr (flat==dbms) and data unloader (raw dbf==ascii dml)?
Rachel knows alot about this. Has a few medals in the Great Data
Wars of the Last Millenium.
-Original Message-
Sent: Monday, May 21, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Howdy,
The only
Thanks for the info. I know about the VSIZE function,
but how do I estimate the amount of space manually?
What about negatives, fractional values, etc.? These
all require differing amounts of space.
Thanks again.
Walt
--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
Walter:
You use the
sqlldr. ATT obviously uses
Sybase.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle, William T
(Bill), NLCIOSent: Monday, May 21, 2001 11:46 AMTo:
Multiple recipients of list ORACLE-LSubject: RE:
Bulkcopy
Howdy,
The only bulkcopy
Oracle stores the avg_row_length in all_tables view.
Use analyze_schema to get the most recent numbers.
-Original Message-
Sent: Monday, May 21, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L
Thanks for the info. I know about the VSIZE function,
but how do I estimate the amount
Ross
sssh! those medals are SECRET!
data unloader in any case is a product that Oracle does NOT want people to
use, it's not for sale, cannot be kept on your system...you have a field
engineer come, install it, run it, and take it away.
From: Mohan, Ross [EMAIL PROTECTED]
ATT uses Oracle. Im well acquainted with sqlldr, and I assumed
that the questioner was too. I took his question to be: was there a bulkcopy
utility in addition to sqlldr and the answer as far as I know is no.
Bill
Carle
ATT
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
I think he was refering to column size, not the row size.
-Original Message-
Sent: Monday, May 21, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L
Oracle stores the avg_row_length in all_tables view.
Use analyze_schema to get the most recent numbers.
--
Please see the official
This should answer any questions on numberic size and storage.
http://www.vampired.net/forums/viewtopic.php?topic=24forum=150
Hope this helps.
-Original Message-
Sent: Monday, May 21, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
Thanks for the info. I know about the VSIZE
There
is a tool you can do to convert a table to CSV on Thomas Kyte's page, there is
also a product from Oriole called PDQ Out which will output tables into format
that can be blasted in with SQL LOADER. I would also look into
transportable tablespaces.
-Original Message-From:
I'll concede on the users for dietary purposes, but I will not budge on the
Windows OS...frustration can only lead to chaos and violence. Besides,
this is supposed to be Utopia!
I disagree with the restriction of no users. After all, what better
dietary
plan than all the users you can
Oh yeah, and they kick you out of the room when they do it.
They also purge the filesystem so you cannot undelete it by any known means.
-Original Message-
Sent: Monday, May 21, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Ross
sssh! those medals are SECRET!
data
Thanks, but the table doesn't exist yet. Also, I need
to estimate the space needs for a column of a numeric
datatype, not the row itself.
--- John Lewis [EMAIL PROTECTED] wrote:
Oracle stores the avg_row_length in all_tables view.
Use analyze_schema to get the most recent numbers.
Does anyone want to see my Hannibal Lector in a Ponytail and Speedo
Impersonation?
|| -Original Message-
|| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 21, 2001 4:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT - RE: job offer from SAUDI
maybe we can crAck it with a LoPht tRoJaN Horse Warez Vye-rus?
|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 21, 2001 4:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Bulkcopy
||
||
|| Oh yeah, and they kick you out
Are you stupid?
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Galactically OT - job offer from MARTIAN ICECAP
Does anyone want to
hm, maybe I smiled nicer at the tech than you, I got to stay in the room
not a product you want to be needing in any case, if you need data unloader,
it means that your database cannot be forced open by any means known to
Oracle and they have to go in and etch the data manually onto the dump
Actually, I just answered my own question. The
following is from MetaLink. I have seen this article
before but could not find it this morning for the life
of me!! :-)
---
Doc ID: Note:1031902.6
Internal Numeric Data Storage
-
Oracle stores numeric data in
From what I know, bulk copy or bcp as it is called in the MS SQL Server
world, is equivalent to Oracle's export/import. So instead of
exporting/importing data they must bcp'ing it in/out of the SQL Server
database. Per MS web site posting, the newer MS SQL Server improved the bulk
copy
Hello,
Please take a look at this and give your reaction :
http://www.humanityonhold.com/intifada.html
YOUR REACTION PLEASE
THANKS A LOT
Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Please
Actually, I just answered my own question. The
following is from MetaLink. I have seen this article
before but could not find it this morning for the life
of me!! :-)
---
Doc ID: Note:1031902.6
Internal Numeric Data Storage
-
Oracle stores numeric data in
Please take a look at this and give your reaction :
http://www.humanityonhold.com/intifada.html
YOUR REACTION PLEASE
THANKS A LOT
My only reaction is this: LEAVE THIS LIST ALONE. There's already a lot of
Off-topic posting going around and meaningful information is lost amidst the
various
HELP
|| -Original Message-
|| From: [EMAIL PROTECTED]
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 21, 2001 4:37 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Galactically OT - job offer from MARTIAN ICECAP
||
||
|| Are you stupid?
||
|| Scott Shafer
|| San
ooh ooh --- not me :)
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Galactically OT - job offer from MARTIAN ICECAP
Date: Mon, 21 May 2001 12:25:32 -0800
Does anyone want to see my Hannibal Lector in a
Hello fellow DBA's,
I am in a tough situation. I am trying to find an encryption solution for
Oracle 7.
I know that 8i has DBMS_OBFUSCATION_TOOLKIT, however we don't have 8i :(
We are still running 7.3.4 (OS limitations, DOS clients :(.
Anyway, did any of you ever have to implement DES
bcp will extract to readable format, unlike import/export
From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Bulkcopy
Date: Mon, 21 May 2001 12:45:50 -0800
From what I know, bulk copy or bcp as it is
On Mon, 21 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-HELP
Ross, there is no help for you!;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the
I have had to it is not one of my more favorite memories...
I don't LIKE going 40 hours without sleep
and after a while, diet Coke just doesn't have an effect :)
From: Christopher Spence [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
On Friday 18 May 2001 18:01, Jacques Kilchoer wrote:
I hope Mr. Still won't mind if I post another script in the same vein, that
I used after hearing him recommend this approach. This one also drops
public synonyms for objects in the schema being dropped. Please note that
NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alessandro Guimaraes
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
This is a very interesting editorial on corporate use of OSS.
http://www.dmreview.com/editorial/dmdirect/dmdirect_article.cfm?EdID=3436issue=051801record=1
Some may consider this off topic for an Oracle mailing list, but I
believe that those folks are in the minority.
Some very good points
There is WAY too much off-topic nonsense on this list, IMHO. That take a
job in Saudi Arabia thread hangs on, with puerile, unfunny jokes being
exchanged between individuals. I value the technical content here, and I
can appreciate the occasional (emphasis on occasional) joke, but it's gotten
While this practice would be frowned on, I have had occasion
to do something similar myself.
Developers were required to have the ability to see source
code in stored procedures in production instances through
SQL Navigator, without granting the database privileges that
would normally make this
On Mon, 21 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-I have had to it is not one of my more favorite memories...
-
-I don't LIKE going 40 hours without sleep
-
-and after a while, diet Coke just doesn't have an effect :)
You just need people shooting at you from
Val,
I doubt that this does DES encryption, but it may be better than nothing and
it does work in Oracle7. (atually came from MetaStink)
create or replace package encrypt as
function code(inp_data varchar2, key varchar2 default 'FILL IN THE BLANK')
return varchar2;
pragma
This one is SOO far off topic. I believe this is a multi national mailing
list as much as I like to keep freedom of speech alive well I really don't
want to get mired down in a strictly political discussion. At least the Saudi
posts had to do with working there as an Oracle professional
As i recall, you got free flowers for it, no?
|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, May 21, 2001 5:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Bulkcopy
||
||
|| I have had to it is not one of my more
hi gurus
My Asynchronus multimaster replication is working fine. But the moment i
remove the physical connectiviy (network link),it hangs without even
updating local data base. i mean it's not allowing me to commit insert
statement at one location.
Can anybody helps me in this.
thanks
Me and a guy here from work are pretty big into the mountain climbing.
Mt. Hood is an hour away and its one of those mountains that you tackle
starting at midnight and finish around 10-11AM. So basically you go
without sleep for quite a while since we both usually have not been to
bed since the
Has anyone seen this error and found what the solution was?
Hoping for a long shot here
Joe
$ svrmgrl
exec(): 0509-036 Cannot load program svrmgrl because of the following
errors:
0509-130 Symbol
look at relinking the svrmgrl executable, ensure there is no 7.3
libraries in path BEFORE the 8.x libs(assuming an 8.x database).
you got metalink, search for it, i'm 90% sure its on there.
joe
Leyden, Joseph wrote:
Has anyone seen this error and found what the solution was?
Hoping for a
Hi Steve,
Is there any disadvantage to using a tempfile tablespace for the TEMPtablespaces
used by the application? Apart from the fact that they are non-recoverable.
In the past Ihave created TEMPtablespaces with datafiles.
I suppose the nature of the temp tablespace is that it contains
Nihar,
Don't remove the network link!!
O.KI'm not a replication guru, but my thoughts are that the way
replication is setup, the commit can only happen if the data can be
replicated as it should. If there is no network connectivity, the instance
cannot get to one of the other required
Diane,
If you rely on Oracle to do the checking, it will
be much faster.
Jared
create or replace function is_number( chk_data_in varchar2 )
return boolean
is
dummy number(38,4);
begin
dummy := to_number(chk_data_in);
return true;
exception
when value_error then
can't you utilize the comment column?
-Original Message-
Sent: Friday, May 18, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Does anyone know if it is 'safe' to add additional columns
to user_tab_columns? I am running 8.1.5. I would use the new
columns to tell the application
Could somebody please provide an example of returning clause for update,
delete or insert SQL statement when there is an update, delete or insert of
multiple rows. I know how to do it if there is one row.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Joe,
OS and Oracle version???
Dick Goulet
Reply Separator
Author: Leyden; Joseph [EMAIL PROTECTED]
Date: 5/21/2001 1:56 PM
Has anyone seen this error and found what the solution was?
Hoping for a long shot here
Joe
Problem was solved from my AIX group list.
All I needed was to install and load
load the post-wait kernel extensions.
Thanks for any response you gave.
Joe
-Original Message-
Sent: Monday, May 21, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L
Joe,
OS and Oracle
Hi all,
How to make a Unix file writable by anybody? The file
should be owned by dba, but also writable by non-dbas.
-rw-rw-rw- 1 jcsora dba0 May 21 16:00
dbbackup_sched.dat
-rw-rw-r-- 1 jcsora dba0 May 21 16:01
del_base_sched.dat
Currently dbbackup_sched.dat
Oh boy :)
I can see that as a seal or a hunting while kegging but last time I got
shot at is when I was playing paint ball (13 balls/s x 130MPH is pretty
nasty). Colleages are kind of afraid what would happen to the database if I
got shot.
-Original Message-
To: Multiple recipients
chmod ugo+w dbbackup_sched.dat
where u user , g group, o other ... + to add, w for write.
naren
-Original Message-
Sent: Tuesday, May 22, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
Hi all,
How to make a Unix file writable by anybody? The file
should be owned by dba, but
do chmod 666 del_base_sched.dat
-Original Message-
Sent: Monday, May 21, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L
Hi all,
How to make a Unix file writable by anybody? The file
should be owned by dba, but also writable by non-dbas.
-rw-rw-rw- 1 jcsora dba
Hi!
Well, i am not going to remove the link but What if the internet
connectivity fails. My DB servers are at different locations and i am doing
it through WAN link .Is there any way to queup the data till links come up.
thanks
-Nihar
-Original Message-
Sent: Tuesday, May 22, 2001
please note you said copies :)
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: adding columns to system tables
Date: Mon, 21 May 2001 13:36:23 -0800
While this practice would be frowned on, I have had
nope, nothing. they don't give away the product :)
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OTRE: Bulkcopy
Date: Mon, 21 May 2001 14:10:29 -0800
As i recall, you got free flowers for it, no?
||
Hi Unix Gurus,
Does anyone know how to send a file db_backup.log to receipient
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cc [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] with Subject Backup Log file in Unix ?
Thanks.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hello Christopher,
What is the meaning of hard parse / soft parse on the article on 'Are
synonyms really bad?'
Latch mean for what ???
Sorry for asking sooo stupied question. but I just start my DBA knowledge
.previously I'm a informix developer.
I have download some really good
Hi Guys
I need help from you abt URL
forwarding , Email Forwarding and Domain parking .
Can you give me any suggestions or tips.
please
Regards
Magesh
STARTUP FORCE will accomplish the same thing.
Jared
On Friday 18 May 2001 15:17, [EMAIL PROTECTED] wrote:
Hi, Gurus,
One of my colleagues killed ora_pmon and other background processes. If we
log into svrmgrl, then the messge connect to idle instance show up. We
are trying to bring the
Hi, listers:
Does anyone know C-ISAM and it can be used in Oracle? or just for the
Informix.
Thanks in advance.
Rgds,
Annie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Zhang Yuan Lin
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Take a look at my article on encryption on Oracle.
It can be found at www.cybcon.com/~jkstill/util
It has some solutions ( such as RC4 ) that can
be implemented on Oracle 7.
There's also a Blowfish implementation there courtesy
of Craig Munday.
Keep one thing in mind: encryption via PL/SQL
Nihar,
This is not normal. Asynchronous propagation
populates the deferred transactions queues which are
then pushed at a later time, so the only thing that
should happen when network connectivity is lost is
that the job pushing the queues will fail. Once
connectivity is re-established the job
Diane,
Musta been a bug, as this was originally done on 7.3.something.
Jared
On Monday 21 May 2001 15:22, [EMAIL PROTECTED] wrote:
Jared,
That's absolutely true, now. In the past (don't ask me when, I think it
was version 7 something), I found that exceptions for some reason took a
You could do a
man mailx
and find the information that will help you.
you could do this also:-
mailx -s $MSG_TITLE $MAIL_TO_ADDRESS $FILE_WITH_MESSAGE_BODY
The above is assuming onl the subject and mailto and message file to be sent across.
But better you open the man page on mailx and
1 - 100 of 110 matches
Mail list logo