Hi,
In regular way, there is no such method. Remember Codd's rules about
relational databases? :)
But you can create a before insert trigger, which fills a column with
current timestamp or sequencial value from sequence (better).
Later, use ORDER BY clause in SELECT statement.
Alexandre
-
Ther is no concept first row/ last row in any RDBMS. The concept of ROWID
fails as the rows are deleted and hence inserted again. The previous ROWID's
are reallocated again. The only way you can get the rows sorted out in the
way they have been entered is by creating a column in the table
Vikas:
If you want to FORCE the order you can do couple of things like having a big
PCTFREE (to make sure that no rows are migrated because of the updates) and
small PCTUSED so that the blocks are never reused.
In this case records will be stored in (close to) ordered manner and SELECTs
will
I'm hoping that there are
awk gurus also in this list.
my problem:
when I use awk, it cuts
off a part of the line
$ cat -n *0509*|awk '{if
((substr($0,34,2) == "1I") (length($0)) == 107) {print $0}}'|sort
1248 110
2002050990910931381IF110 201 9091PCOR AJ
S1 1
1.7600MD
1249
Yeah...
In fact ROWID is the Oracle implementation and against RDBMS rules. :)
ROWID gives information about phisical location of the record. That MUST NOT
be in PURE relational database. Nowadays, there is no pure relational
database implementation.
BTW, it's better to use sequencial value then
I'm hoping that there are awk gurus also in this list.
my problem:
when I use awk, it cuts off a part of the line
$ cat -n *0509*|awk '{if
((substr($0,34,2) == "1I") (length($0)) == 107) {print $0}}'|sort
1248 110
2002050990910931381IF110 201 9091PCOR AJ
S1 1
1.7600MD
Hi list
When the system account needs the SYSDBA role granted , i simply connect as
internal and grant that role to system.
But the connect internal is obsolete in oracle 9i, so how do i grant the
sysdba role to other accounts ??
thanks
vr. gr.
g.g. kor
rdw ict groningen
--
Please see
Any one got any experience of upgradeing AIX from 4.3.3 to AIX 5L? Any
problems for Oracle (8.1.7)??
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Use a sequence...
SQL create sequence mysequence;
SQL alter table abc add (sequence_no number);
SQL insert into abc(sequence_no, a) values (mysequence.nextval, 500);
...
SQL select a from abc order by sequence_no;
Using a date column will only give you accuracy down to a whole second.
Nothing to do with awk, probably just your terminal which inserts carriage returns.
Shouldn't do that if you redirect to a file or set your terminal width to 132.
- Original Message -
From: Maria Aurora VT de la Vega
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL
Try 'select /*+ ORDERED */'
hth
connor
--- Kirsch, Walter J (Northrop Grumman)
[EMAIL PROTECTED] wrote:
2-cpu, 220mhz, 32-bit HPUX 11.0. Oracle 8.1.7.0.0
Could someone explain what's going on here?
This SQL takes no time at all :
select
substr(username , 1, 12)
thanks for the info.
right now, i cannot do anything about the terminal that inserts those characters.
i am working with an extract file from a legacy system.
i need to extract some lines from the file and load the data into the database.
btw, we cannot change the extract program so I have to
The answer depends on what O/S you are on.
Unix :
When the oracle software was installed you where asked about a Unix
group (normally called dba) that has privileges
this group is then compiled and linked into the Oracle executable.
When member of this group you can connect with /
Hello Maria,
You should look at your file in some hex editor, this symbols might be
symbols with hex code 0A or 0D 0A (it means new line).
So you have to set correct RS value.
Wednesday, May 15, 2002, 3:28:38 PM, you wrote:
MAVdlV
MAVdlV I'm hoping that there are awk gurus also in this
we have W2K platform
so if i understand correctly i put my NT account in the ORA_DBA group, then
connect / as sysdba and grant the rights.
-Oorspronkelijk bericht-
Van: Peter Gram [SMTP:[EMAIL PROTECTED]]
Verzonden:woensdag 15 mei 2002 12:49
Aan: Multiple recipients of list
I plead ignorance. I have not heard of this file before. I do not see this file on
either the server or the client. Does something have to be turned on for these
events to be logged to this file? I have checked the FM but there is nothing found
when I searched on oraus.msg. Does it matter
That's right! Though some people have still had problems when the ORA_DBA
group is not listed *first* when looking at their user account under the
Users Passwords dialogue.
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales
Dave:
You will not see this file in Windoze. In MS world the message file is a
binary file and you will not be able to read with any text editors/viewers.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Hi All
If a form is developed using Developer 2000 on a window's 95 machine having
a particular resolution of the monitor (eg.640 x 480 ) and installed on a
machine with a different monitor resolution(eg.800 x 600) ,the window size
of the form changes.Is there any method to the make these
Yes
I'm assuming that you have not changed anything in the sqlnet.ora file
;-) that is the
parameter sqlnet.authentication_service = (NTS) "useWindows
NT native authentication"
[EMAIL PROTECTED] wrote:
we have W2K platformso if i understand correctly i put my NT account in the
Title: Strange problem with charactersets
Hi list,
I have a strange problem with charctersets, character display.
I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000
yeah, but it's confusing when you look at that file...
|+---
|| |
|| |
|| Rajendra.Jamadagn|
|| [EMAIL PROTECTED] |
||
Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...)
regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
You can use the oerr facility on Unix to look at the events... I don't know if
that file exists under Windows, I vaguely recall a conversation on the list a
while ago where people were saying it didn't. I know that I downloaded the file
from my Unix box to my PC so I'd have a copy.
Anyone out
Title: Strange problem with charactersets
Unfortunately the only solution is to recreate the
database in German character set.
Oracle is very strict in this respect. Database
character set once chosen can not
be changed.
- Original Message -
From:
[EMAIL PROTECTED]
To:
Do you want to physically order them or do you just want to know by time the
order in which they were entered.
if the first, no, not that I know of. If the later, yes, add another column
(ins_date date) and a trigger to populate that column with sysdate when you
insert a row. You can then
Tim,
The tablespace is dictionary managed.
--- Tim Gorman [EMAIL PROTECTED] wrote:
I was hoping to see * column values from
DBA_TABLESPACES, not just
the
default storage column values. This would show
whether the
tablespace in
question was locally-managed (and SYSTEM or UNIFORM,
if so) as
Title: Strange problem with charactersets
Execute the following query:
select substr(parameter,1,30),substr(value,1,30) from
sys.v_$nls_parameters order by 1;
This way you will know the database`s nls settings. If
the client has the same settings as the database, there will be no character
Title: Strange problem with charactersets
Hi I'm just about to ask a really trivial question which has
never struck me before.
If i write a simple select like
select c.contentid from content c,persusercontentassoc
p,teachercontentassoc twheret.contentid = c.contentid
ORp.contentid =
Title: Nachricht
I've executed
this query, database parameters are the same on client and server. Data in the
database is correct. Problem only occurs with Oracle 8.1.7 Client on Windows
2000 (on NT 4 I've haven't tested).
regards
Volker
Schoen E-Mail: mailto:[EMAIL PROTECTED]
Rachel:
If you want to FORCE the order you can do couple of things like having a big
PCTFREE (to make sure that no rows are migrated because of the updates) and
small PCTUSED so that the blocks are never reused. In this case you will get
the
rows in the inserted order.
ANother alternative is
main()
{
EXEC SQL CONNECT scott/tiger@prod;
EXEC SQL EXECUTE IMMEDIATE pl-sql-block-text;
EXEC SQL COMMIT WORK RELEASE;
}
Or something like that...
What are the reasons for converting PL/SQL to C/C++? There are some things
(i.e. operating-system integration, string manipulation,
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
Think that 9i has something of the kind ('native compiler') to boost the performance
of stored procedures. However, I don't think that you have access to the C code
proper, as you can with Pro*C for instance. My
On Metalink look at the Note 151224.1 (PL/SQL Native Compilation in
Oracle9i).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 9:13 AM
Somebody knows how to translate PL/SQL to C or
Title: Nachricht
My problem
is, that everything works fine with Oracle 8.1.5 clients, but not with oracle
8.1.7 clients using same registry and NLS settings.
regards
Volker Schoen E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-Von: Nicolai
I find it under C:\OWRWIN95\RDBMS80\oraus.msg
Readable using WORDPAD.
If you go to your My Computer icon, right click, and pick Explore, then
choose Tools - Find - Files and Folders and enter a search for *.msg
starting from the Oracle_Home you'll find lots of Oracle Error Message
files
Title: Strange problem with charactersets
From Oracle 8i and up you do not have to recreate
the database, you just have to issue an alter command and reload the data.
Unfortunately this would not help Volker any
further.
Tamas
Szecsy
-Original Message-From: Nicolai Tufar
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=151224.1
-Original Message-
Sent: Wednesday, May 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
Hi,
Outer joins can still return rows when no match exists(or empty)
Jack
Gavin D'Mello
I believe the oraus.msg file isn't distributed at all with Oracle for
Windows; only the .msb (binary).
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 8:48 AM
To: Multiple recipients of
Joe, I'm of the school of wishing...oh please..oh please...let us be able to
easily rename columns and constraints in the next version
That is until I am disappointed, then I'm of the school of whining and
complaining...@#(*) Oracle sucks...I hate renaming columns...I hate
constraints...I
K Gopalakrishnan,
This is bad advice. What happens after some records are deleted and new
ones inserted. The new records will be placed within the spaces made empty
by the deleted records.
I would never guarantee retrieving data in the order it was inserted unless
the table contained a
that works unless there is also a reason to see insert not just in order but by
inserted on a particular date or time. I suppose in that case, add two fields,
a date field for the time range and a numeric field for the sequence of insert
|+---
||
Note:1017276.102 says to branch on java is enabled.
What is the definition of java enabled and how do
you tell the value of the variable? Hmmm, no Java admin
guide? Danke sehr.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109
This is kind of a Kludge response. Hopefully, someone
has a better idea, but try wrapping it in Pro C, run
it through the compiler and use the generated C code.
--- Bernard, Gilbert
[EMAIL PROTECTED] wrote:
Somebody knows how to translate PL/SQL to C or C++
(ROBOT, Software...)
regards
I suppose you can if you don't care about wasted disk space, I know everyone
says disk is cheap but that's only until you explain to your manager that you
need a 100GB disk for a 10GB (real used space) database because you are forcing
order by storing each row in one block and never reusing
This is true, and you can see (perhaps accendently) the C code, but I dont
think that many will get enything out of the code generated.
/torben
-- Original Message --
Date: Wed, 15 May 2002 06:38:21 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
From:
using a date will work unless you get multiple records created in a given
second. Use a sequence generated number. The larger the number, the newer
the record. Just order by the sequence to see the order the records were
inserted.
Caver
-Original Message-
[mailto:[EMAIL PROTECTED]]
Renaming columns? Hmmm.
Sometimes I expect our developer doing unexpected moves. That's why I put
views on top of the tables in such cases. Easier to rename columns :)
Have a good day, guys,
Vadim
-Original Message-
Sent: Wednesday, May 15, 2002 11:19 AM
To: Multiple recipients of list
Tom:
I am just giving an option NOT that I recommend everyone to use that.
Then coming to your question:
This is bad advice. What happens after some records are deleted and new
ones inserted. The new records will be placed within the spaces made
empty
by the deleted records.
Set the
Or ... if you are using 9i use the timestamp that gives you a resolution 9
digits after the decimal point for seconds, use that.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
Well! I'm out of ideas. The only other thing I can think of is a recent
ALTER TABLE which changed the INITIAL on the table since the load, but
that's grasping (gasping?). Still, could you look at LAST_DDL_TIME on
DBA_OBJECTS for the table, just to grasp that last straw?
- Original Message
K Gopalakrishnan,
No matter how I look at this, it is still bad advice. Depending on Oracle
internals to return rows in the manner in which they are inserted, when
Oracle states in all of it's training classes that this is not possible, is
bad advice.
You might be correct in what you say - but
"single source (HTML)"
Thanks,
Ken Janusz, CPIM
We are getting the following error in our alert log for a database where we
are doing some unusually large transactions:
Wed May 15 03:26:22 2002
Failure to extend rollback segment 27 because of 1581 condition
FULL status of rollback segment 27 set.
On Metalink I've found a couple of
Dear gurus:
I just added a data file to a big tablespace (11GB) that has only one
table. Unfortunately, when it was being backed up, the file head head
corrupted. I don't have any backup of this file. I found that there is
no data in this file yet. So I want to drop the file from the
I did a very crude test... is dbms_java valid in the database.
Sometimes the tech notes are not as clear as they should be.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, May 15, 2002 12:23 PM
To: Multiple recipients of list
Hello,
Oracle 8.1.6 on HP-UX 11.0
WFM_ADMIN@VGRAFO select num_rows,last_analyzed,monitoring from user_tables
where table_name = 'NOTES_LOG';
NUM_ROWS LAST_ANAL MON
--- ---
1585697 14-MAY-02 YES
Last night, Informatica inserted rows into
No. Get some downtime, quickly(!) before data does get written to that
file. Go through the export/drop tablespace/recreate. BTW, do you know
_why_ the file header is corrupted? Is there a disk hardware problem? You
are gonna have downtime sooner or later. Tell damagement to get over it.
Just tested this on 8.1.7.0.
alter rollback segment rbs0 storage(optimal null);
Rob Pegram
Oracle Certified DBA
SQL select segment_name, optsize
2 from dba_rollback_segs, v$rollstat
3 where usn=segment_id;
SEGMENT_NAME OPTSIZE
Since there is no data in the file, can we make a datafile to replace it?
Tom Xie
-Original Message-
Sent: Wednesday, May 15, 2002 11:25 AM
To: [EMAIL PROTECTED]
There is absolutely NO WAY to drop a datafile from a tablespace at all.
--
\ /
ALTER DATABASE database_name DATAFILE 'filename' OFFLINE DROP;
Then remove the data file physically from the directory in UNIX or NT or any other
server.
Thanks,
Ashoke
-Original Message-
Sent: Wednesday, May 15, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Dear gurus:
I
Umm.. Try this:
1) ALTER DATABASE DATAFILE 'filename' OFFLINE;
2) get rid of the offended datafile from OS
3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)';
4) RECOVER DATAFILE 'filename';
5) ALTER DATABASE DATAFILE 'filename' ONLINE;
Winnie
--
\ /
Tom,
Regrettably there is no way that you can drop a datafile from a tablespace.
Your stuck with having to drop the entire tablespace. If you can export and
import that's great. Otherwise try creating a new tablespace, copying the table
(with a new name) into the new tablespace, dropping
We have a developer who has asked this question. How
do you call an external java class from a pl/sql
stored procedure?
You can stick my knowledge of java in a thimble. Can
this be done, if so can you point me to a url with an
example or two.
Thanks,
Pete
=
Pete Barnett
Lead
Yup,
I think that's the simplest way to do it.
The one I often use is this:
select count(object_name) from all_objects where object_type like 'JAVA%'
and status='VALID';
It should return several thousand objects.
When Oracle docs refer to java being 'enabled' in the database they really
only
Scott - I agree with your advice. Could he take the bad datafile offline to
prevent Oracle from writing to it (until he rebuilds the table)? Would that
cause any other problems that I am overlooking?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL
Rob,
Just what the Dr. ordered.
Many thanks,
Cherie
Robert Pegram
Uh-oh... another urban legend?
ALTER DATABASE DATAFILE '...' OFFLINE DROP is not a command to drop a
datafile from the tablespace.
The file is be in the v$datafile and controlfile FOREVER even you issue
the offline drop command.
That command is only for you to put that datafile in the
Tim,
Thanks for all your help. I will check the
LAST_DDL_TIME field (although I didn't know what
INITIAL parameter can be modified) and will let you
know if something comes out of it.
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
Well! I'm out of ideas. The only other thing I can
think of is
We tried drop offline and it did not work. It appears that once the datafile
is accessed in any way, you can not get rid of it by dropping it. If there
is viable data, export it. Then drop the tablespace, rm the datafile(s)
(UNIX), re-create the tablespace, and then import the export (assuming
Not that I'm aware of. Sounds like an interesting idea, but one I've never
tried. I just told the users there was a hardware problem that necessitated
oracle coming down (whether there was one or not). Dishonest? Maybe, but
it bought me the brief, immediate downtime necessary to prevent more
As is often the case, rtfm. Should have dug deeper
first!
--- Peter Barnett [EMAIL PROTECTED] wrote:
We have a developer who has asked this question.
How
do you call an external java class from a pl/sql
stored procedure?
You can stick my knowledge of java in a thimble.
Can
this be
Hi, Pete,
PL/SQL has an interface to built-in Oracle JServer. You can load external
class here and call it, but at this point class is not external anymore,
right?
If you need access to the class on a different JVM - true external class,
Java provides you RMI, EJB, Corba interfaces. Oracle
It's not just grants. Any procedure that references that table will have to be
recreated, oracle uses object_id not object_name so the procedure will point to
the old table etc etc
you CAN try to resize the datafile down to something really small, smaller than
the smallest extent if possible,
Hi
I am getting ORA-60: Deadlock detected error.I know this is the
deadlock situation.But my question is how to correct this problem.
Thx
-Seema
_
Join the worlds largest e-mail service with MSN Hotmail.
ashoke,
that's going to corrupt his database.. at some point. If you do that, you'd
better be willing to immediately shutdown, recreate the tablespace and then do a
backup
|+-
|| |
||
there is a hardware problem that necessitated Oracle coming down. the only
question is does the database come down cleanly when YOU want it to or does it
come down with a crash, time undetermined, when the file is accessed?
|+---
||
Hey Prakash,
I never knew about that dictionary table, so I looked it up and found...
These views describe tables that have been modified since the last time
table statistics were gathered on them. The views are populated only for
tables with the MONITORING attribute. They are not populated
Rachel,
you said
It's not just grants. Any procedure that references that table will have
to be
recreated, oracle uses object_id not object_name so the procedure will point
to
the old table etc etc
Can't he just re-compile the procedures? He doesn't have to re-create them.
Tom Mercadante
Tom,
Or,
- create a new tablespace
- ALTER TABLE {table_name} MOVE {new_tablespace)
- alter index {all indexes that belong to this table) rebuild
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, May 15, 2002 1:49 PM
To: Multiple
Seema:
Post the deadlock graph. We will be able to help you.
THe deadlock graph will be in the trace file under udump
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 12:48 AM
Exactly my point. The answer is 42.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to drop a datafile from a
kick the power cable to your server...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Deadlock ORA-60
Hi
I am getting
the problem is in the application code... find the sql (it's in the trace files)
and start from there
|+---
|| |
|| |
|| oracledbam@ho|
|| tmail.com|
||
We have ORACLE 8.1.7.2 version running on SUn Solaris. The ORACLE running
under archive log mode. everytime we use Sql*loader to load data, it
will generate a lot of archive logs. Does their has way to make
sql*loader run under nologging mode?
Thanks.
You should find a .trc file related to this event in your USER_DUMP_DEST.
This file should include the names of the objects involved as well as the
offending SQL statements (I think -- it's been a while).
Hopefully, you can backtrack from the SQL statements to find the offending
application
Scott,
Did you hear that Douglas Adams was asked recently (i.e. a few years ago)
how he knew the Hubble Constant was (roughly) 42, back when he wrote the
Hitchhiker's Guide To The Galaxy series back in the 60s and 70s? The
Hubble Constant (having to do with the rate of expansion of the
no you can't recompile them... I tried that once, the recompiled procedure
referenced the renamed (old) table
it's the object_id thing. Oracle doesn't care what you name or rename an object,
it tracks it by the object_id.
Trust me, it screwed up triggers etc. real pita
Chris, this table was modified around 3am and I checked this view around
10am. Maybe I need to create a TAR.
Prakash
-Original Message-
Sent: Wednesday, May 15, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
Hey Prakash,
I never knew about that dictionary table, so I looked it
On Wed, May 15, 2002 at 12:03:22PM -0800, [EMAIL PROTECTED] wrote:
kick the power cable to your server...
Scott Shafer
San Antonio, TX
210-581-6217
whoa, talk about attack of the clones...take a break, man.
===
Ray Stell [EMAIL
I decided to create the RBSs in an 8.1.7 DB (HP/UX 11.0) in an LMT. I
remember having to do the trick of creating a temporary RBS in a non-LMT TS
first, then delete it when the others were created. Anyway, as I'm doing
some spot checking, I see about 1000 wraps on each of the RBSs in this
I did not know that.
Didn't Douglas Adams recently adjourn to the right hand of Hubble, there to
claim his 42 virgins in Paradise?
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Tim Gorman [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:38 PM
To:
Bad week. Extra cranky today. You do have to admit, it would solve the
problem...
--Scott
-Original Message-
From: Ray Stell [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Deadlock ORA-60
On Wed, May
true -- but 99% of the time, it's in the application code (and you listed 4, not
3, additional reasons :) )
|+---
|| |
|| |
|| kaygopal@yaho|
|| o.com|
|
Command line option DIRECT=Y
Control file option UNRECOVERABLE
--- dist cash [EMAIL PROTECTED] wrote:
We have ORACLE 8.1.7.2 version running on SUn
Solaris. The ORACLE running
under archive log mode. everytime we use
Sql*loader to load data, it
will generate a lot of archive logs. Does
So, if you haven't had any ORA-01555s, why would you worry?
Is V$WAITSTAT showing any (significant) time spent waiting on UNDO
anything? Are there any indications of problems?
If it ain't broke, don't buy trouble...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I did not know that.
We're not worthy! We're not worthy!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 3:13 PM
I did not know that.
Didn't Douglas Adams recently adjourn to the right hand of Hubble, there
to
From Doc ID: 203003.996
--
DBMS_STATS.GATHER_XXX_STATS
Unfortunately, there is no fix in Oracle8i.
The workaround was so make sure you supply a valid value for the
granularity parameter.
--
So, is GLOBAL valid or is this thing completely fubar in 8i?
Does anybody has script to delete old archive logs on NT when the disk
reaches certain percentage.
Please let me know
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arun Chakrapani
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
1 - 100 of 126 matches
Mail list logo