Hi Bambi,
To find out what version of OEM you installed you could open up a NT command
prompt and type oemctrl status oms and then cancel out of the box that
comes up asking for the OMS login.
This works for OEM 2.1 and OEM 2.2, not sure if it works for 2.0.4 and
below.
2.1 came with 8.1.6
2.2
Eric D. Pierce wrote:
As far as the Culture of any Oracle-NT-L, I can see the possible
advantage of having some weighty expert personalities involved. The
culture, and therefore utility, of an email list community is
almost always enhanced when the list is created with a good core
group of
Eric D. Pierce wrote:
Summary
Self-tuning, self-managing Oracle9i monitors your system
to provide high availability, reliability and minimized
downtime. Whether you are a hosting service, in-house
data center, or IT organization, you can rely on Oracle9i
and its system
Dick,
Go with Discoverer. As the admin, you can build a subset of the data
and push it out to the power users with the data labeled any way you
like. You can also give you power users the ability to create their own
views if you are so inclined. They accomplish this through the GUI,
with no
How can I write procedure which runs 3 different subprocedures.?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
select * from user_cons_columns
where constraint_name=(select constraint_name
from user_constraints where table_name = '1' and constraint_type='P');
.. Bunyamin ..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 10,
Thanks to those who replied, the LD_LIBRARY_PATH was set in the profile for
oracle, unsetting this did the trick.
Zabair
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the
Hi Jacques,
It is not reliable if there is row migration.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 11 May 2001 3:07
To: Multiple recipients of list ORACLE-L
-Original Message-
From: Jared
Hello DBA's
I have recently upgraded from 8.1.6.0 to 8.1.6.3.
I seem to be having a weird problem in sql*plus, in that whenever I do a
describe on a table it comes up with the following error :-
SQL desc emp;
ERROR:
ORA-03113: end-of-file on communication channel
I can run select statements
Dear DBA Gurus,
I have Table A and Table B whose structures are almost similar except Table
B has a date-time field column. Whenever I insert a new record into Table A
I want to insert the same record into the Table B along with the date-time
stamp at which the new record is inserted
Does anyone use this? It looks funky and I am interested in any opinions
before I try it out. Im trying to get out of the Legato/Veritas vicious
circle of Very Expensive and only Moderately Useful backup software.
http://www.arkeia.com
Regards
Mark
ERG Group
Use dynamic SQL, it is so simple now that there is
execute immediate instead of prepare, execute,
bind,...
--- Vikas Kawatra [EMAIL PROTECTED] a écrit :
can someone tell me a way to select all tables from
multiple schemas -
and then update records in each of these tables
based on a certain
Hi,
Do you know if Oracle9i block structures are modified ?
thanks in advance...
--
Use itrprof SQL Analyzer.
It formats SQL_TRACE/Event10046 traces and gives tuning advises.
It's web based, no download, no configuration.
Just click
I only know that you can have multiple blocksize in a
DB.
--- Danisment Gazi Unal (Unal Bilisim)
[EMAIL PROTECTED] a écrit : Hi,
Do you know if Oracle9i block structures are
modified ?
thanks in advance...
--
Use itrprof SQL Analyzer.
It formats SQL_TRACE/Event10046 traces and
Hi Scott,
Pickling is serializing arbitrary object-oriented data structures. That is,
converting them into a byte stream for storage, transmission over a network or
iterative navigation as in this case. It is a more complex process than you
might imagine. If you want more information, search the
Hi Gurus,
I got the solution. Here is the modified code:
create or replace trigger trig_dept1 after insert on dept for each row
begin
insert into dept1(deptno, dname, loc, date_time) values(:new.deptno,
:new.dname,
:new.loc, sysdate);
end;
Thanks Rob Fegan and Amol Joshi
Are the tables you are loading in direct mode in the same tablespace as your
other tables ?
If this is the case, then you will not be able to perform a complete
recovery on the tablespace
affecting the other logged tables. Whenever I have a mix like you have, some
logged and some not,
I keep the
LOL!!
-Original Message-
Pierce
Sent: Thursday, May 10, 2001 10:17
To: Multiple recipients of list ORACLE-L
HELP
On 10 May 2001, at 12:53, SuzyV scribbled with alacrity and cogency:
Am I an idiot??
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Hi all,
Can Oracle User change their password with special characters?
Thank you very much
Sinady
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
hi all,
how to take an import from a corrupted export file. the error message is
abnormal end of expoort file.
Thanks,
Mohit
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohit Goyal
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
I have worked on 3 sites with Gold
Hi,
first of all, be sure that export file is not copied in ASCII mode.
if so, You can do:
- take a look at import log. find where it's cancelled
- I guess internal data structers in export file is not so big. It's so
likely that corruption occured on your data. modify binary export file by
A PICKLER FETCH is a fetch that is issued against a table. But before it actually
takes place and anything is returned to you it must be: cleansed of any impurities,
placed in a dark mysterious place, covered with an un-named substance that makes it
feel crunchy when retrieved, allowed to age
Hi DBA's,
How can I drop schema (user and all it's objects). I have one main user in the
application and wants to drop user and all related objects. Can anyone help me in this
regard.
Thanks
Mujeeb Chowdhry
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
connect as sys or system.
drop user username cascade;
The user and all objects will be removed.
james
--- Mujeeb Chowdhry [EMAIL PROTECTED] wrote:
Hi DBA's,
How can I drop schema (user and all it's objects). I
have one main user in the application and wants to
drop user and all related
Mark, how do you manually remove objects from buffer cache? I saw you
writing before that you know how to do it and I would be very interested to
know also if it is not trade secret of course.
Alex Hillman
-Original Message-
Sent: Friday, May 04, 2001 11:11 PM
To: Multiple recipients of
Hi Thye Hock Gan,
Thank you for your info.
I am using Oracle 8.1.6 Solaris 7
Install patch bug122 for SQL*PLUS
How can I change user password with special character
alter user teddy identified by bear12#$;
is not working because of
alter user teddy identified by
Can Somebody please explain to me what this event is , I am not able to find
good documentation on this issue.
EVENT TOTAL_WAIT TOTAL_TIME TIME_WAITE AVERAGE_WA
-- -- --
file identify38343 0 3135 .08176199
file open
Hi all,
Do you guys have any good references (books or URLs) that teach some good
Oracle potential problems with solutions for my contingency plan?
Thank you,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat
so the support bill we just paid should get refunded because it was for
Silver Support which no longer exists? and I pay for support but they
desupport the products I have paid support for, and instead of giving me the
new software release so that the support I paid for is still relevant, they
I just thought I should advertise this... usually people just complain.
Hi Patrice,
I have added indexes on the foreign keys in the [schema_name]
tables. Also, I tuned the SQL statements I was using to perform the
desired deletes.
Results: The one delete job that ran for
I just got the following question from a Microsoft consultant who's helping
another department resolve some problems:
Is Oracle XA Transaction Support enabled on the Oracle DB?'
I have no idea how to check this. If asked, I would have guessed that it
was automatically enabled, but this isn't an
Hi,
Drop user user_name cascade; will drop the user including objects.
Hope this helps,
Muths
At 05:40 AM 5/11/01 -0800, you wrote:
Hi DBA's,
How can I drop schema (user and all it's objects). I have one main user in
the application and wants to drop user and all related objects. Can
http://www.drj.com - disaster recovery journal
For those of us who are beyond paranoid ... and would be carrying the
tapes to the remote data center.
Paul
Sinardy Xing wrote:
Hi all,
Do you guys have any good references (books or URLs) that teach some good
Oracle potential problems with
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats from v$session_wait
periodically ( every second for example) and pump the data
Try drop user username cascade;
Mujeeb Chowdhry wrote:
Hi DBA's,
How can I drop schema (user and all it's objects). I have one main user in the
application and wants to drop user and all related objects. Can anyone help me in
this regard.
Thanks
Mujeeb Chowdhry
Oracle DBA
--
Please
hi,
Because a hacker hackered our system, I have to re-install the solaris. How
can I backup the oracle database?
Just backup all the physical files? I am not a back up and recover expert.
Please help me...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Chen
DORP USER username CASCADE;
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 9:40 AM
To: Multiple recipients of list
Let's try to spell it correctly this time:
DROP USER username CASCADE;
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Armstead, Michael A
Sent: Friday, May 11, 2001 9:24 AM
To: '[EMAIL
Drop User username Cascade ;
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Chowdhry
Sent: Friday, May 11, 2001 8:40 AM
To:
On Fri, 11 May 2001,Paul Drake scribbled on the wall in glitter crayon:
-http://www.drj.com - disaster recovery journal
-
-For those of us who are beyond paranoid ... and would be carrying the
-tapes to the remote data center.
-
-Paul
Never underestimate the bandwidth of a station wagon full of
Eric,
We're using Veritas NetBackup DataCenter (at our colocation facility) for
Win2k and it's been pretty good. We had a problem earlier this year that
eventually prompted Veritas to issue a patched version of one of the
executables. They were very responsive, but it was probably due to the
Use dbms_lock.sleep()
HTH
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.
QOTD: Any clod can have facts, but having an
Has anyone any idea what this means?
It is coming up when trying to use a procedure in a PL/SQL package to
display a web page. With some negative errors we are able to remove
them by reloading all for the application in the OAS manager but not
this one.
Searching MetaLink I come up with
Cyril Thankappan wrote:
with the advent of PL/SQL pages
is Oracle continuing development of MOD_PLSQL
or is MOD_PLSQL merely provided for backward
compatibility?
At run time, the Oracle server and Oracle's version of Apache use modplsql
to process PL/SQL Server Pages, so I'd say
OK,
To answer a couple of questions, I did use compute statistics to get the
stats. I did not use compress=y. The table should have been 420Mb according
to the avg_row_len*num_rows calculation. The export file came out at 5.7Gb.
When I imported it fell over at 1Gb. I set my initial extent to
There is another thread going on about no database on
a single server, I have another question to ask.
We have nearly 30 databases across Sun and Win 2000
Platforms. We are finding it tedious to keep track of
tnsnames.ora. While looking out for a solution we hit
at ORACLE Names server. I hear
DBAs
My alert.log is clogged with following message..
ARC0: received prod
ARC0: Beginning to archive log# 4 seq# 286600
ARC0: Completed archiving log# 4 seq# 286600
ARC0: re-scanning for new log files
ARC0: prodding the archiver
Fri May 11 16:10:01 2001
ARC1: received prod
Fri May 11 16:26:00
There is indeed a sleep, in dbms_lock, taking a single argument seconds.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is
Dennis,
How about dbms_lock.sleep(seconds) ?
Jared
On Friday 11 May 2001 08:20, [EMAIL PROTECTED] wrote:
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose
fyi
(follow up to the thread about Oracle's claims to save
billions by converting business practices with internet
technology)
---original message follows---
Date sent: Thu, 10 May 2001 02:03:28 -0400 (EDT)
TODAY'S NEWS
* GE Scales Back Amid Struggle To Connect Suppliers
...
Paul,
Clarification: I didn't write the material, I was just
posting an excerpt from an Oracle document.
Anyway, I vastly enjoyed your comments. so. I take it
that you also found the lack of detail about self tuning
to be problematic. :)
Presumably we now have a lot to look forward to in
Title: RE: Drop schema and all related objects
-Original Message-
From: james ellis [mailto:[EMAIL PROTECTED]]
connect as sys or system.
drop user username cascade;
The user and all objects will be removed.
--- Mujeeb Chowdhry [EMAIL PROTECTED] wrote:
How can I drop
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-Is this truly the beloved authoress of Oracle DBA 101 I hear?
-
-You speak sourly of our Lord in front of his very home? snicker snicker
Ross be careful. Remember do not meddle in the affairs of dragons, for you are
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on the 30 second
point.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
LOL!
There are enough disasters in the world to support a journal?
: )
(I know, I know... it's to plan ahead, just in case. I still think this was
funny though. It's Friday, OK?)
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
if the tediousness exceeds your perception of the difficulty, do Names.
if not, not.
In my very limited experience, a truly robust, well-managed Names service
is great, but takes some work to set up, test, and document.
YMMV
|| -Original Message-
|| From: Johnson Poovathummoottil
We have 20+ instances this mess called PeopleSoft, so keeping track of
TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle
Names have loved it ever since. If your going to get on Onames, use either
7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs.
This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6.
I have some locally indexed partitions on a table that's
partitioned by time. I dropped the '96 and '95 partitions
of the underlying table and I no longer see them. I used
the following statements:
alter table xx truncate
Somewhat of a pain to setup for the first time, for sure.
But after you get it implemented, you will never want to
go back.
One caveat: There is a fair amount of software around
that *requires* tnsnames.ora or it won't work. Oracle
Forms on unix comes to mind. Yes, Oracle's own software
I am confused now, I thought Oracle was rolling up the support costs into
the license cost calculations now that they discontinued the Bronze, Silver,
Gold support options.
This is like income tax forms! Why can't they just create an income tax
form that is only half a page long! I can't
Yes, it's open source.
My personal project uses Apache, PHP and Postgres on Linux servers -- pure
open source. Guess how long the servers and the web server and hence the
site have been up? Pretty much since we installed. Love it!!! For those
of you who don't know, PHP is a server-side
Yes, I join you in significant frustration with oracle.
( Although I had a visitation from an OWS goddess just
recently that ameliorates my rancor significantly.)
Things like
Postgres www.postgresql.org
and Kdb www.kx.com
are becoming increasingly interesting to me.
But, even if I
I think if you offline a tablespace (or is it
read-only? I can't remember), then any relevant
buffers are flushed out...
hth
connor
--- Hillman, Alex [EMAIL PROTECTED]
wrote: Mark, how do you manually remove objects from
buffer
cache? I saw you
writing before that you know how to do it and I
If you're using the a profile with a password_verify function, then you
shouldn't be using ALTER USER to change a user's password. If you are
trying to change the password through SQL*Plus, then you should instead be
using the SQL*Plus PASSWORD command:
SQL PASSWORD username
Using this command
We had a similar thing when we upgraded OS last weekend. Re-linking sqlplus from the
correct (i.e. new) ORACLE_HOME resolved our problem.
HTH
Stephen
[EMAIL PROTECTED] 05/11/01 01:35AM
Hello DBA's
I have recently upgraded from 8.1.6.0 to 8.1.6.3.
I seem to be having a weird problem in
If there is a lot of objects in the schema you may need to increase
parameter enqueue_resources. If not enougn enqueues this command will give
you an error and user and some objects will not be dropped. If you don't
want to increase this parameter you can repeate this command until user will
be
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-question: Are you an idiot?
Yes, but everybody already knows that.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta
Write a package.
David A. Barbour
[EMAIL PROTECTED] wrote:
How can I write procedure which runs 3 different subprocedures.?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
I was also under the impression that Oracle was just splitting up the cost
for Upgrades and Support mainly because these two pieces can be dealt with
differently for tax purposes. I have no clue what makes large (or even
moderately small) corporations happy, but apparently this is one thing that
Dan,
While this does not work as is, but probably could be in
some fashion, you win the days raspberry for the most
obfuscated answer. :)
Jared
On Friday 11 May 2001 09:56, Dasko, Dan wrote:
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on
Hi,
I've installed RMAN 8.1.7 with my db on NT. I also
use it to back up another NT cluster instance, also
8.1.7. I also wanted to use it to backup a HPUX 8.1.5
instance but i get an error Target DB is not
compatible with version of RMAN. Now I get two
answers from Oracle. The first one
Thanks to all who replied, it works.
[EMAIL PROTECTED] 05/11 1:42 PM
-Original Message-
From: james ellis [mailto:[EMAIL PROTECTED]]
connect as sys or system.
drop user username cascade;
The user and all objects will be removed.
--- Mujeeb Chowdhry [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
I am wondering if there is a similar
function in PL/SQL similar as the Unix 'sleep' command.
Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to
grant execute on dbms_lock to whichever account needs it.
Bill
--
Diana,
Sounds like an excellent alternative to higher end systems (shoots self in
oracle-foot). Have you tested how well it scales yet?
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 10:27 AM
Is this truly the beloved authoress of Oracle DBA 101 I hear?
You speak sourly of our Lord in front of his very home? snicker snicker
|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 11, 2001 10:21 AM
|| To: Multiple recipients of list
dbms_lock.sleep(second in number);
[EMAIL PROTECTED] 05/11/01 11:20AM
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats from
Eric, Sales and marketing have 1 job and that is to sell
and market. These marketing things are teasers not
necessarily giving detailed information. I have not
checked but there may be some Oracle9i stuff on OLN. I
think OLN has a trial membership (for 30 days?). However
I am not sure of the
I ran a few tests of this on both a 7.3.4 and 8.1.6 database and found there
is definitely a difference in the way Oracle handles FK constraints. In my
tests, I created a PARENT and CHILD table, with FK constraint, and with a
trigger on the CHILD. I used two differenct after update triggers: one
FYI I am forwarding this to the list, so please address
replies to the original sender.
-- Forwarded Message --
Date: Fri, 11 May 2001 12:45:43 +0530
Hi jared
This is Nihar from india. I am having some query regarding Oracle
Replication.
Basically i am having 2 diffrent
Sinardy Xing wrote:
Hi all,
Can Oracle User change their password with special characters?
As with other Oracle identifiers, you have to put double quotes around the
password to include nonstandard stuff.
SQL ALTER USER SCOTT IDENTIFIED BY *^%$$# L;
User altered.
SQL CONNECT scott/*^%$$#
Love it! It's open to change.how cool.
|| -Original Message-
|| From: Gary Boyd [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 9:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: PostGres WAS: RE: Oracle 9i Articles - self
|| tuning, launch
||
||
Pat,
I could be totally off base here, but I believe that errors in the
-2 to -20100 range are user defined via the RAISE_APPLICATION_ERROR
procedure. That being the case you may not be able to find the error unless you
have the source code.
Dick Goulet
Reply
For those of us who are beyond paranoid ... and would be carrying the
tapes to the remote data center.
HEY! I resemble that remark!
Rachel
From: Paul Drake [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Contigency plan
Too much of a kill? Not at all. We are currently running ONAMES, and are
planning on going OID as soon as we can get some time. OID (Oracle's LDAP)
has other benefits like being able to authenticate more than just Oracle
connections.
ONAMES is relatively easy to setup. For your
Hi:
use the procedure:
dbms_lock.sleep(seconds);
HTH
--
Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Gesendet: Freitag, 11. Mai 2001 17:20
An: Multiple recipients of list ORACLE-L
Betreff: PL/SQL Question
I need to whip out a PL/SQL procedure real quick today
Title: RE: When to go for ORACLE NAMES Server
There is one thing to be aware of. In a very large
environment, (which you may or may not have) you
don't always want everyone to be able to connect to
everywhere. By using tnsnames.ora files, we can control
which clients are allowed to connect
Try
DBMS_LOCK.SLEEP (
seconds IN NUMBER);
Regards
Karthik Ramachandran
[EMAIL PROTECTED] 05/11/01 11:20AM
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The
Jared,
You may have just earned yourself a dinner. (And I
promise you will not receive it the way you did my
$0.02 recently ;-)
Can you tell me more...alot more would be grand...about
how Forms needs tnsnames?
*thanks*
Ross
|| -Original Message-
|| From: Jared Still
Title: RE: When to go for ORACLE NAMES Server
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
We have 20+ instances this mess called PeopleSoft, so
keeping track of
TNSNAMES is a real tedious thing to do. Consequently we
migrated to Oracle
Names have
Rajnedra, Oracle9i RAC is what we now call Oracle
Parallel Server. Oracle9i RAC is still BETA, so there may
not be any white papers at the moment. I have looked and
have not found any white papers on RAC.
Scott
Dear Friends
Does anyone have any knowledge or experience with Oracle 9i
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 11 May 2001 08:46:06 -0800
DBAs
dbms_lock.sleep will do this...
Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/11/01 10:20 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
On Fri, 11 May 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:
-Likewise with Oracle, and other vendors - why complicate things needlessly?
-Life is bad enough as it is, why try to mess things up for other people even
-more.
Because they can?
--
Bill Thater
Cherie,
I take it that you built your indexes as create index xxx on table(col) local
(partition x1 on tablespace 95,
partition x2 on tablespace 96..)
then you truncated the table in the partition 95 and then dropped the partition.
If I remember correctly the index for the dropped partition
ftp the file to the server again in binary mode instead of ascii...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Mohit Goyal [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L
Subject: import from
Unal, What part of the block sturcture? Segment Header,
Datablock Header? There are things in the blocks that are
no different than they where in 6,7,8 or 8i. However with
some of the new features such bitmap freelists, low
highwater mark, high high waterwater, and changes to
pctfree. There
well if you are lucky and all the files are there, yes, backup the physical
datafiles and when you bring the database up again, Oracle will recover.
You MAY have to open the database resetlogs.
Questions though:
is the database still up? Can you shut it down cleanly (shutdown) and then
do a
Oracle will automatically create an index for your primary
key constraint.
I have a lot of large partitioned tables in my data warehouse.
All of my primary key indexes are non-partitioned. I would
like them to be partitioned.
When I drop the constraint and re-enable it, can I specify
at that
Title: RE: Password with special character
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
I am using Oracle 8.1.6 Solaris 7
Install patch bug122 for SQL*PLUS
How can I change user password with special character
alter user teddy identified by
1 - 100 of 145 matches
Mail list logo