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
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
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_ :
in dos prompt,
c:\> sqlplus /nolog
sql>connect / 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-
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(
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
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
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
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
> qu
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rangachari Sundar
INET: [EMAIL PROTECTED]
Fat City Networ
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
>
>
> nobod
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 tha
Wow, someone had a really bad day! It's ok to post things like this, we'lll
try to keep this in mind the next tiem you post a question!
KK
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 6:16 PM
> You are doing several thin
Hi all,
Thank you Kirti, Irfan, Shah
-Original Message-
Sent: Tuesday, 28 August 2001 10:47 AM
To: [EMAIL PROTECTED]; LazyDBA.com Discussion
Sinardy,
Here is one way to do it (using CHR(10) for new line) :
SELECT 'NAME : ' || ename || CHR(10) || ' DEPARTMENT : ' || dept || CHR(10)
Try CHR(10)
.ie. SELECT 'NAME : ' || ename ||CHR(10)||'DEPARTMENT : ' || dept ||
CHR(10)||'SALARY : ' ||sal FROM emp;
Hope it helps.
Regds,
Chorling
-Original Message-
From: Sinardy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28,
Sinardy,
Here is one way to do it (using CHR(10) for new line) :
SELECT 'NAME : ' || ename || CHR(10) || ' DEPARTMENT : ' || dept || CHR(10)
|| ' SALARY : ' || sal
FROM emp;
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Messa
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || ' DEPARTMENT : ' || dept || ' SALARY : ' ||
sal
FROM emp;
Result:
NAME : JAMES DEPARTMENT : LAB ENGINEER SALARY : 2000
NAME : BOB DEPARTMENT : DRIVER SALARY : 2
Thanks. That's it.
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 28 August 2001 12:15
> To: [EMAIL PROTECTED]; Ross Collado
> Subject: Re: OT:Unix Q
>
>
>
> do a 'man ssh-keygen'
>
> Jared
>
> On Monday 27 August 2001 19:41, Ross Collado wrote:
do a 'man ssh-keygen'
Jared
On Monday 27 August 2001 19:41, Ross Collado wrote:
> To all Unix gurus,
>
> What's the command to generate an "identity.pub" file for use in ssh ?
>
> Rgds,
> Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL
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
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: "Moha
man ssh?
joe
Ross Collado wrote:
>
> To all Unix gurus,
>
> What's the command to generate an "identity.pub" file for use in ssh ?
>
> Rgds,
> Ross
> --
--
Joe Testa
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel
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
To all Unix gurus,
What's the command to generate an "identity.pub" file for use in ssh ?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
FYI,
We have NT4, 1Gb RAM.
Fibre Channel Disks
Tape Drive is a Dell (Quantum) DLT7000 connected via SCSI.
Using Backup Exec.
Our total backup and verify is 17.6Gb which takes 126 mins (2.4MB/sec but
includes verify).
If I consider just a 1 drive backup only (ie no verify) we backup approx 5
Gb a
Title: RE: How fast are your tape backups?
50 gigs in 1.5 hours.
HPUX 10.20
OmniBack 3.5
Oracle 7.3.4
HP DLT8000
Regards,
Satar Naghshineh
-Original Message-
From: J.C. Stofer [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 2:05 AM
To: Multiple recipients of list
i didnt think you could have 2 oracle homes with that low of a verison
difference, i thought the lowest was x.x.x anything below that couldnt
have different oracle homes, am i wrong here?
joe
Doug C wrote:
>
> We have 2 Oracle Homes, one of which was upgraded to 8.1.7.1 on Jul 25th. The
> other
For those interested..
We migrated by exp/imp from 8.0.6 to 8.1.7. Got some errors on system objects but so
far everything is going smoothly.
>>> [EMAIL PROTECTED] 08/24/01 17:13 PM >>>
system can get hosed up weird, part of it depends on ignore= setting.
if you do ignore=y then it will poten
When I'm logged onto the Unix system as user "oracle"
using 9i, Oracle refuses to allow me to log into it by
just using "/". It insists that always include the two
words " / as sysdba"! Since it precludes me from
logging into Oracle just using "/", what is gained by
forcing me to always specify "
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
you cannot format in svrmgrl and you should start learning to use sqlplus
for this stuff, as svrmgrl goes away in 9i
in sqlplus what I do is:
sqlplus
then at the username prompt I type
/ as sysdba
once you do that you can do startup and shutdown
>From: Janet Linsy <[EMAIL PROTECTED]>
>Re
Title:
Hello Ladies and Gentlemen,
I need to present a proposal to management on Upgrading our database from Oracle 7 to 8i (don't laugh, we know we're behind the times!). I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal or
Hello list. I have a brand new database that is around 200 GB in
size. Our tape backup solution which was supplied by the hosting
company is only giving me bewteen 6 and 7 MB per second . A full cold
backup can take 8 to 10 hours at this rate.
I looked at the specs for the tape library they
In general, you don't need to know the rowcounts
if you know the typical size of a row and the total
space usage for a table/index. An analyze will
get you these figures as a starting point.
After that, you need only track the object's
high water mark using the dbms_space package
to track growt
Hello - this is AIX 4.3.3
We did an 8.1.7 install into a separate home which required a new pw-syscall be
loaded.
An 8.0.5 database then started to act funny. (couple of core dumps a day that
aren't always repeatable).
I though that pw-syscall was largely an extension to handle semaphores and
Analyze tables then look at dba_tables.num_rows. Doing it on a daily will
give you what you want.
HTH,
Michael
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 15:58
> Hi DBA's
>
> Does an Oracle Stored Procedure or funct
Dear Friends
Thank you somuch for your valueble input for my job. I leared alot from
these lists!! Thankyou all.
Raghu.
>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>To: Raghu Kota <[EMAIL PROTECTED]>,"LazyDBA.com Discussion"
><[EMAIL PROTECTED]>,[EMAIL PROTECTED]
>Subject
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 kno
Well, to play the Devil's advocate here, the big advantage of export/import
is that it's faster than recovering from RMAN and takes much less disk
space. Here we're contractually obliged to recover customers' data from a
previous night's backup, not earlier. So, an export can work for us. We do
ex
H DBA's
We are running Oracle 8.0.5.0.0 on the NT platform.
I'm currently collecting information about Oracle's Statspack.
I found out that I can run it on Oracle 805 as well even though it was
released for Oracle version 816.
I was looking at the Oracle8 Performance Monitor v8.0 GUI tool that
The database setup for an application is as follows...schema1 (owns objects)
and schema2 (accesses objects owned by schema1).
I need to copy the DB setup for the application to a test server set up with
a development-like setup, i.e. instead of the tablespaces that are created
in production for th
Yup, just did that 2 weeks ago.
Steve Orr
-Original Message-
Sent: Monday, August 27, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L
I think recommending regular exports for a 150Gb database is a
mistake.
Instead, you should practice using RMAN to restore and recover to a
sepa
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
Raghu,
We use BMC - PATROL for database monitoring. However, we removed all the
out-of-box actions by it, and replaced those with our own where ever needed.
We do not let Patrol change anything in the database (for example,
allocating space when it detects extent problems). Instead, it e-mails and
You are doing several things wrong:
a) You are mailing yuor question to the wrong list.
b) You haven't read the fine manuals.
Conclusion: RTFM and do that somewhere else.
Have a nice day.
> -Original Message-
> From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001
Mitchell wrote:
>
> DBAs
>
> Last week one of my user dropped a table since we don't have any backup
> except for rman backup. It is not allowe me to do any recovery on 7/24
> database. Anyway we recreate the table(we are lucky, this table hold
> parameters)
>
> This make me think of situation
I think recommending regular exports for a 150Gb database is a
mistake.
Instead, you should practice using RMAN to restore and recover to a
separate location. You can limit the size and complexity of a single
table restore by restoring only the table's tablespace, the SYSTEM and
any tablespaces
Title: RE: Data Center monitoring
I agree. I have never seen a monitoring tool that worked better than your own tried-and-true trusty scripts.
-Original Message-
From: Stephen Andert [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 5:21 PM
To: Multiple recipients of
Janet Linsy wrote:
>Hi all,
>
>In sqlplus, you can use "col ... format ..." to make
>the output pretty. Can we format columns, make title
>in svrmgrl?
>
AFAIK, you can't.
>
>
>Also I read that sqlplus can be used to mount, open
>database in 8i, but I don't see how.
>
invoke sqlplus and at th
Well, I think we have a solution for our mysterious locking problems.
For those of you who do not know, I sent a note out earlier this week with a
mysterious problem of locks happening on an application that was running
find last week no changes except increased user base.
We looked at eve
I would suggest to export schema by schema and schedule the jobs to run
different time. In the export job, use pipe file at the unix level to
compress the export file. The command is as follows:
To export and compress at the unix level...
mknod export_pipe p
compress < export_pipe > export.dmp
yeah, and they said the same thing about the solaris ones... and you didn't
have to unzip them either
>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle 9i Linux files are erroring during un
Raghu,
Well, I/Watch is nice when it works. While we were attempting to roll it out the
first (and second) time, I left most of my "manual" old fashioned scripts running
through cron. Many times, things that were supposed to page or e-mail us from I/Watch
didn't. But sometimes they would.
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
DBAs
Last week one of my user dropped a table since we don't have any backup
except for rman backup. It is not allowe me to do any recovery on 7/24
database. Anyway we recreate the table(we are lucky, this table hold
parameters)
This make me think of situation of lossing very important big tabl
Title: RE: Data Center monitoring
HELP
And get LOTS OF IT
Look at MC Service Guard to enhance availability. In addition, see if you can use some sort of storage solution that will minimize the occurrence of losing a disk.
Look at running backups in parallel, and practice recoveries in p
I/Watch is nice.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
proactively monitor everything, max extents, datafile percent free, all of
it, its always easier to fix something when you have days/weeks of advance
notice, versus 2AM.
joe
>>> [EMAIL PROTECTED] 08/27/01 04:21PM
>>>Hi Gurus,I have number of Oracle8i
instances on HP-Ux in a 400 servers D
I couldnt get it to work for anyone other than someone in the dba group
already on linux. if you're in the dba group you can connect / as sysdba
anyways, so i guess i'm missing where the security hole is.
joe
>>> [EMAIL PROTECTED] 08/23/01 04:41PM
>>>Okay have a look at bug 1919536, it all
Hi Gurus,
I have number of Oracle8i instances on HP-Ux in a 400 servers Data center!!
I want valuble suggestions from Gurus and who maintaining their real Data
ceners.. I appreciate your help.
Thanks in advance
Raghu.
_
Get
It looks like you have a partitioned table with
a parallel or parallel index definition.
The :Qyyy are the 'table queues' used
by parallel query slaves to pass messages
between the layers of slaves operating the
query.
The SQL with the hints in it is the SQL
generated by the query co-ordi
Thanks for the offer of help. Developer finally did a
DBMS__OUTPUT.DISABLE
followed by the DBMS_OUTPUT.ENABLE. This cleared the buffer and code
worked. Apparently he had a dirty buffer that didn't clear until the
DISABLE was issued. He has added the DISABLE to his code prior to the
Anything over 2oom, is almost impossible to download from technet without
using a download manager, what happens is during the transfer it aborts and
restarts. Which fouls it up some how, once I started using get right to
downnload the stuff, it worked everytime, not to mention faster.
"Do not c
No replies needed!!
This is way too ironically funny
> > > >
> > > >
> > > >
> > > >Sometimes ... when you cry ... no one sees your tears ...
> > > >
> > > >
> > > >Sometimes...when you are worriedno one sees your pain...
> > > >
> > > >
> > > >Sometimes ... when you are happy ... no one
Title: RE: Oracle Licensing for a Clustered Server Configuration
Our failover server neither has a standby database nor oracle binaries.
In our Clustered server configuration, when a fail over happens
the entire diskgroups will be de-ported from the primary and imported on the failover serv
Title: Oracle Licensing for a Clustered Server Configuration
John, are/were you in a similiar
env..
..very curious..coz Oracle is forcing us
to buy a second license for the passive fail-over server ..
Thanks
-Original Message-From: Shaw, John B
[mailto:[EMAIL PROTECTED]]Sent:
I ran it at home for a couple of years (OS/2 2.0, 2.1 and 3.0 "warp"), I
finally gave up on it because IBM never got permission to support Windows95
applications in a shell.
It worked very well, though - never crashed. DOS and Windows sessions
crashed, but the OS never failed. And it was so con
I am running tkprof and explain plan on the following SQL statement:
SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
STATUS = '2' AND
CNFR_NO >0 AND
(SPL
One friend of mine working for Siemens is still programming DOS stuff 'cause
they use MSDOS as OS for chip testing machines (life test for car chips to
use in VW, BMW ...).
Jan Pruner
Dne po 27. srpen 2001 20:28 jste napsal(a):
> I don't know.
>
> I went to the cinema last week (? A couple of
Title: ach_tran query
Hi Cherie,
Looks like parallel query kicked in. It usually throws some odd looking stuff in the explain plan.
HTH
Lisa
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 3:11 PM
To: Multiple recipients
do a file on them in linux and see that the magic number comes back to show
you what it thinks it is.
joe
>>> [EMAIL PROTECTED] 08/27/01 02:53PM
>>>Well, they end with .gz, and the instructions under the files
specify to usegunzip to unzip them. Oh why, oh why does life
have to be so diff
Title: Oracle Licensing for a Clustered Server Configuration
Only
if it's active on the fail over node - if it's passive you don't need a second
license.
-Original Message-From: Srinagesh Battula
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07
PMTo: Multiple recip
oh i definitely didnt include all of the problems associated with
distributed enforcement of FK. I was denoting the obvious :)
joe
>>> [EMAIL PROTECTED] 08/27/01 02:22PM
>>>There is also the drawback that thetrigger has to do a
'select for update',with all associated contention problems,ot
We often used the FILLER to make the data more presentable in files. i.e.
used filler between columns. W
We also defined our output on reports the same way.
-Original Message-
Sent: Monday, August 27, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
Lisa,
Thanks for waking up
You
can do something like this:
CREATE OR REPLACE
TRIGGER your_triggerAFTER UPDATE OF ename ON Emp_Tab
FOR EACH ROWBEGINNULL; --do whatever you have to do...call
procedure, etc...
END;
HTH
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Saturday, August 2
Title: RE: ORA-10027 in ps/sql block
Rodd, can you post the code?
-Original Message-
From: Holman, Rodney [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-10027 in ps/sql block
I have a developer h
Well, they end with .gz, and the instructions under the files specify to use
gunzip to unzip them.
Oh why, oh why does life have to be so difficult...
-Original Message-
Sent: Monday, August 27, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
I think it's simpler than that --
Odd thing is that linux/solaris files come down correctly. And I've
down-loaded other zips for NT in the past with no problems.
This seems like a recent problem.
-Original Message-
Sent: Monday, August 27, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
If you do not use a dow
I think it's simpler than that -- I don't think they really need to be
unzipped.
>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i Linux files are erroring during uncompress...
>Date: Mon,
Bunyamin,
Let's
call the database that already exists the SourceDb, and the new one you want to
create the TargetDB
Do the
following:
On the TargetDB machiine,
create the same directory
structure that exists on the SourceDB
machine. This should include the directories where the databas
There is also the drawback that the
trigger has to do a 'select for update',
with all associated contention problems,
otherwise the effect of read-consistency
would allow a trigger to determine that a
parent existed when in fact it had been
deleted by an uncommitted transaction.
Jonathan Lewis
H
I don't know.
I went to the cinema last week (? A couple of weeks ago?) and one of the
ticket machines had a C:\ prompt on its screen.
Presumably that thing was running DOS...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Weav
The opposite end of a 'foreign key' has to be
a 'unique key' or 'primary key'. You have only
two 'nominally correct' options -
a) declare a unique key on table1.col1
or
b) Create a table where the unique values
of table1.col1 are held, and declare a
primary key on it - th
windoze shouldnt be the problem(did i really say that), i used that at
work to do the downloads copies them to RH machine(binary ftp), and installed
with no problem.
joe
>>> [EMAIL PROTECTED] 08/27/01 01:35PM
>>>Using Windoze, I downloaded the three Oracle 9i Linux files
fromtechnet.or
You can only FK to field(s) that are unique or primary key
constraints.
if col1 is unique, you can put a unique constraint on it and then FK to it
from the child.
your only other choice is to do FK checkign via triggers(i did it for
distributed databases, where parents were on one db and
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
>From a pure performance direction,
pls_integer or binary_integer is probably
the fastest.
If you declare a variable to be of
table_name.column_name%type
there are implicit constraints on the
variable and any pl/sql assignments
(in particular arithmetic operations)
have to check that the res
If you do not use a download manager like getright, you will almost always
download broken files.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-574
Title: Oracle Licensing for a Clustered Server Configuration
Hi,
Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a
2-node cluster server environment?
Thanks
Nagesh
I had a similar problem getting 817nt from OTN.
I had to download the file to linux - run gunzip.
then I tar'd it up again and copy to NT - where I used a DOS tar program
to un-tar it. Sheeze! Very painful.
-Original Message-
Sent: Monday, August 27, 2001 10:36 AM
To: Multiple recipients
That won't work, your primary key is 3 cols, so the foreign key must
reference those same three cols.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322
Lisa,
Thanks for waking up memories of COBOL that I have been trying to run away
from! Anyway a FILLER is just that - a filler or placeholder to pad out
or format a 'record' in the WORKING STORAGE or FILE section (eq. to the
declarative section in PL/SQL). If this is part of a retrieved reco
Isn't OS/2 still used extensively by banks to run ATM's? If that's the case,
then IBM would have a vested interest in keeping DB2 current on OS/2.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Monday, August 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
I can't
I can't believe it, they have a beta DB2 v.7.1. for OS/2, same release
number as for AIX.
I thought that OS was dead!
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informa
Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com. I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files. I switched back to Windoze and using
Winzip it doesnt like the files either. So I redownloaded just the smaller
third f
I think a direct variable declaration (without constraints like not null) is
the fastest. Of course if you are dealing with integers, use pls_integer
instead of number, it is faster.
Because for typecasting, I think it has to (somehow) access the dictionary
to get the column or table information.
Thanks I didn't knew ... and I am not a big fan of PC games anyway, so I
only read about music CD copyright related stuff.
..hmmm I have to catch up on my reading
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
Find a riper (burner) that does a binary rip and they will work.
At 07:46 AM 8/27/2001 -0800, you wrote:
>Some games, especially microsoft games have some sort of code or something
>on them that prevents burned cd's from operating correctly. I know that
>it's definatley on Age of Empires. Howe
Rather than think of them as a table, think of each
copybook mapping a record in a file (which is what
cobol is basically designed to do)...
The numeric levels are a hierarchical way of grouping
the levels... For example:
10 date-created
20 year-created pic 99
20 month-created
If all they did was take out J++, and we can still install the JDK and JRE
on WindowxXP, that might actually be an improvement.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Sinha, Shashank (MED, TCS) [SMTP:[EMAIL PROTECTED]]
1 - 100 of 151 matches
Mail list logo
