The last time I tried it ran fine on 2.8
Cheers
--
=
Peter McLartyE-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402
Hi,
Tables Analyzed recently?
Indexes analyzed recently?
Histograms possibly?
If all else fails hints are there to force a certain execution anyway
(Oracle must have known that the CBO wasn't/isn't perfect) so just use
them.
Jack
C.S.Venkata Subramanian [EMAIL PROTECTED]@fatcity.com on
Cyril Thankappan wrote:
U r right ..I still dunno 'much' about perl..
as for dbms_metadata
it is a built in pl/sql package
saying
'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;
gives the entire ddl creation script.
However, 'interestingly'
Hi,
I have downloaded it to my office PC and it works fine. So I do not
think the problem is with the installable
coz I am a
NoviceDBA
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 02, 2002 6:20 PM
I think that it depends on type of database link you created.
CONNECTED_USER versus CURRENT_USER.
Imagine two users - user A in database A and user B in database B.
User B wants to connect to database A using link and do something...
Now: If the database link is of type CONNECTED_USER then user
I have analysed the schema using dbms_utility
--
On Thu, 03 Jan 2002 23:25:18
nlzanen1 wrote:
Hi,
Tables Analyzed recently?
Indexes analyzed recently?
Histograms possibly?
If all else fails hints are there to force a certain execution anyway
(Oracle must have known that the CBO
I had to use hints inside views number of times and it worked well
but you have to be careful. Hinting just the SQL statement that
builds the view may be worse than no hinting at all.
When you add hints you have to keep in mind how you will use the
view. In result I ended up with few views,
If you purchase a Dell PC they will upgrade it to XP Prof. at no extra cost.
At least they did it for me.
Ken
-Original Message-
Sent: Thursday, January 03, 2002 8:05 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: XP Professional 9i (YES IT IS A CERTIFIED COMBO
Hi
What is the query?
What is the explain plan w/o hints?
what is th eexplain plan with hints?
Is it doing hash joins w/o hints (Full table scans) and nested loops with
hints?
Jack
C.S.Venkata Subramanian [EMAIL PROTECTED]@fatcity.com on 04-01-2002
12:35:19
Please respond to [EMAIL
Title: Export via pipe ksh script
Thanks everyone. Much appreciated.
-Original Message-From: Barb Baker
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 03, 2002 9:35
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Export via pipe ksh script
Here's one:
#!/bin/ksh # #
are all your tables/indexes analyzed? if the statistics are not current then
the plans chosen by the CBO can be very bad.
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 12:40 AM
Dear All,
I have been entrusted to
Tony,
Pardon me, but what Unix are you working with? And are we confusing
global_name with db_name?
We run on HP-UX and if the db_name and/or SID are the same your skunked.
Different Oracle version or not. And that does not even include the listener.
Dick Goulet
Okay, I stillthink I like my own scripts to extract ddl better :)
--- Cyril Thankappan [EMAIL PROTECTED] wrote:
U r right ..I still dunno 'much' about perl..
as for dbms_metadata
it is a built in pl/sql package
saying
'select
Does anyone happen to know what this error code means?
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
How does one stop access to prod instance by any product other than supplied
homegrown Forms application?
I mean no sqlplus, toad, tora and similar tools and their renamed
derivatives?? All this needs to be done for all users incl developers except
DBAs.
Thanks in advance
Raj
See this document on Meta Link Doc ID: Note:69961.1
Don Bricker
Database Administrator / System Administrator
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290
[EMAIL PROTECTED] 01/03/02
Maria,
Witold has provided some good advice so no need to repeat any of that.
But, since you are asking about hints and views it is worth mentioning the
concept of GLOBAL hints. When you want to specify hints for tables that
appear *inside* views you can use GLOBAL hints. So, you might find
it can be a major error -- you can look up the argument codes on
Metalink but you should also call support.
in general, ora-600 errors mean trouble
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Does anyone happen to know what this error code means?
Ron Smith
--
Please see the official
One way to do it (kinda) is to ensure that all access to objects
is via roles. Don't use public. Make sure the only privilege granted
is connect or create session (don't remember which one grants
other privs with it off the top of my head). Assign that role to
the users but do not make it
There's a better way: use global hints in the queries that select from
the views. From Designing and Tuning for Performance:
Global Hints
Table hints (i.e., hints that specify a table) normally refer to tables
in the DELETE, SELECT, or UPDATE statement in which the hint occurs,
not to tables
For some reason the error message was dropped from the original message.
Here it is again.
ORA-00600: internal error code, arguments: [12333], [1], [128], [0], [], [],
[], []
Ron
-Original Message-
Sent: Friday, January 04, 2002 7:50 AM
To: Multiple recipients of list ORACLE-L
Does
Am I an Idiot?
I've maintained a Managed Standby database (8.1.6 under Win2k) for a year
now. We've now moved to new servers (8.1.7.2.5 under Win2k) and will again
have both Primary (Production) and Managed Standby databases.
In planning a new backup stragegy, it occurs to me (why not ever
[EMAIL PROTECTED] wrote:
Does anyone happen to know what this error code means?
Ron Smith
it means you should contact Oracle support with all the arguments and
hope for the best.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
Connect grants other privs. Create this, create that. Alter session.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
Package up your trace file and blast it off to Oracle Support, I did have a
peek and it appears that 600 errors followed by a [12333] generally mean a
failure in client/server communications.
HTH
Lee
-Original Message-
Sent: 04 January 2002 15:00
To: Multiple recipients of list
Raj,
Various methods. One I've used is that priv's are assigned to password
protected roles and the role(s) to the users. The role is *not* enabled and
all the users can do is create a session. Upon startup of the form, you can
enable the role. Look for the topic Setting and checking database
the product_user_profile view
you can set the access for userid, for program etc in there.
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
How does one stop access to prod instance by any product other than
supplied
homegrown Forms application?
I mean no sqlplus, toad, tora and similar
Hi Jack,
I don't think that you really want to use the online redo logs in this
scenario.
The problem is that the SCN at the exact time of failure may be
different on the Standby and therefore the Primary DB's Control File will
not be
correct for the given Datafiles being copied over from the
Ron,
From Matalinks ORA-00600 parser:
Bookmark
Default Font
Go to End
Doc
Raj,
The short answer is - you can't. Oracle, being as open as it is, is
available for anyone who has an account by any software that can call it
(even ms Excel!). There are just too many tools that use ODBC to try and
stop them all.
The long answer is to change your forms application so that
Well soon you'll have to make up a new term because Oracle is re-writing it
and renaming it to something like eSupport and TAR's will become SR's.
Supposedly Oracle is going to use their own CRM product for support. I asked
if we the end users will be able to rate the answers and the analysts
Raj,
You don't say what version, but in 8i you should be able to use a
database-level trigger at LOGON and the SYS_CONTEXT function to check the
client info. If you can't use SYS_CONTEXT, you can always query V$SESSION
matching USERENV('SESSIONID') to the AUDSID column to get the PROGRAM column
Yeah, Call Oracle Tech Support! Actually if you have acdess to Metalink you can
create the Itar on line and they even have an ORA-0600/7445 error parser.
Dick Goulet
Reply Separator
Author: Smith; Ron L. [EMAIL PROTECTED]
Date: 1/4/2002 5:50 AM
Here's a question I'm suddenly wondering about.
I'm upgrading my production database from 8.0.4.3 to 8.1.7.2 this weekend.
Now it's my understanding that the 8.1.7 upgrade must be done first, then
the patch installation (and rerunning catalog, etc.).
My intention for the standby database is to
Jamadagni, Rajendra wrote:
How does one stop access to prod instance by any product other than supplied
homegrown Forms application?
I mean no sqlplus, toad, tora and similar tools and their renamed
derivatives?? All this needs to be done for all users incl developers except
DBAs.
One quick and easy way is to lock all dev accounts in prod. Or change their
passwords, or as mentioned previously revoke their roles/privileges.
[EMAIL PROTECTED] 01/04/02 11:22 AM
Thanks Kimberly,
That is exactly my problem .
I'd like to investigate this to restrict developers as well
Title: RE: Moving Oracle software
Kurt,
If your copied ORACLE_HOME is different from the old one, You need to following modifications.
1) Update $ORACLE_HOME/rdbms/lib/nmliblist file as per the new ORACLE_HOME directory.
2) make -f ins_rdbms.mk install
Thanks,
Rama Ari
Database
This will only work for SQLPlus. Will not work for other programs. The ideal
thing will be setting a default role none to all users and enabling roles
thru the application .
Best Regards,
K Gopalakrishnan
(408) 934 9310
-Original Message-
Carmichael
Sent: Friday, January 04, 2002 7:55
Over the holidays, as is the wont of many a DBA, I was doing some work while the
databases were relatively quiet. One thing I did was to move a lob segment to another
tablespace. The lob segment contains employee pictures for our online phonebook.
After the move I looked at 50 of the
Thanks all ...
The problem doesn't end here ... the requirements (loosely specified) are as
follows
1. Developers and end users can access production ONLY through FORMS
APPLICATION.
2. End users can't get to sqlplus so I am not even worried about that. It is
developers that I am worried about.
The following eweek article might be of interest. If the link gets mangled,
the article is at http://www.eweek.com Following the Data to a DBA Job by
Jeff Moad.
http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
I would say it's a different way ;-)
It depends on the data, tables joined, and other things. It may look
and work great in typical emp-dept example: few departments, few
dozens employees. When you use GLOBAL hints you can overwrite
hints used inside the view but I don't think you can change
Title: RE: Crystal Report as an ad-hoc tool
if you are dead-set using crystal... I feel your pain. In a previous life (job) I was a report writer/integrator... we used a Delphi front end, and Crystal provided us a couple of nice utilities to get into the structure of the application and
Ok, I thought I had it but it is still not working.
Production user on Prod has dba privileges, has been granted insert on any table and
granted insert to all the archive user tables. He can see the view in Archive user in
Prod and can see the tables in Archive User in the Archive Database;
Nick,
thanks for your info. Actually, we may be set against
using crystal because of lack of some features. I was
thinking that may be these features are there, but we
have missed them. Looks like they are indeed not
there.
Also the feedback I had from others seems to be fairly
negative. So we
Lemme get this right.
This guy is a *new* DBA. He's making 150k and he's not
even a senior DBA, where he can make 200k?
That's all from me. I'm gonna go sulk now.
Jared
I can wholeheartedly sympathize.
Taking advantage of the slow work period, I patched an SAP database
from 8.0.4.0 to 8.0.4.4 and rendered SAP totally unusable.
This was not what I wanted at 1:30 a.m.
I left it til the morrow and finally tracked it down to the patch changing
the
NLS_LANG
Rich,
This will stop the casual user, but someone armed with a little knowledge
and a determination to get in will figure out that all they need to do is
change the name of the executable.
You can stop most people, but not someone really determined to get
into the database.
Jared
Very misleading article, which may paint the world in bright blue colors for
upcoming/wannabe DBAs...
Alternatively, a nice piece of fiction work to forward to a superior...;)
Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529
-Original
On Thu, 3 Jan 2002, [EMAIL PROTECTED] wrote:
Why do a large number of postings refer to MetaLink as MetaStink
(or fetidstink) ?
Oracle, a company that advertises its products as Unbreakable, runs
Metalink, a site that is plagued with problems of availability,
usability, reliability and
1) If you setup the roles as suggested, the developers can't do much damage with other
tools, except, perhaps, to create a killer query. But you can control this with
profiles.
2) Create roles that have only SELECT privileges. These roles can be default roles.
This will allow reporting via
Errr...what's the point in having a standby database then? If you have a
media failure then you fail over to your standby database, and your up.
Once the standby database comes up then you will have to rebuild the old
primary database from the old standby anyway, since you now have all these
new
Lately, it seems that the Unbreakable portions of Oracle9i have broken.
We have encountered numerous problems with Oracle's web site, both OTN and
any generic Oracle information. I did find out that Oracle upgraded to a
new version of the Portal Software, causing much of their content to either
Either he's full of crap, or they're paying him way too much unless he has
some other managerial responsibilities. The only way to make 200K is to be a
sought-after independent consultant (at $100 an hour or so). The going rate
in the Denver area is $40 - $60 an hour (sometimes up to $75, but
Can anyone provide some criteria of what you look for when a data model is
handed off from production? We are starting a large development project and
I lobbied management to hire a data architect. As they have talked to these
people, they are getting statements such as and then the DBA will
Where did I put that resume? Sounds like time to go prowling!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 1/4/2002 10:15 AM
Lemme get this right.
This guy is a *new* DBA. He's making 150k and he's not
even a senior DBA, where
I also read this article today morning. After reading this article I got so
much fed up with eweek news, I un-subscribed it from my mail system.
Rao
-Original Message-
Sent: Friday, January 04, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
Lemme get this right.
This guy is a
Or maybe this is one of the reasons the price of a Rx is so high. I know
Pharmacutical reps make quite a bit of money too.
Just a thought
Randy Kirkpatrick wrote:
Either he's full of crap, or they're paying him way too much unless he has
some other managerial responsibilities. The only way
I agree also, I've been working with Oracle since
version 4 and the rates here in austin,tx are anywhere
from $35/hr to $75/hr, and chances are pretty slim finding
an company willing to pay $75/hr for an senior person, and
usually its an 1099 job when it comes to $75/hr job.
dan whatley
Randy
Hi
I am getting following error when I opened onw website.
Database error: [NOTFOUND] Object `produser' not found in database Error num
: 15 VendorError1 : 0 VendorMessage1: VendorError2 : 0 VendorMessage2
What coud be reason and how to correct it?
Thanks
-Seema
Your manager is full of sh** (in technical terms). Poorly written queries
are usually the problem, more so than any data model. Let me guess, he's
the manager for the development team?
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become
Kathy,
Something is fundamentally wrong with the way things are setup
in that database, but it's not something easily troubleshot via email.
There are *many* ways to setup a distributed system. Some are rather
complex to setup, but make development easier. Others are more
secure, and even
Dennis,
First of all, I would tell your manager that 90% of tuning is in writing
good queries no matter what the data model looks like.
Unfortunately, you receiving a data model and expecting to perform miracles
is pretty naive of the organization. This is a classic example of how NOT
to do
Will there be any problem, if I install Oracle8.1.7 in this
machine having Solaris 2.8?
Thanks for help.
Hi,
we are using Solaris 2.8 + Oracle 8.1.7.0 SE
no problem
-Onder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: E.Onder Kokturk
INET:
I'm sorry ... but a little over $100K + $7K is way over what any
reasonable person would pay for a newbie DBA! I stand by my previous message
... this is full of crap unless he's doing more than DBA work! (Or the
company is EXTREMELY generous and I want on board!)
Randy
-Original
What a timely thread. I have been working on debugging a library cache lock
issue as well. I am running 8.1.7 on HP-UX. When analyzing 1 certain table
(estimate), I ALWAYS get a library cache lock. Then other sessions stack up
waiting on this analyze statement. The analyze of any other table
Dennis,
In addition to the points mentioned by Tom, I would also ask the following
questions:
* What tools/clients will be used to populate the data and extract it for
reporting? Depending on the tool, your 'performance' will vary... I wouldn't
want an MSAccess/ODBC type query running against a
Well since there's a skip readonly clause to the backup command I assume you
have to be explicit.
-Original Message-
Sent: Friday, January 04, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L
With RMAN Incremental backups will a Level 0 backup always backup ALL
tablespaces
Give Chapter 10 of the RMAN docs a browse, also the concepts chapter.
You must explicitly tell RMAN what to skip. A level 0 backs up everything.
Jared
Pat Howe
phowe@Illumin To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
John - Thanks for bringing up these critical issues:
1. Tools - This is our first Java adventure, so everyone is nervous. Please
point out any Java pitfalls that have bitten you.
2. Hot-spot tables - Good issue, will keep it in mind. We are just creating
the logical model today.
3. Storage and
You wouldn't believe it.I didn't have Resource role or DBA role for my #$%* User.
This user had DBA privs... so I don't know why/when it was changed.
Unbelievable I was trying everything.
A BIG thanks to Babu and Jared for offering alot of help.
Thanks also Michal for the
you'd have to grant the user at least create session or they won't even
get as far into the app to set the role
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
This will only work for SQLPlus. Will not work for other programs.
The ideal
thing will be setting a default role none to all users
the manager is wrong -- as a model will NOT tell you where additional
indexes could be helpful. While a look at the queries could.
What I've always done is sit with the architect and go over each entity
and see if it should be denormalized for performance (it's all well and
good to have a
Actually, its Metalblink and Uncle Larry. Please get it right.
;-P
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 03, 2002 8:50 PM
Why do a large number of postings refer to MetaLink as MetaStink (or
fetidstink) ?
The
You mean Oracle didn't do Quality Assurance Testing before they
upgraded? :)
--- Karniotis, Stephen [EMAIL PROTECTED] wrote:
Lately, it seems that the Unbreakable portions of Oracle9i have
broken.
We have encountered numerous problems with Oracle's web site, both
OTN and
any generic Oracle
You're getting lots of good replies to this Dennis.
One thing I wanted to mention that I had seen yet:
A data architect is going to give you a data model.
This does not necessarily resemble the logical data model
or the database design.
When handed a model to implement as a database, there
It's always the little things that bite you, cuz you don't expect them. :)
Glad it works now.
Jared
Kathy Duret
Will it not also work for exp/imp and SQL*Loader? I have not done to
much investigation into it but I was under the impression that all
Oracle products could be restricted, just not third party tools.
-Original Message-
Gopalakrishnan
Sent: Friday, January 04, 2002 8:26 AM
To: Multiple
The only Java pitfall I have seen is making sure that developers
close their statements after they are done with them. Other then
that I have seen no issues (related to Oracle that is).
-Original Message-
WILLIAMS
Sent: Friday, January 04, 2002 3:30 PM
To: Multiple recipients of list
Don't count on your end users not getting access to SQL*Plus. Now
that you have made the statement someone is surely installing it.
Granted users can have the ability to install on their PC's locked out
but someone probably found a reason to have it returned to them and...
-Original
Well, I would fire your manager for starts. You most definitely need
to see the SQL. Having the most excellent design in no way stops developers
from being stupid.
However, that being said, you should review the design. You are the one
that has to live with it. Number one, make sure they are
you reminded me of another few:
make sure that number columns/primary keys are really numeric (I have a
3rd party design that doesn't)
make sure that char columns really need to BE char columns. This can
cause you problems way down the line
on the other hand, don't indiscriminately create
make sure they use Java prepared statements, especially if they are
using lots of literals.
mine didn't -- I had to turn cursor_sharing=force on to solve shared
pool problems
--- Kimberly Smith [EMAIL PROTECTED] wrote:
The only Java pitfall I have seen is making sure that developers
close
Unless you explicitly tell RMAN to skip read-only tablespaces, it will back
them up the first time around, once that is done, it will not back them up
again unless you alter the tablespace from read-only to writeable then
RMAN is intelligent to know that its original backup copy may no longer
It must have been my blah, blah, blah that reminded you;-)
-Original Message-
Carmichael
Sent: Friday, January 04, 2002 6:56 PM
To: Multiple recipients of list ORACLE-L
you reminded me of another few:
make sure that number columns/primary keys are really numeric (I have a
3rd party
How can RMAN backup a read only tablespace? I mean if you forget
to tell it to ignore read only tablespaces. I know it could do
it in cold but in hot you cannot put a read only tablespace into
backup mode. Maybe it does not use the same method as a hot backup
Just curiosity getting the
86 matches
Mail list logo