for downgrading from oracle 8 to 7, u need to take
complete export and import the file in oracle 7 by running the catexp7.sql
utility.
look for more help on this utility.
- Original Message -
From:
Djordje Jankovic
To: Multiple recipients of list ORACLE-L
Sent: Thursda
Hallo you DBA's:
Can someone give me an example on how to write the code to trap errors where the
field is too large to fit in the size of the PL/SQL
variable?
I also want the errors to be logged in a table. Please give me a good example on
PL/SQL code and also includ ethe insert statement
Title: OOT - Invitation to subscribe indonesia mailing list - [ORAID!]
Dear all,
I invite you all to subscibe [ORAID!] mailing list. This mailing list is for Indonesian speaking people to share information, tips & trick, technology, knowledge, job vacancy and many more that related with Oracle
Hi Pablo,
Your shared pool is too big, not too small, and you are parsing too frequently
(probably some literal SQL). Your use of synonyms is an exacerbating factor.
Your reloads are due to the invalidations. They do not indicate that your shared
pool is too small.
Of course, you should worry ab
Title: unhandled user-defined exception
You do a DMBS-OUTPUT the SQLMM , SQLCODE to check
on what might be the coz of error...in you PL/SQL.
-Original Message-From: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May
17, 2001 7:25 PMTo: Multiple recipi
Steve,
The only files that can be sparse are tempfiles with
8i+ See note 6224.1 "ALERT: Sparse Files and Oracle"
(don't be fooled by the Oracle6 in the note, it
includes 8i info as well).
HTH,
-- Anita
--- Steve Adams <[EMAIL PROTECTED]> wrote:
> Hi Johnson,
>
> I don't believe that tempfile
Title: User-define Aggregate Function
Dear Gurus,
Can I build user define aggregate function, like Sum,count,etc..
TIA,
Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
Indonesia
phone : +62 (31) 8708456 ext.113
Hei
I'm planning to know some brieft and detail on Data Warehouse and Data
Mart , but I don't know where to start from ? Any site /doc which I can get
the head start from there ??
-Original Message-
Sent: Friday, May 18, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Listers
Doh! I knew there was something else I was forgetting
(shows you how many times I've used it). Thanks Paul
and Rachel and Jared!
-- Anita
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> to carry this forward (hey Paul and Anita!)
>
> you can also look at:
>
>
http://www.cybcon.com/~jkstil
Steve,
Do you recall doing this about 5 years ago?
I recall doing this same procedure there, but without
benefit of standby database.
Total downtime was less than 2 hours, and we did
it during a slow period. ( probably Saturday night :(
Jared
On Thursday 17 May 2001 13:48, Steve McClure wr
Listers,
I asked about this question a while back (9iAS 1.0.2 / Forms 6i Patch 2 /
Apache / connect mode = http / HP-UX 11.0). I thought I would give an update
since a few people showed interested in the subject.
They were seeing the Forms server crash numerous times a day in a test
environment.
On Thu, 17 May 2001, Gene Sais wrote:
> Only in America, can you rant! Try to criticize China while living
there. I have a friend there, her mail is read before she gets it.
All she can write is general stuff, nothing negative, fearful of her
life. The best thing about America is that you can
Statistically, handguns bought for protection are more likely to be used
against a family member (intentionally or otherwise) than against any
"criminal element".
At 04:05 PM 5/17/01 -0800, you wrote:
>reality check.
>
>Consider the poignant implications of the recent anniversary of the
>Oklah
I think that the failure will not be caused by Oracle but by the quick-io
driver itself since it has to have full access to all the physical allocated
blocks and also it depends on how Veritas will communicate back its failure
to Oracle.
Getting rid of the sparse space may be a good idea!
Regard
Hi All,
Another correction. That error number has been changed to 7248 since Oracle8. I
think I need a coffee!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 10:01
To: Multiple recipients of lis
Just as a coin has two side, every thing has two sides - I'd say - good and
bad.
What you are is determined by your behaviour
Your behaviour is determinied by your surroundings - be it parents ,
friends or foes.
Similarly, what a nation is determined by its ruler and its neighbours.
So, It larg
Hi All,
OK, you're all correct. Tempfiles can be sparse (it seems to be platform
specific). Nevertheless, I'm unclear why Veritas think that is it any more of a
problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file than
otherwise. Presumably Oracle would just raise ORA-7376
Listers,
I might end up on a Data Warehouse and Data Mart project using 8i. I've read
various white papers, Oracle doc's, etc on partitioning capabilities of
8/8i. And I've dinked around on my test machine a bit trying things out. Are
there any books out there that you would recommend for digging
After creating the temp file and shutting down the database, you can use on
Solaris cp temp-file new-file and then
cp new-file temp-file.
After that you can convert it to quick-i/o.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 17, 2001 8:06 PM
To: Multiple recipients of list
Luis,
Don't feel bad, this is a valid question.
DROP USER CASCADE is not always the most efficient way to
drop a user, especially a user with a large number of objects.
I've had that command fail a number of times, and had to rerun
it until I decided there must be a better way.
DROP USER CAS
reality check.
Consider the poignant implications of the recent anniversary of the
Oklahoma city terrorism.
The simple fact is that a very high percentage of professional women
that have jobs like real estate sales requiring isolated contact with
strangers *are* armed (as you state, many with
I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.
Here is the proof:
$ ls -l temp01.dbf
-rw-rw-r-- 1 oracle dba 209719296 May 17 18:55 temp01.dbf
$ du -k temp01.dbf
40968 temp01.dbf
$ ls -l users01.dbf
-rw-rw
Hi,
A user has just installed Oracle Clien 8.0.5 on NT 4 machine. She then went to
configure a system DSN in ODBC. She ckicked Od button, highlighted the Oracle ODB
8.0.5 driver and clicked Finish, but then the ODBC 8 Driver setup did not
appear. Anyone experienced this problem? and if so, how
Brian,
Clearly the USA is not perfect, or the end point of social evolution
on this planet (or others). The USA is the outcome of one set of
highly successful (anglo-american) experiments/innovations with
"freedom" and "commerce". American individualism is not particulary
compatible with the oth
If you create tablespace like - create temporary tablespace
...
created file will be sparse.
Alex Hillman
-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L
Hi Johnson,
I don't believe that tempfiles can be sparse (although I may be wro
He works with rule based optimizer (cost= in explain plan). Maybe using
choose ad not analyzing. So it does not matter how values distributed -
if index exist rule based optimizer will use it.
Alex Hillman
-Original Message-
Sent: Wednesday, May 16, 2001 6:16 PM
To: Multiple recipie
Isn't Canada a state in the north of the USA?
|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 6:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: job offer from SAUDI ARABIA
||
||
|| Um, I can critize Canada all
I stand corrected. Obviously there are other countries that don't dismember you for
speaking out.
>>> [EMAIL PROTECTED] 05/17/01 06:10PM >>>
Um, I can critize Canada all I want. Matter of fact, its kind
of a requirement. So your first sentence is wrong. I asked one
of the guys I work with h
Hi Johnson,
I don't believe that tempfiles can be sparse (although I may be wrong) and I am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles until
then. Anyway, can you please post the URL to the t
I have a small datawarehouse that I would like to re-design and re-build.
All the scripts are in place to recreate the
snapshots, tables and associated indexes. But before I delete the existing
one, and create the new one, I need to
retrieve all the users and their associated grants and roles.
Hi Diego,
I don't know of any way in which using DBMS_PIPE might be related to CI enqueue
waits. However, even if there is something to their suggestion, if your ID
values are 0 and 5 then the CI call you are waiting for is one of the reuse
block range calls.
@ Regards,
@ Steve Adams
@ htt
Matter of fact, I believe that they are the biggest users
of Trusted Oracle. A product I was forced to deal with when
on a Nato project. I think I contradicted myself in my first
sentence but oh well...
-Original Message-
Sent: Thursday, May 17, 2001 2:16 PM
To: Multiple recipients of l
Um, I can critize Canada all I want. Matter of fact, its kind
of a requirement. So your first sentence is wrong. I asked one
of the guys I work with here if he drinks a lot when he goes out
and he said "Well, not for a Canadian". He is Canadian. (As am I)
-Original Message-
Sent: Th
Hi Riyaj,
Thanks for your response. Very interesting! I
completely agree with you about index fast full scan.
But I'm still unclear about index full scan.
I've always thought that this operation is serviced with
1-block reads. So it would be possible
to go through 2-way list of leaf blocks
Praful,
This is a bit of a shot from the hip, but.
the gap shouldn't make much of a difference in
the end.
I'd be more concerned about allocating space for
all your stuff initially, not just the first 10%.
The gaps should be handled seamlessly by indexes
(the way a b*tree works...) and any
E-Business is the new term for Oracle Applications, and yes, 11i has been
out awhile, running against an 8i database.
It's a full time job just keeping up with Oracle's naming convention!
Linda
-Original Message-
Sent: Thursday, May 17, 2001 2:56 PM
To: Multiple recipients of list ORA
Hi,
We are planning to do two-phase data migration - split by data.
In first phase, about 10% of the data will be moved as is -
without changing the primary keys (generated from sequences).
Once we start using the database with phase 1 data, sequences
will generate new primary keys and add to thi
Gene,
Being part of a nation with people (such as yourself)
who have a willingness to let other's have their opinions
-- some of who are a part of the military force that
defends that right -- is why all my tickets out of town
are always marked "round trip".
Above all, thanks for your servic
I think it is Oracle Applications ver 11i and not an Oracle server release.
-Original Message-
Sent: Thursday, May 17, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L
>From InformationWeek:
** Oracle Hooks NATO On 11i
The North Atlantic Treaty Organization has begun implementing
Actually NATO has been using Oracle's RDBMS product for years.
>> Original Message <<
On 5/17/01, 4:01:34 PM, Ron Rogers <[EMAIL PROTECTED]> wrote regarding
Re: Another big bang for Larry:
> It's started. After slick willy was invited to speak the kickbacks
Title: RE: job offer from SAUDI ARABIA
SET MODE SILLY ON
Damn, I *knew* I forgot to buy something on my last shopping trip to Nordstroms!
Note to self: - buy gun I didn't know I needed. Remember to purchase
extras for friends who don't have them either(the gift that
I could see a reason to encrypt the data so that "even a DBA can not see
it". Our company has formulas and mixtures that are kept extremely
confidential. Very few people need to know, very few people do know. In
addition, those "in the know" have determined that we need a central
repository for
Well...technically it's not out yet. Like alot
of list member's, I got my copies about a month
ago in the mail, and the general availability (GA)
date is June 10th ( I think..I could be confusing
that with IBM's next release ).
I wouldn't feel silly. A bunch of us around here
in this shop are
Not sorry if I touched a nerve, Rocky.
That's what it's all about. It's democracy,
suck it up, or spit it out.
|| -Original Message-
|| From: Rocky Welch [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 4:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT:
Only in America, can you rant! Try to criticize China while living there. I have a
friend there, her mail is read before she gets it. All she can write is general
stuff, nothing negative, fearful of her life. The best thing about America is that
you can b*tch if you want. I served for this
Don't I feel silly! I didn't even know that 9i was out yet, much less 10i
or 11i! I guess I don't dare blink.
DM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L
>From InformationWeek:
** Oracle Hooks NATO On 11i
The
It's started. After slick willy was invited to speak the kickbacks are showing up.
Oracle will be running the Government. Slick move... you don't dare bust up the
monopoly that is running the Governmential department's programs. Will the NEW
controling body be called "the GOVERACLEMENT"?
WOW!! I need to pay more attantion, what the hay is going on here?
-Original Message-
Sent: Thursday, May 17, 2001 4:14 PM
To: Multiple recipients of list ORACLE-L
ep,
Any idiot can see we're the freest country in the world!
Free to do what is expected, or get thrown in jail at a
Koivu, Lisa said
"A word of warning, and you probably already know this: you can't have both
databases open at the same time or you will end up with incompatible archive
logs and control files. Good luck !"
hehe I did know, but upon reading your warning it still frightened me for a
moment. Be
Brian of MacLean,
I guess that's a good way of putting it, too. Sometimes I like to rant about
( i.e. "for" ) Amerikkka, but that's usually when she's under attack, in a
way that is
perceived by me as being unfair or
misinformed.
- Ross
-Original Message-
Sent: Thursday, May 17, 2
And freedom to leave the country any time you wish. Have a nice flight.
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
>
>
> ep,
>
> Any idiot can see we're the freest country in the world!
> Free to do what is expected, or get thrown in jail at a
> rate exceeding most other "civilized" natio
Hi guys!
Since the upgrade of my Oracle server to the version 8.1.6 (I applied all
the patches) and the rebuild of the clients applications with the libraries
from the same version, the column PROGRAM of the view v_$session is empty.
If the application is using the old libs, the program apears in
uhhh DUHHH !
I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
BRAIN ..
Thank you to all of you, and special thanks for not bashing me
Luis Octavio
Luis DeUrioste wrote:
> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema script that would
GROAN
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 10:50:39 -0800
>
>Mr. Rhet Device
>(rhet oracle device, that is)
>
ep,
Any idiot can see we're the freest country in the world!
Free to do what is expected, or get thrown in jail at a
rate exceeding most other "civilized" nations. Free to
subsidize tobacco and alcohol (and related deaths) and
throw "dangerous criminals" in jail for using cannabis.
Free t
>From InformationWeek:
** Oracle Hooks NATO On 11i
The North Atlantic Treaty Organization has begun implementing
Oracle's 11i E-business software in its 19 regional headquarters.
NATO program director David Oakley says NATO's new Automated
Financial System will incorporate Oracle's enterpris
Title: RE: job offer from SAUDI ARABIA
God I live in an awful country. I'm sorry for all the tyranny my country has put the world through. I guess I'll just shoot myself.
Seriously. I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he
Or...may be
select 'drop user '||username||' cascade;'
from dba_users
where username not in ('SYS','SYSTEM'); --and perhaps some other user you'd
like to conserve
...and then run the spool.
hope it helps
DC
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED
This Client in the Cleveland Ohio area, is dedicated to creating a work
environment
enabling ALL employees to contribute and to grow into their fullest potential.
They have a full-time staff opportunity available for an Oracle DBA.
This is a full time staff position so no sub-contractors or thi
As usual, "thanks" for the answer Steve.
I'll try to reduce the number of shrinks in the rollback segments, so this
is going to impact on CI enqueue waits.
What do you think about Metalink DOC ID 1020355.102 recomendation?
(from my previous email)
"> I've also read a metalink document (1020355.
Login in as system:
drop user user_name cascade;
-Original Message-
Sent: Thursday, May 17, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciat
Hi Julia,
"Can I have two different ports for two
database in the same **tnsname.ora** on the same server?"
I think you are referring to the file listener.ora, and you want to
configure 2 "listeners" in the same box.
If that's the question the answer is "yes".
hope it helps
- Original Me
Title: RE: Moving a database to a different machine
Hi Steve,
I used this same strategy with a migration last month. It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours. Oh well)
This plan will work. O
How about:
drop user cascade;
--- Luis DeUrioste <[EMAIL PROTECTED]> wrote:
> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema script that would be willing to share
> ??
> It'll be greatly appreciated
>
> T I A
>
> > begin:vcard
> n:de Urioste;Luis Octavio
> tel;
It takes a lot of digging for multiple versions, but on Metalink,
under "product life cycle" there is a certification facility with
various levels of "drill-down".
regards,
ep
--
Certify - Certification Matrix: Oracle Forms 6i on
Re the 'scattered read' for full index scan.
This term is counter intuitive at first glance, and is commonly
seen on full table scans. It makes sense that it would show up
on full index scans as well.
Here's an explanation of 'scattered read' found at
http://fncduh.fnal.gov/supportdb/working/l
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated
T I A
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
emai
The key must be on 8 byte boundaries.
See my article on encryption at www.cybcon.com/~jkstill/util
Jared
On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
> I'm using Oracle 8.1.7.
> there was an error
> ERROR at line 1:
> ORA-28232: invalid input length for obfuscation toolkit
Many professional women in the USA have found it necessary to
purchase handguns to protect themselves from criminal elements in
public places. Children are constantly under psychological assault
being exposed to media violence. The "liberal" education system is
devoted to indoctrinating childr
oops!
My previous post said that the key must be on 8 byte boundaries.
That is incorrect. I believe the data must be on 8 byte boundaries.
Guess I should re-read my own article.
Jared
On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
> I'm using Oracle 8.1.7.
> there was an
Hi seema,
you can do:
echo '' > listener.log
On Thu, 17 May 2001, Seema Singh wrote:
> Gurus
> I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on
> solaris 8.Plese suggest.As I understand
> go to listener.log file directory
> copy listener.log listener.old
> tail -10 >
I think this will work fine. You could play with doing it with a standby
database, the only advantage to that is that you could start the backup and
move of files earlier in the process and just keep recovering the archived
logs as you ship them across.
This has the advantage of giving you tim
Sounds like a job for Perl.
Here's an example of cleaning up this data before you
send it to the database.
Really, this is much easier than doing it with PL/SQL or Java.
Jared
--
#!/usr/bin/perl
our %hashData;
while() {
my($key, @data) = s
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:
> Who was the half person?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Deal! :)
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 09:31:33 -0800
>
>How about we split the difference?
>
>| 1* se
I logged a TAR with Oracle, and their Metalink technician replied that...
all the current versions are certified to work together.
I knew that.
What I want to know is, which versions of OAS , OEM or Developer were
designed on concert with which version of the RDBMS.
E.g. as part of the server t
Are you an idiot?
( oh god, I can't believe I said that. might as well finish it )
ALL YOUR BASE ARE BELONG TO US
;^{)
On Thursday 17 May 2001 11:07, Mohan, Ross wrote:
> HELP
>
> || -Original Message-
> || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 17,
Gurus
I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on
solaris 8.Plese suggest.As I understand
go to listener.log file directory
copy listener.log listener.old
tail -10 >listener.log
Thanks in advance.
-seema
___
Allright,
We are physically moving our office, and have an OLTP application that needs
to be up and running with minimal downtime. The current plan is to use the
development computer as the production platform while the Primary computer
is physically moved to the new location. The development sy
Are you an idiot? :-)
Alex Hillman
-Original Message-
Sent: Thursday, May 17, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L
HELP
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple rec
Hi Ed
I think, For full index scan, oracle server process reads the root block and branch blocks 1 block at a time. It reads the leaf blocks at a db file multiblock -read count blocks per read call. For the fast full scan, it reads all the block from the segment header to high water mark
Yes you can encrypt the data, or you could invest in Trusted Oracle. But the
question really becomes one of what are you trying to do. If the problem is
that you question the integrity of the DBA that becomes a management problem.
On the other hand, if you don't question his/her integrity then
Thanks for the TX information Jeffery.
But my question about CI enqueue still remains.
Here's the query to get enqueue waits statistics, it's from Steve Adams'
site.
select
q.ksqsttyp type,
q.ksqstget gets,
q.ksqstwat waits
from
sys.x_$ksqst q
where
q.ksqstget > 0
/
thanks again
We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I am trying
to figure out which OAS/iAS, Forms / Reports and RDBMS versions go together
best.
This is my list so far (RDBMS --> Developer/Forms/Reports --> OWS/OAS/iAS
--> OEM):
Oracle 7.3.3. --> Developer 1.6.1 --> n/a --> n/a
Ora
HELP
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
||
||
|| How about we split the difference?
||
||
Does anybody know if a gateway exists between the Oracle database and
Progress database?
Thanks.
Sam Bootsma
Technical Support Analyst
CPAS Systems Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Bootsma
INET: [EMAIL PROTECTED]
Fat City Network Services
A.,
Just out of curiosity, is your paper pertinent to NT/Win2K? Is the
replication done strictly within Oracle?
what about stuff like this?:
http://www.nsisw.com/main/pages/products.html
regarding your private question about rifts in space/time continuums,
the world is probably safe for
Export/Import
this was actually mentioned in chapter 3 in the Oracle8i Migration Release
(A76957-01)
>Hello:
>
>Please help me on this crisis! What is the steps and safe procedures to
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon
today.
>
> I have database 8.1
I have a data file that looks like this;
100Memo line 1 information.
100more information for record 100.
100extra information again.
200Memo for 200.
200more info for 200
300info for 300
300next memo
300and more
300yet more again.
I want to load to a table (co
You haven't been a DBA too long have you?
... if you manage the db, you are responsible. period.
at least that's the way it's been everywhere for me, but I could be wrong...
-Original Message-
Sent: Wednesday, May 16, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
One advantag
How about we split the difference?
| 1* select (25.25+27.5)/2 from dual
|SQL> /
|
|(25.25+27.5)/2
|--
|26.375
|
(no this is not the mean)
On 16 May 2001, at 19:36, Rachel Carmichael wrote:
> now now, don't exaggerate it was only 25 & 1/4 people
...
> >didn't 27 & 1/
Hoo boy...I guess the safest approach is to run the catalog script against the 8.1.6
database that changes the export views to be 8.0.6 compatible, then do a full export
and import.
>>> [EMAIL PROTECTED] 05/17/01 12:15PM >>>
Hello DBAs:
Please help me on this crisis! What is the steps and s
The
safest way is to do a full database export, to create a new 8.0.6 database
instance and to import the data in the new database. You have to see
for inter-version specifics - you might need to use 8.1.5 import version to
import in the 8.0.6 database - you have to check that, but it is fo
The trigger code would probably help...
--- "Venugopal, R (GEP, Contractor)"
<[EMAIL PROTECTED]> wrote: > Hi Gurus
>
>I am getting the error attached below when
> trigger fires. what could be
> the reasons
> for this error.
>
> DB error: ORA-06510: PL/SQL: unhandled user-defined
> exc
Who was the half person?
-Original Message-
Sent: Wednesday, May 16, 2001 9:37 PM
To: Multiple recipients of list ORACLE-L
now now, don't exaggerate it was only 25 & 1/4 people
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of
That was it.
Thanks!
-Original Message-
Sent: Thursday, May 17, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
# Global Naming -- enforce that a dblink has same name as the db it connects
to
global_names = true
Your problem is this.
make it to false or obey the rules.
The upgrade doco also has the downgrade steps. Check your documentation.
-Original Message-
Sent: Thursday, May 17, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Hoo boy...I guess the safest approach is to run the catalog script against
the 8.1.6 database that changes the exp
Hello DBAs:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then
Hello Gurus,
I need help in this performance issue.
Oracle 7.3.4
HPUX 10.20
I 've got this ratios:
BC hit ratio 98
dictionary cache hit rate 100
library cache get hit ratio91
library cache pin hit ratio98
Mayor waits
Hello:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then I
1 - 100 of 141 matches
Mail list logo
