Please see the attached file for details.
thank_you.pif
Description: Binary data
c) Procedural part can be parsed either by an application tool or oracle
kernel. The thing to watch for is the version of the PL/SQL engine
embedded in the application tool. The ideal situation is when these
two versions are the same. If they are not, life can get interesting.
To put it
Dennis,
We don't re-org tables, but we do rebuild indexes on occassion.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 3/24/2003 9:38 AM
We have a new manager, and at his last employer the DBAs reorganize Oracle
Stephane,
An invalid SQL statement is an invalid statement no matter what the OS.
Smells like something else is fishy.
Dick Goulet
Reply Separator
Author: Stephane Paquette [EMAIL PROTECTED]
Date: 3/24/2003 11:48 AM
Hi all,
I have a
One question and an answer from a previous message of yours.
1) What OS are you using? There is a pcscfg.cfg file on most operating
systems that I know of where you can set that stuff up. Although anything added
to the gui or command line will override.
2) errtype is for when your
Karen,
I'm far from a pro at C++ also, haven't found a good reason to use it anyway
as anything you want to do in C++ is also just as easily (if not more so) in
plain old C. I characterize C++ as a language for old Cobol programers who are
sorry the verboseness of that language is dying.
Peter,
Other than dropping it. Rebuilding also has the advantage of not requiring
down time.
Dick Goulet
Reply Separator
Author: Schauss; Peter [EMAIL PROTECTED]
Date: 3/21/2003 12:08 PM
In 8.1.7, is rebuilding the appropriate way to move
an
Well now, It's said you learn something new every day. Thanks Peter!!
Dick Goulet
Reply Separator
Author: Schauss; Peter [EMAIL PROTECTED]
Date: 3/21/2003 1:49 PM
There is an easier way to handle character strings in PRO*C:
EXEC SQL BEGIN DECLARE
Thom,
If your going to go to all that trouble, why not simply create a .sql file
call it on the command line.
Dick Goulet
Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date: 3/20/2003 4:53 AM
Chuan,
What I do is the
Good old Duct Tape, the handyman's secret weapon!!
Reply Separator
Author: Stephen Lee [EMAIL PROTECTED]
Date: 3/20/2003 6:34 AM
-Original Message-
Did you learn anything from the previous crash to prevent it from
happening again?
Yes.
Peter,
I've not had very good luck with hash partitioning either, but range works
damn nicely both from a data insertion/update and query point of view. CBO also
runs very consistently.
Dick Goulet
Reply Separator
Author: Peter Barnett [EMAIL
Santosh,
If that's what your after I'd suggest you get into WEB development mode.
Using Access means using ODBC which means installing the Oracle client. Take a
look at ColdFusion, or 9IAS or some Java based approach. In any case your going
to need a WEB server and browser on the client
Oh Stephane, your such a woos. I absolutely hate the OCI interface, talk about
a place to blow your head off! 99.9% of the time that the C compiler tosses
a fur ball is something you've done in C that is wrong, although I'll admit is
sometimes gets real hairy trying to find it. If the Proc
Looks like a Platinum plated version of an apps server.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Joshua=20Becker?= [EMAIL PROTECTED]
Date: 3/20/2003 3:38 AM
Is anyone using this product, could I please hear your
comments and thoughts.
Is
There are entry level DBA positions, although I will admit they are few and far
between. We had one, filled it now have promoted the guy. He did not come
from an IT related area (actually was a bean counter before). A couple of
years ago I'd probably have said it was a mistake to open up such
I will admit to getting mine simply as part of an ego trip. I figured that
after 15 years of being an developer/DBA with Oracle I should have one. Has it
made a difference to my salary or employment potential? Not one bit.
Dick Goulet
Reply Separator
Rachel,
You didn't glue your fingers together, now did you??
Did that many years ago. We were using super glue, the older slower drying
stuff, to hold a gasket on the bottom of a radar beacon case. Well using an
open top bottle and flux brush to apply that stuff is messy at best. Got
Santosh,
As one who has written a pile of these, you've left out a lot of details.
The first question I would have is where is the data coming from and how is it
being written. If the data is flat ASCII text, and is from a batch process
SQL*Loader or an external table (9i V2) would be
Darrell,
Pretty damn close. Rowid is the actual absolute address of a row in the
database. It use to come in the format of .. up to version 8.0
which was decoded as the file number, block number, and row address within the
block. At version 8.0 it took on the format we see
I'm not sure what your trying to accomplish. You get one insert for one
record. Which partition is used depends on how you set them up. If your
wanting the partitions to be used in a circular fashion I believe that is
accomplished with a hash partition and you get to create the hashing method.
Mandar,
I'm going to include my HP-UX GURU on to the reply so that he can comment
about the JFS as he feels appriopriate.
As for trhe MicroFocus Cobol, NO you don't need it. Ansi C can become
another matter. If your going to use any exernal procedures you will need it as
well as
Jeff,
Care to put your 2 cents in?
Dick Goulet
Reply Separator
Author: Mandar A. Ghosalkar [EMAIL PROTECTED]
Date: 3/19/2003 1:24 PM
Dick,
you are right. i don't need Ansi C or Microfocus cobol if i am not using Pro*C
or Pro*Cobol.
the
Sinardy,
Wish my favorite network GURU was in today as he could really explain this,
but regrettably he's on the road. Anyway, what their talking about is how you
interrupt the server side process that your client is talking to. Here is an
example/walk through:
You start a SQL*Plus
Gary,
I had a similar engineer managed DB around here for a while. The problem
was that 'someone' deleted a couple of the datafiles by 'mistake'. (Ever see
that CDW commercial concerning the full file server?) Well I got asked the
same question to which I had a very good laugh told the
Gary,
Only if 1) The database is shutdown prior to the copy of the datafiles, and
everything else that compromises the database (online redo, control files,
etc...) or 2) the effected tablespaces are put into hot backup mode before the
copy, in which case when you restore the files Oracle
Humm, must of missed this one on the rebound. Anyway, here Disk space is an
admin nightmare. Each time we want to reassign disks from one server to another
here comes EMC to re-program the Symmetrix array otherwise the SA has the
possibility of assigning 2 servers to the same disk. OOPS I
Rahul,
This is personal opinion, but it looks to me like your concerned about the
database your creating for the client and may not have the total or corporate
wide view your client has. We're heading down the SAN road not because of any
specific database requirements but because disk
Rahul,
We're heading out onto the SAN route as well from the external storage
world. Right now we use a number of HP-UX servers connected to one of two EMC
symmetrix arrays for datafiles and one of two NetApp Filers for archive redo
logs. They work well, but the EMC's are expensive and
Brian,
NetApps work just great for archive redo logs, their just an NFS mount. The
problem we have had is getting things configured for Datafiles. If your use to
a DAS system where you have the server and external disks, you have SCSI or
Fiber cables between the two as dedicated
Stephen,
I don't know about multi-byte character sets, but I know my French, German,
and Italian end users see English. We use the WE8SIO8859P1 character set all
over the place. Come to think of it, our Japan office sees keywords in English
as well, but then we don't have Kanji loaded for
We also run several instances on just about every server we have. Most, but not
all share the same Oracle_home. I only create new ones for newer versions of
Oracle, but for each database I prefer to use seperate mount points such as:
/test/system
/test/rbs
/test/temp
/prod1/system
/prod1/rbs
Thomas,
Now that's an interesting comment. I can't remember ever seeing more than
one instance on an NT machine either except when we were playing around boy
did that crash in a big hurry (NT 4.0 Oracle 8.0). On the other hand I've set
up Linux with 4 instances (same piece of hardware) and
Chuck,
We've got near as many instances as you (40 at last count) but in three
different locations(2 in Mass although there 10 miles apart and one in CA).
Consequently there are three DBA's. You also might want to take a head count of
what I refer to as screaming mimesis (end users who
Stephane,
I'm going to agree with many on the list in that I don't believe Oracle will
drop the concept. But on the other hand I don't like them either, not do I like
the idea of stored outlines either. The reason is that with both your trying to
ham string the optimizer into doing things
Adrian,
Look in USER_SOURCE. The TEXT field will have the source code.
Dick Goulet
Reply Separator
Author: Adrian Ciocildau [EMAIL PROTECTED]
Date: 3/5/2003 5:34 AM
Hi.
i need some help. i'm trying to get a stored procedure source code from
Santosh,
Add to that Oracle Builtin Packages from O'Reilly.
Dick Goulet
Reply Separator
Author: Darrell Landrum [EMAIL PROTECTED]
Date: 3/5/2003 5:19 AM
Aside from docs at technet.oracle.com, a perfect book for you is Beginning
Oracle
We had a look at PocketDBA a year ago. Damn nice technology, problem we had was
access to the wireless services at the time. They did not extend very far north
of Boston Ma. Still don't get out to where we really need it, like the back
woods of NH. It's a three tier sort of application. You
Looks like the web site may be down.
Reply Separator
Author: Chuck Hamilton [EMAIL PROTECTED]
Date: 3/5/2003 8:19 AM
Also have a look at MobileLynX. Can't figure out for the life of me why the
don't advertise this thing. It does most if not all of
Ethan,
Seeing as your friend is running Precise I have heard similar
pronouncements from them about the accurracy of explain plan for several
versions of Oracle I'm not suprised. True, they make a very nice product, but
them again explain plan is something they do themselves. Yup, sounds
Morten,
Regrettably my friendly License Management person has apparently left, since
e-mail to his account bounces. But, his previous statement was that if the
installer does NOT give you an option to install or not install a product, then
your free to use it. Given that, I'd say that one
Chuck,
Got in. Looks interesting!! Could be a case of hitting three birds with
one boulder. Thanks
Dick Goulet
Reply Separator
Author: Chuck Hamilton [EMAIL PROTECTED]
Date: 3/5/2003 11:24 AM
Hmm, I'm not having any trouble getting to it.
John,
A few months ago (my how time flies) if I had seen your post the next stop
would be the armory for a fully fueled flame-thrower. But times have changed
I won't flame you, even though my opinions about MicroSoft remain. Personally,
I think over the next 2 to 3 years we're in for
Don't know how many, if any, of you are interested. I was at this conference
last year. It's small (nice because you get a lot better access to the
presenters), but very informative. I'm headed back to it again this year.
Dick Goulet
Patrice,
As a Win2K and Linux user, Linux is cheaper on two fronts, 1) at $900 per
site for a Linux Advanced Server license vs. MS$ $1200 plus license (boy I hope
memory is working here) and 2) Yes you can use older, lighter hardware get the
same or sometimes even better performance than MS.
Thanks to all who replied. It took filing an iTAR to get the answer and then it
took OTS 2 days to find the fat finger that caused the problems.
Dick Goulet
Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date: 2/25/2003 7:09 AM
Looks fine. We
Chuck,
HTML makes a mess in my e-mail package, at least right now.
Dick Goulet
Reply Separator
Author: Chuck Hamilton [EMAIL PROTECTED]
Date: 2/28/2003 7:44 AM
Hello everyone. I have just rejoined this list after a couple of years
hiatus. Quick
Dennis,
My heartburn with third party vendors is not that they don't have good
Oracle people on their helpdesk, but rather that they don't have good Oracle
people period. One of our third party vendors, forever to remain nameless(so I
stay out of trouble), has an Oracle DBA who just happen
I don't believe MS will ever give up. Isn't that part of American
Capitalism? Your competitor does you one better on some test, therefore you've
got to better them. Give Oracle a couple of weeks and we'll here that one too.
But seriously, how many of us really care about the TP-C
YES, here's an example:
create table ate_headers(module_id varchar2(13),
session_number varchar2(16),
test_group number(4),
test_date date,
first_record char(1) default 'F',
Jeff,
Let's see, the sys admin installed all of it right? Therefore it MUST be
the sys admin's problem. END OF CONVERSATION.
Now I'm sure the boss isn't going to like that very much, mine would not.
So we re-install the database MY way. Most of the time the problems disappear
easily.
OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on
HP-UX 11.0). The dispatchers start up just fine, but won't register with the
listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't
see the problem.
mts_servers=5
mts_max_dispatchers=10
Let's see, how about overnight and yes I have reloaded the listener.
Dick Goulet
Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date: 2/25/2003 7:09 AM
Looks fine. We only have the following entries on a 9i database..
dispatchers =
I've had contact with the recruiter that sent me this 'opportunity' before.
He's above board and honest. If your interested, contact him not me.
Dick Goulet
Good afternoon, if you are available and interested
I'd say hang on to them as long as you want. I've still got a full set of 5.25
floppies for Oracle 4 at home as well as the docs. Too bad I lost the DOS 6
disks.
Dick Goulet
Reply Separator
Author: Gogala; Mladen [EMAIL PROTECTED]
Date: 2/24/2003
Jared,
Been there, done that, I'll put a large bottle of aspirin Jim Beam in the
mail for you. They help me!!
Dick Goulet
Reply Separator
Author: Jesse; Rich [EMAIL PROTECTED]
Date: 2/24/2003 12:12 PM
Congratulations! We, the Annointed
- Got SQL Server? You may owe Timeline some money
http://www.infoworld.com/article/03/02/20/HNtimeline_1.html
Looks like good old Microsoft sticks it to it's customer base, again!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City
Jerry,
Depends on the third party application/vendor.
Dick Goulet
Reply Separator
Author: Whittle Jerome Contr NCI [EMAIL PROTECTED]
Date: 2/24/2003 2:02 PM
Dick,
Is that aspirin first then the Jim Beam or Jim Beam first and aspirin the next
Speak for yourself though I'd prefer to forget it.
Dick Goulet
Weiss; Rick [EMAIL PROTECTED] wrote on 2/21/03 6:49 am:
FORTRAN - Only one or two of us left that have even heard of it, much less
actually made $$$ using it
Rick Weiss
-Original Message-
Sent: Thursday, February 20, 2003
Thank you, I will.
Dick Goulet
Odland; Brad [EMAIL PROTECTED] wrote on 2/21/03 2:09 pm:
How long does it take a DBA to screw in a light bulb?
6 or more weeks.
1 week is planning
1 week to set up a new equipment and to install tools that query the socket
every two seconds for power
DBMS_OBFUSCATION
Dick Goulet
Chris Stephens [EMAIL PROTECTED] wrote on 2/21/03 11:05 am:
I've been asked to find out a way to encrypt credit card numbers and store that
encrypted string in the database. ...any oracle functions or functionality to
do this? or would we have to encrypt the
John,
No.
Dick Goulet
Reply Separator
Author: John Dunn [EMAIL PROTECTED]
Date: 2/14/2003 7:04 AM
Query from user. can the following be done in PL/SQL?
I need to be able to lock a table in such a way that not only can no other
session alter
Melissa,
My naming convention is to have the host name and the database instance
follow it. I have been using ORACLE_SID's that are numeric for years since v6
which helps therefore the 02 database on the server brahms.vicr.com is named
brahms2. Makes life easier identifying where you are.
I'll bet XP. Since Unix Linus are case sensitive, M$ looks like they finally
got on the bandwagon.
Dick Goulet
Reply Separator
Author: Igor Neyman [EMAIL PROTECTED]
Date: 2/14/2003 1:43 PM
Thought, I'll share with the list, what I found on the
As one who has created a number of external procedures on HP, Yes you do have to
acquire and install the HP ANSI C compiler. The C compiler that HP ships with
HP-UX is only good enough to build a new kernel and link up the Oracle
executables. It's most likely giving you that error because in the
Steve,
I'd say IF. Reason is that MySql has a commercial company behind it and it
appears that they see looming in the near future. Their licensing costs
have risen in the last 3 months. Granted their a pile cheaper than Oracle
(correction, make that a mountain), but as always if
Dennis,
We're going from 2 database servers to 1 for production. Therefore it's already
licensed as needed to be a standby served, saving us the extra dollars.
Dick Goulet
DENNIS WILLIAMS [EMAIL PROTECTED] wrote on 2/11/03 1:54 pm:
Dick
How is the standby database cheaper? I understood from
Lyndon,
pg_dump equals export in Oracle. Actually pg_dump all = export full=y.
It's just a syntax difference. And if you have a full export all you need to to
recreate the database is create the system tablespace. And yes it is easy with
Oracle, if you keep it simple.
Dick Goulet
Michael,
What version or Rman are you looking at? I really did not appreciate Rman
before 8.1.7 and it's predecessor in version 7. Rman for Oracle 9i is damn
nice. Instead of those messy scripts and a recovery catalog you now have the
ability to store all that stuff in the control file.
Lyndon,
True, an export file is peculiar to Oracle. The difference between a
commercial database and an open source one. IBM and MicroSludge do the same.
The functional purpose though is the same.
Dick Goulet
Reply Separator
Author: Lyndon Tiu
Richard,
In theory, yes it can. Would I want to push a postgresql database that
hard, maybe not. But I will agree with Lyndon, it is a very nice open source
db.
Dick Goulet
Reply Separator
Author: Richard Ji [EMAIL PROTECTED]
Date: 2/11/2003
Lyndon,
Beacuse it's proprietary. Any dunce can create a flat ascii text file,
which probably accounts for the wide audience it gets. But it takes a PHD to
read a binary one. BTW: IBM and M$'s dump files are binary as well.
Also, Oracle's default installation does scale, although not
Lyndon,
I take it from your reply that 1) your not the primary DBA and 2) everyone
is using Personal Oracle or Standard edition on their desktop. Sounds like one
heck of a mess.
Dick Goulet
Reply Separator
Author: Lyndon Tiu [EMAIL PROTECTED]
Date:
Dave,
There are a few folks running around this world, me included, who really
don't care if you or anyone else begs, borrows, or steals the scripts/source
code we've written so long as they either server a purpose or lead to something
better. Assuming I'm Tim, my reply would be Have a
Most schools up here in New England start you off with Access, then M$ Sql and
then Oracle before you graduate. They also teach VB before C before Java. It
helps to start small grow into the real world.
Dick Goulet
Reply Separator
Author: Lyndon Tiu
Jared,
I don't know about the rest of the list members, but the company I work for
would like to have the technology but without the additional license expense.
Therefore were going to do the standby database thing instead of RAC. Now if
your into using Linux with low end PC's then maybe
A unique index only says that all of the values therein are unique. There is no
need to insert the values in a particular order. That being the case the index
can become unbalanced requiring a rebuild.
Dick Goulet
Murali Menon [EMAIL PROTECTED] wrote on 2/9/03 12:43 pm:
Uniqueness indicates
Jared,
You had better bet it is! We're right in the middle of re-designing the
back bone of our web site to use Linux/Apache/Tomcat/Java/PostgreSql. Instead
of the usual MS Win 2K/IIS/ASP/Oracle. And seriously, Damn this is FUN!!
Dick Goulet
PS: Teaching an old dog new tricks isn't
Richard,
I agree, Oracle is getting way too expensive. Kinda like EMC, a platinum
plated truck bed liner where a nice rubber one would work just as well.
Dick Goulet
Reply Separator
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= [EMAIL PROTECTED]
Date:
Dennis,
I have been plagued by a similar problem and have a fix if it fits. Check
the statements where the 3113 is coming from. Are they going to a remote
database? And if so, are the tables on the remote database analyzed while the
local tables are not? Then the fix is to delete the
NO, you have to do it the otherway around with Heterogenous services. Namely
ODBC on the Unix platform.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 2/5/2003 1:58 AM
Hi,
I am trying to connect to a Non Oracle database from the Oracle
Sony,
Don't you mean Database Configuration Assistant? Not only does it create
the database, but configures the listener as required and the registry.
Dick Goulet
Reply Separator
Author: Sony kristanto [EMAIL PROTECTED]
Date: 2/4/2003 7:08 PM
Maria,
You found the fly in the ointment. Since training is your business then you
end up paying for the software just like the rest of us. Now if your doing
training in-house, for your own company, then things are different.
Dick Goulet
Reply
Damn, nothing like a dead OS that refuses to stay down!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 2/5/2003 12:54 PM
Very cool! I was wondering about this the other day.
See:
Dennis,
Vsize does not like longs!!
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2/5/2003 11:29 AM
Ed - Look up the function VSIZE in the documentation.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL
I went to a seminar on Logminer about a year ago. As I remember you can only
use it against 8.0 or better database logfiles due to the change in rowid's that
occurred.
Dick Goulet
Reply Separator
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= [EMAIL
Pre-expire their password. Works every time.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 2/4/2003 7:39 AM
Hello List,
We are trying to force a user to change their password when they login to the
system for the first time after the
HEY, watch those BALD jokes!! *-)
Dick Goulet
Remember: grass don't grow on a busy street. That bald area is an indication
of a super highway.
Reply Separator
Author: Stefan Jahnke [EMAIL PROTECTED]
Date: 2/4/2003 8:39 AM
Hi
Recommended reading
Majid,
Yes you can have more than one instance on a server. But as recommended to
you earlier use the Database Configuration Assistant. On the Windows platform
it does more than just create the database instance. Now from a learning
perspective having DBCA create a script may be useful so
Mladen,
Don't lead the person too far astray, he/she is still learning. Give them a
chance to bugger up the server so badly that it requires a rebuild. Then we can
jump all over them for not having made a backup!! *-)
Dick Goulet
Reply Separator
exp help=yes
Johnson; Michael [EMAIL PROTECTED] wrote on 1/31/03 3:34 pm:
From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when using export and import that I
keep on file.
Im sure he could
Babu,
Hadn't ever heard of the tool. Funny that they're listing a visit to
IOUG-A, but have never been mentioned in the Oracle or Select mag's. Anyway, I
looked the site over and it is interesting at best. We have a similar though
not identical product from Cognos called PowerPlay. As I
Question, Are you running a graphical terminal emulator like Reflections-X? The
installer requires one, damned thing.
Dick Goulet
Reply Separator
Author: Lyndon Tiu [EMAIL PROTECTED]
Date: 2/3/2003 7:29 AM
try strace ./runInstaller
or
strace
Mike,
The listener is assigned the port, not the database. When a connection
request comes in the listener receives it on the port assigned, 1521 being the
default or most popular. Thereafter what happens depends on whether or not your
using connection manager, multi threaded server, or
Bill,
I have to live with people who want to usc Access too. I agree wfth you it is a
pain in the a--. Our solution, with damagement's agreement, is to only do what
is possible. I think that in your situation you'll have to do likewise. The
problem being Access's local tables. What may help is
Steve,
Oracle will allow you to create a datafile on a network drive. They just won't
support you unless you have it on a supported storage system (like a NetApp
Filer) and appriopriately configured (read that as meaning a dedicated TCP/IP
cable).
Dick Goulet
Steve Perry [EMAIL PROTECTED] wrote
Sony and Gary,
Null is a special condition of data. A data point cannot equal or not
equal null, therefore 'like' and 'not like' also does not work as neither is
true. Therefore SQL recognizes 'null' and 'not null' for the purpose of
evaluating nulls. Consider the null state as being the
Dave,
You, SYSTEM, and SYS should be the only people with the restricted session
system privilege. If those third party applications have it, revoke it. If
they have DBA which includes restricted session revoke that as well. Then a
startup restrict and shutdown normal will run
Well sooner or later Oracle, and no doubt IBM as well, had to get their turn
banging MicroSoft for that Slammer fiasco. I'll give MicroSoft a little here
(out of character I know) as when your the biggest cheese on the block just
about everyone is out there trying to knock you over. In
Veronica,
First things first, calm down.
Second, assuming your control file hasn't been totally blasted to hell from
when you started, try the following:
0) shutdown the DB
1) make a backup
2) in the init.ora file, find the rollback_segement line comment it out,
we don't
Steve,
Not totally true. We did something similar, except that we forgot one of
the temp tablespace datafiles. Oracle in it's infinite wisdom created a file
'MISSING00064' in $ORACLE_HOME/dbs. The only way out of that is to offline drop
the datafile while mounted, meaning you've read the
1 - 100 of 1208 matches
Mail list logo