http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7
Cheers,
JoJo
Hi
Note: I'm still testing RMAN and not using it
If you have more than one database managed by the same repository you need
to somhow tell RMAN which database to duplicate. Connecting to the one to
duplicate sounds like an option.
Also RMAN is capable of duplicating upto the current time isn't
Hi,
You are probably encountering BUG 1834502
Fixed in 9.0.2 (duh)
don't use to date but instead write
set until time 'dd-MON- hh24:mi:ss'; {exact format mask}
Jack
* While installing EM 9i, it asked to creating a separate database for its
repository to which I said Yes. Now the problem is that the database tools
like SQL*Plus and SQL Workseet defaults to EM Repository database and not
the original one. How do I specify the database name for database tools
Hello Paul
Open the replication manager and check there if you have replication
working.
I concur with Rachel. If you have replication you WILL remember activating
it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April
Well, yes ! When installing Oracle, he needs to run root.sh or
orainstRoot.sh
as root !
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
Dave Morgan [EMAIL PROTECTED] 05/04/2002 12:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
list,
i have 3 hdisks, i created ONE volume group for each hdisk, the VG size was
just a little
less than that of the disk...
hdisk1 vg1
hdisk2 vg2
hdisk3 vg3
then i creatd mount points /hd1, /hd2/, and /hd3
and created 3 file systems on 3 volume groups and mounted them on the above
Yes, you're right in your assumption.
There are more complex ways to do this but for a 3 disk setup I think you're
wise to keep things simple.
I don't see any reason to put each LV in a separate VG though.
One point I'd make is that you might like to look at raw devices for at
least your online
Title: RE: Table Insert Lock!!
Hi subra( my ex-pm name),
Hope that ur not pricise in ur ?.
If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by
table level trigger of INSERTING.
Sorry if i was u/s wrongly.
Nirmal.
-Original Message-
From:
I need a where clause to ACCURATELY (down to the second) calculate the
previous 24 hours when a query is run and bump the time by 6 hours
(event_date is based on GMT). The default date format has been set to
'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'.
I've tried the following:
where
It will ask for the necessary archive and active logs. I am still on
8.0.6.3 and will be forever, and there is no duplicate command. You have to
fool rman into making a duplicated database. But it works the same way.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L
Message-From: JoJo Zawawi
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 4:28
AMTo: Multiple recipients of list ORACLE-LSubject:
Fairly Boring News Article on Oracle
http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7
Cheers
Hi
Maybe completely misunderstood the Q:
where event_date sysdate-18/24
Jack
Johan Muller
Also, be sure of the correct terminology. Know what network service names,
connection strings, etc. are. I went into the exam last week knowing
exactly what these things LOOKED like in the config files but not what
you're meant to call them (although it was possible to work them out from
/20020409/tc_nm/tech_oracle_dc_7
Cheers,
JoJo
No conversions required:
where event_date (sysdate - 1 + 6/24)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 8:13 AM
I need a where clause to ACCURATELY (down to the second)
where x sysdate - 18/24
hth
connor
--- Johan Muller [EMAIL PROTECTED] wrote: I
need a where clause to ACCURATELY (down to the
second) calculate the
previous 24 hours when a query is run and bump the
time by 6 hours
(event_date is based on GMT). The default date
format has been set to
Johan,
There is no need to convert sysdate to a string and back to a data. I'm not
sure what you mean by calculate the previous 24 hours when a query is run
and bump the time by 6 hours.
It looks like you are trying to retrieve all records that have a date/time
within the last 18 hours - is
Jared - The list prices we were able to find were
Standard Edition Unlimited users $15,000 per CPU
Enterprise Edition Unlimited users $40,000 per CPU
This is list, your organization may be able to get a better deal. Needless
to say, for new projects we have been looking VERY hard
09, 2002 4:28
AMTo: Multiple recipients of list ORACLE-LSubject:
Fairly Boring News Article on Oracle
http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7
Cheers,
JoJo
Do we have a location, date, time???
--- Joe Testa [EMAIL PROTECTED] wrote:
So for those of us going to the IOUG Conf, do we
want to plan a get
together?
Throwing this out for ideas, etc.
Joe
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joe
Ron,
That's an idea. Easy to implement and test. I'll give it a try tonight
to see if it helps.
It is a small table.
Cherie
Ron Rogers
I have an export of a 16G database that is consistently taking 6 hours to
export.
It doesn't matter what time of the day or night the script is executed.
There is
very little activity on the server. Any ideas?
#!/bin/ksh
export ORACLE_SID=adprod
export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab
What do you mean by user dump file? The result of an Oracle Export?
Looking up Oracle dump file on Google, I found the following:
http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html
http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html
Dennis Williams
DBA
anyone whom can tell me why this statement fails in a pl/sqll code:
I get this error message
PLS-00103: Encountered the symbol ||AvdNr|| when expecting one of the following:
. ( * @ % = - + / at in mod not rem then
an exponent (**) or != or ~= = = and or like
betwe
when i run
://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/2002
0409/tc_nm/tech_oracle_dc_7
cid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7
Cheers,
JoJo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services
Also, what do you want to report on, what version of Oracle, what format
does the report have to be in? What does the dump file contain? Does it
contain data?
We have a tool, but before I plug it, it may be better to know your
requirements a little better..
Mark
You have messed up quotes in IF condition
Maybe You can use some coding style other than chaotic?
It helps in debugging, believe me.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Ron,
you're taking a lot of steps that I would take myself.
Which part of the machine starts to glow when you run this?
I'll assume that the target file is not on a disk that's shared with any
database files.
Running sar for the first few minutes of the export will probably show you
where your
=581ncid=738e=2u=/nm/2002
0409/tc_nm/tech_oracle_dc_7
cid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7
Cheers,
JoJo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
Does it happen everytime you do export or just once awhile?
David
-Original Message-
Sent: Tuesday, April 09, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L
I have an export of a 16G database that is consistently taking 6 hours to
export.
It doesn't matter what time of the day
Hi Ron,
Why are you using consistent - do you have to? Have you tried bumping up
your buffer, to like 10MB?
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002
Why, in-house developed applications, of course. Tailored to the
requirements of your business by real people who actually asked you what
your requirements are... 8^)
Here's Oracle's take on web services:
http://otn.oracle.com/tech/webservices/content.html
-Roy
Roy Pardee
Programmer/Analyst
Parameters looks ok, Just use gzip instead of compress . File extention
should be .gz instead of .Z If you can try larger recordsize than 65K ,try
it.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 09 Apr 2002 06:28:20 -0800
I have worked with a little with PeopleSoft and a lot with J.D. Edwards
OneWorld. Also have worked with a lot of people who have worked with them
all. I know the finance guys, the sales order guys, inventory etc...My
experience is that most of them agree the OneWorld is very capable of being
I am just throwing these quickly ...
how large are your rollback segments? Consistent=y means Oracle has to
remember every data block that existed at the time your export began.
I haven't seen recordlength= before, is this the equivalent of the older
buffer= parameter? Here I often set
Check your quotes. Better yet, create a variable as the string then check
the variable.
If I understand your code, the first line would look like this:
If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG' = 0
THEN
I suspect you're going to have problems with the rest of your
***inline...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
I think this is good news, Oracle accepting these user groups.
*** Assimilation can not be far off. This is a bad thing. So much
for an
Every time.
-Original Message-
Sent: Tuesday, April 09, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Does it happen everytime you do export or just once awhile?
David
-Original Message-
Sent: Tuesday, April 09, 2002 9:28 AM
To: Multiple recipients of list ORACLE-L
No way! I'd say that web services are a collection of standards that allow
HTTP-borne remote procedure calls between clients and servers. It's all XML
objects under the skin, if I understand it correctly.
The theory is that neither client nor server need to run any specific brand
of software,
This is code I use and it works. If you see I do not use 'AS' before
select. I am not sure if you need it.
insert /*+ parallel(1, 6) */ into 1
select /*+ parallel(2, 6) */ * from 2;
Shakir
--- paquette stephane [EMAIL PROTECTED] wrote:
Hi,
I'm trying the following insert /*+ append */ into
Like someone suggested, use BUFFER=10MB or more so that you have less I/O.
-Original Message-
Sent: Tuesday, April 09, 2002 8:58 AM
To: Multiple recipients of list ORACLE-L
Parameters looks ok, Just use gzip instead of compress . File extention
should be .gz instead of .Z If you can
Dennis is right. We had to pay extra for partitioning, on top of EE. What
a lovely day it was. The total (to run on a wimpy w2k machine, named user)
could have bought me a new car.
Lisa Koivu
Oracle Database Dog Catcher
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
Ron - My interpretation, based on Oracle Partitioning, is that Option
means that you need Enterprise Edition and you must pay extra on top of
that. Thanks for passing this along.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 09, 2002 10:23
Ron
Let me know which version of oracle you are running?
If it taking longer or longer?
Following may help you to reduce export time
-Try to take export in one file
-Try to take on diffrent disk wich has less IO
Thx
-Seema
From: Hately Mike [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
Yes but then it fails onthe word borttags_flagg, thi serrormessage :
PLS-00103: Encountered the symbol BORTTAGS_FLAGG when expecting one of the following:
. ( * @ % = - + / at in mod not rem then
an exponent (**) or != or ~= = = and or like
I reallydont see what the error is:
Hello everyone,
I'm digging through rman again. Wish I had more time to do this ongoing.
I've looked at the v$views in the past, but didn't dig into them too deeply.
Now that my backup strategy is backup to disk - wait for media manager to
take files to tape, I'll need to be able to
Hi
I have 3 HP9000 enterprise servers and disk array.One of them are
application server on which OiAS 9i is installed.On 2 DB server I installed
Oracle9i.I want to set up fail over.The disk array is connected with one of
primary db server say db01.Whenever DB01 fail then db02 will take take
I donot have UWIN so I can not test it. However on UNIX using ksh you
not only you set the ORACLE_SID and ORACLE_HOME environment variable,
but you need to export them as well.
try it,
Shakir
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
Hello,
I am getting this ORA-12560: TNS Protocol
Patrice -
For an introduction to web services, go to
http://www.computerworld.com/cwi/story/0,1199,NAV47-68-85-1942_STO64099,00.h
tml
(or go to http://www.computerworld.com, click on Quickstudies, and scroll
down to web services).
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
If the user dump file is an output of a traced session, use tkprof to
generate a *.prf and the vi *.prf
---
CSW
-Original Message-
From: Yahoo [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 5:24 PM
To: Multiple recipients of list ORACLE-L
Subject: How to read user
Hi Rich,
Thanks much for detailed information. I was glad to see an OID
implementation out in the field. Couple of more questions:
I know TNSNAMES.ORA can be replaced by OID, but have you taken the next step
and migrated Oracle accounts to OID? We are looking at OID to centralize
user
Hi,
try setting BUFFER (size of data buffer) big enough
and statistics=n if the default is Y
By
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 5:33 PM
What about using a direct export?
Also, you could look at the
I'm contemplating doing an Rman backup and recovery handbook. I'm wondering
what you would like to see in such a book and would you use such a book?
Ideas and comments welcome.
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking
Yea, but just how fast would that used car lookup, sort and
group 2 TB of data? :-)
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
The last time I checked SE didn't have patch maintenance. So you could get
v8.1.7 but not v8.1.7.3. If that works for you, fine. Didn't work for me.
Brian P. MacLean
Oracle DBA, OCP8i
Sorry, my mistake.
Just checked the Oracle store: 40k per CPU for EE.
Yikes!
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/09/02 07:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Hi,
If I have a function based index such as
CREATE INDEX emp_idx01 on emp(SUBSTR(first_name,1,20))
Is there a way to build index where 1,20 portion can be parameterized? If
so how would this be done?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Robert,
Put me on the list for a copy when you finish. Seriously, It is a
needed book that will make sense of the information presented in the
doc's. A down to earth instruction manual that explains in real terms
the usage and options for RMAN.
Lisa posed a question about the different views
MSRP. Of course, the actual price depends on which part of the fiscal
year you catch the sales weasels in... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
I have a buddy that works for Gartner. Says they have a deal that if you
call them they will come in free of charge and look at the price you have
negotiated with Oracle. They will then make a recommended price or
negotiate the deal, not sure which. They get to keep 25% of the total
savings.
I agree with Ethan.
1. Please give some good examples for working the various storage
management
products, Veritas, Tivoli, Legato, etc? I've spent a huge ammount of
time trying to get the transport layer working properly.
2. Cloning (I can share the scripts I've used) again I had a lot of
Robert,
That's good to know.
A dedicated RMAN book would be great !!
Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato
etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios,
where databases would be recovered on different server and different
I have the book, and it is a pretty good 101 book. My book seeks to go to
the next level, looking at things like the data dictionary views, the
recovery catalog tables and how they are used, backup and recovery case
studies, and the like. I will look for input from this thread for additional
Hi friends,
I need your advise on the following question. I
have DB on 8i and I want create new one on another
machine with 9i.
I thought do the following steps:
1 - Install oracle 9i on a new machine
2 - make full export of the 8i DB
3 - import it on the new one (9i)
So before I proceed
How about an exhaustive list of differences between running with a catalog
and without. In the documentation it is so brief. It also seems that the
disadvantages of running nocatalog are becoming less and less. I flipped
out at first when I found out I wouldn't have another license (and
Kirti - Thanks for mentioning it. I went ahead and ordered it, so maybe I
can report to the list in about a week.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 09, 2002 1:41 PM
To: Multiple recipients of list ORACLE-L
FWIW --
Oracle
Robert,
Sample queries against the Rman Views - or - how to navigate to find stuff
within the structure would be very helpful.
As well as standard installation procedures for using Rman against the
various SBT software components. Configuring these beasts is where most of
the challenge lies.
Stephane,
I don't understand what you mean when you say you can
select on t1 before any commit.
I just tried this on an 8.1.7 database, and there was
a signicant reduction in redo. There was only 668
bytes of redo generated vs. 2320 (see below). I think
some redo will still be generated as
[EMAIL PROTECTED] wrote:
Hi,
If I have a function based index such as
CREATE INDEX emp_idx01 on emp(SUBSTR(first_name,1,20))
Is there a way to build index where 1,20 portion can be parameterized? If
so how would this be done?
Thanks
Rick
No. The function is simply applied to the
Oh... I'm sure I'll be asking for help, particularly where the media
management layer is involved :-)
RF
-Original Message-
Sent: Tuesday, April 09, 2002 3:36 PM
To: Multiple recipients of list ORACLE-L
Robert,
Sample queries against the Rman Views - or - how to navigate to find
You need a simple index on the column that gets queried Max(columnname).
The index is always sorted.
-Original Message-
Sent: Tuesday, November 20, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L
hi everyone
we have a query with several max functions in it.
The performance
Hello all,
I have a question concerning the Oracle JDBC thin vs. thick drivers
and how they might affect operations from an application perspective.
We're in a Solais 8/Oracle 8.1.7.2 environment. We have several
applications on several servers connecting to the Oracle database.
For
I'm assuming that you're creating a 9i database on the new machine when you
install Oracle.
I find it useful to pre-create the tablespaces (and users) on the new
database, rather than let the import do that. This gives you more control
over where datafiles end up and do some clearup on
Lisa -
Note 98342.1 might provide you some information. An excerpt:
RMAN DATA DICTIONARY VIEWS used to query the control file
-
If you are not using a recovery catalog, RMAN information is stored in
the
target database's control file .
OMG I thought we were looking at a canned-app query
If it was my database, I would be turning the query upside down and
educating the developer in a not-so-gentle manner. But that's my style -
hormonal and direct. :) You are the better person if you can get through
to the developer
Hello,
Lisa, what I was wondering when I read Rick's e-mail was... what about the
HWM for the indexes when someone truncates a table. The table's HWM pointer
gets reset of course, but I can never recall seeing anything about what
happens to the index space.
Thank you,
Paul Sherman
DBA
voice -
Uh I'm just wondering about the customer table there... anything look
odd about the use of that table in this query or am I missing something
there?
RF
-Original Message-
Sent: Tuesday, April 09, 2002 5:44 PM
To: Multiple recipients of list ORACLE-L
OMG I thought we were looking
Baker, Barbara wrote:
Hi, list.
I'm trying to find out what's eating my system. I found the query, and
explain'ed it. I've never seen an in list iterator before. Can anyone
tell me what that is???
Thanks!!
Barb
Execution Plan
This is my understanding as well. So if you wanted to use the thick driver,
you would need to install SQL*Net on each of your clients. If your clients
are all internal and already use SQL*Plus, for example, you should be all
set. Otherwise you may have some difficulties with this option.
Marc
how about sysdate -1 that will give you exact 24 hours up to the second??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
I am jumping in the middle of this thread so execuse
me if I am repeating the past suggestions I haven't
read yet. In a DW you'd have a date dim of dates only
(no time component to date) and a time_dim (down to
seconds). Your fact table should have a date_key and a
time_key if both date and time
Oracle Database Tank
Hmmm... so are they going to send you to Afghanistan or Iraq in that
database tank Lisa?
RF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Perhaps you're referring to Developer/2000?
If so, that name was first usedwith Forms 4.5. I believe it was also
used for Forms 5.0, but dropped after that.
Marc PerkowitzSenior ConsultantTWJ
Consulting, LLP
- Original Message -
From:
JoJo
Zawawi
To: Multiple
Wow.
Can't believe I didn't see that. She's grabbing every transient customer
(cgrno is the customer type), and is not matching any other criteria.
This list never ceases to amaze me . . .
Thanks.
Barb
--
From: Freeman, Robert [SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL
List,
I have a problem for shutdown one of the instances, got error OAR-00106 I
was looking for the solution on the net, they recommened connect as internal
without using the string connection( I beleive it means service name) but if
you have more than one instance how can connect internal to a
I'm currently struggling with the MML Veritas NetBackup. What I'd like is
cohesive definition and examples showing use of the views (v$backup_sync_io
and v$backup_async_io) that are there to supposedly let me know if the tape
is streaming, and to compare throughput from the point of view of
Thanks. So the most recent version of Forms
is called 6i, is this correct?
Can anyone recommend a good book for this? I
appreciate all suggestions. Also, if I study a 4.5 book, would that work
out alright?
Thanks in advance,
JoJo
- Original Message -
From: Marc Perkowitz
To:
Hi
You can try two books for learning Oracle Developer Advanced Forms and
Reports by Dorsey and Koletzke I also have another one that Uni is using
for a subject on Developer Enhanced Guide to Oracle 8i, Morrison
Morrison both have supporting websites and Peter Koletzke hangs out on the
Faster then the database running on Windows:-)
-Original Message-
Robert
Sent: Tuesday, April 09, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Yea, but just how fast would that used car lookup, sort and
group 2 TB of data? :-)
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA
Hi Peter,
Thanks a lot for the book recommendations.
I have another question: I have Oracle 8i on an NT box. I just downloaded
Oracle Forms Developer 6i Release 2 for NT (which has as part of it,
Oracle 9iAS Forms Services for NT). Can I install it on that same NT box,
or is it going to mess
I have both running on a laptop here the only thing that will happen is
that Developer uses its own net8 client and as such sets the Oracle HOME
to teh home you install Dev 6i in. You most likely will want to install a
copy of your tnsnames in your Develop home. If you have the Home selector
Hi,
I created a primary and a standby database. Both are
9i on Win2000, the same host. Everything was fine,
except the last step:
SQL RECOVER MANAGED STANDBY DATABASE TIMEOUT 20;
ORA-01547: warning: RECOVER succeeded but OPEN
RESETLOGS would get error below
ORA-01152: file 1 was not restored
We had one dba who (by mistake) issued a 'chown -R oracle:dba' followed by
'chmod -R 750 *' from the '/' directory while logged in as root.
Fortunately, it was a server with no production databases on it, just a
couple of Development databases. She never new what a '#' prompt was. She is
long
Hi,
I know this topic has been done to death, but I've only just migrated to
8.1.7 from 8.0.6 and am looking into LMT's vs DMT's. Do listers reccomend
migrating all tablespaces (other than system) or should I do my temp
tablespace only?? What is the general thought out there?
Also, is the
Hi,
I have a table in which inserts/updates or deletes are taking place very frequently( in the order of 1/sec) , Now I want to have the information on how many inserts or updates or deletes took place in the table.
I might ask for a query like how many inserts took place on a specific date
96 matches
Mail list logo