date:20020515


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]
Sent: Wednesday, May 15, 2002 4:58 PM


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 I
am on windoze??

Dave

-Original Message-
Sent: Tuesday, May 14, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L



$ORACLE_HOME/rdbms/mesg/oraus.msg does list events, for example:

10046, 0, enable SQL statement timing
// *Cause:
// *Action:

Most events are in the range of 1 to 10999.

Suzy


[EMAIL PROTECTED] wrote:

 actually that's the list of error messages, not events

 and it's not under the admin directory in any case the path to the error
 messages is:

 $ORACLE_HOME/rdbms/mesg/roaus.msg

 |+---
 ||   |
 ||   |
 ||  Rajendra.Jamadagn|
 ||  [EMAIL PROTECTED]   |
 ||   |
 ||  05/14/2002 04:23 |
 ||  PM   |
 ||  Please respond to|
 ||  ORACLE-L |
 ||   |
 |+---
   |
   ||
   |   To: [EMAIL PROTECTED] |
   |   cc: (bcc: Rachel Carmichael) |
   |   Subject: RE: list of events  |
   |

 $ORACLE_HOME/rdbms/admin/mesg/oraus.msg

 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 opinion is an art!

  -Original Message-
  From: Babu Nagarajan [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 14, 2002 3:48 PM
  To: Multiple recipients of list ORACLE-L
  Subject: list of events

  All

  I know this has been mentioned on this list before but I forget...

  Which is the script in $ORACLE_HOME/rdbms/admin folder that contains
the
  list of all events?

  TIA

  Babu(See attached file: ESPN_Disclaimer.txt)

   
  Name: ESPN_Disclaimer.txt
ESPN_Disclaimer.txt   Type: Plain Text (text/plain)
  Encoding: base64
   Description: Text - character set unknown
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the

Forms

2002-05-15 Thread systems_ho/VGIL


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 forms independant
of the monitor resolution.

Regards
Systems.


-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: grant sysdba rights

2002-05-15 Thread Peter Gram




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 ORA_DBA group, thenconnect / as sysdba and grant the rights.
  
-Oorspronkelijk bericht-Van:	Peter Gram [SMTP:[EMAIL PROTECTED]]Verzonden:	woensdag 15 mei 2002 12:49Aan:	Multiple recipients of list ORACLE-LOnderwerp:	Re: grant sysdba rightsThe 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 privilegesthis group is then compiled and linked into the Oracle executable.When member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userNT :Since it is not possible to relink the code on NT the group is hard coded to "ORA_DBA" on NT/W2KWhen member of this group you can connect with "/ as sysdba" and from there grant sysdba to the userVMS :Here it is a system logical that i don't remember 
the name off ( Michael /  Mogens pleas help )When having this logical set you can connect with "/ as sysdba" and from there grant sysdba to the userMVS :Help ???[EMAIL PROTECTED] wrote:

  Hi listWhen 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 thesysdba role to other accounts ??thanksvr. gr.g.g. korrdw ict groningen

-- /regardsPeter GramMobil : +45 2527 7107Fax   : +45 4466 8856Miracle A/SKratvej 22760 Mlvhttp://miracleas.dk-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Peter Gram  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).



-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Mlv
http://miracleas.dk






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Strange problem with charactersets

2002-05-15 Thread v . schoen

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 PC with Oracle 8.1.7 client and here a the strange behaviours.

Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works:

NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15


Windows 2000 territory settings are all to german.


All infos are welcome.


Volker Schoen
E-Mail: [EMAIL PROTECTED]
http://www.inplan.de

RE: list of events




yeah, but it's confusing when you look at that file...




|+---
||   |
||   |
||  Rajendra.Jamadagn|
||  [EMAIL PROTECTED]   |
||   |
||  05/14/2002 05:43 |
||  PM   |
||  Please respond to|
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: list of events  |
  |




Rachel,

Actually, error messages between 1 and 10999 are events (i.e. 10046,
10053 etc). In 9i there are some new events in the 297xx range as well.

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 opinion is an art!


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L



actually that's the list of error messages, not events

and it's not under the admin directory in any case the path to the error
messages is:

$ORACLE_HOME/rdbms/mesg/roaus.msg
(See attached file: ESPN_Disclaimer.txt)




ESPN_Disclaimer.txt
Description: Text - character set unknown

How to translate PL/SQL to C

2002-05-15 Thread Bernard, Gilbert


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) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: list of events




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 there with a Windows installation who can check this please?

And, in any case, the file just tells you what the event name is:

bash$ oerr ora 10053
10053, 0, CBO Enable optimizer trace
// *Cause:
// *Action:
bash$ oerr ora 10046
10046, 0, enable SQL statement timing
// *Cause:
// *Action:

and doesn't give you much other information. I'd love to see an Oracle doc just
on these events

Rachel



|+---
||   |
||   |
||  Rajendra.Jamadagn|
||  [EMAIL PROTECTED]   |
||   |
||  05/14/2002 05:43 |
||  PM   |
||  Please respond to|
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: list of events  |
  |




Rachel,

Actually, error messages between 1 and 10999 are events (i.e. 10046,
10053 etc). In 9i there are some new events in the 297xx range as well.

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 opinion is an art!


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L



actually that's the list of error messages, not events

and it's not under the admin directory in any case the path to the error
messages is:

$ORACLE_HOME/rdbms/mesg/roaus.msg
(See attached file: ESPN_Disclaimer.txt)




ESPN_Disclaimer.txt
Description: Text - character set unknown

Re: Strange problem with charactersets

2002-05-15 Thread Nicolai Tufar

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: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, May 15, 2002 4:13 
  PM
  Subject: 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 PC with Oracle 8.1.7 client and 
  here a the strange behaviours.
  Oracle 8.1.7 client shows instead of öäüß (german special 
  characters) oau?. I've never seen this. Normally the special characters would 
  be shown as unreadable signs. On client we tried these different NLS settings, 
  but nothing works:
  NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 
  Windows 2000 territory settings are all to german. 
  
  All infos are welcome. 
  Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

Re: Order rows




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 order by ins_date




|+--
||  |
||  |
||  systems_ho/VGIL@vguard.sat|
||  yam.net.in  |
||  |
||  05/15/2002 02:08 AM |
||  Please respond to ORACLE-L  |
||  |
|+--
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Order rows  |
  |




Hi All

Is there any method in Oracle to capture or order the rows in a table in
the order they were entered.
I tried it with rowid but when a row is deleted, the rowid corresponding to
this row is reassigned for a new row
which is inserted into the table at a later stage.

Eg.

SQL select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB200
AAAFmYAASAAAYsqAAC300

I deleted one transaction.

delete from abc where a=200;
commit;

Then I inserted two rows.

insert into abc values(500);
insert into abc values(600);
commit;

Now when I order by rowid

SQL  select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB600
AAAFmYAASAAAYsqAAC300
AAAFmYAASAAAYsqAAD500

I.e The values I entered last appeared second.The rowid (AAAFmYAASAAAYsqAAB
) corresponding to the row I deleted was reassigned for the last entered
row (a=600).
What I want is that this must be sorted in the order of its entry.
Can anyone help me out.
Thanks in advance
Systems.


--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: extents allocation in parallel load

2002-05-15 Thread Gurelei


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 well...


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Strange problem with charactersets

2002-05-15 Thread Szecsy Tamas

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
conversion between the client and the database. If the characters are still
displayed in a bad fashon on the client side, then data in the database is not
correct andyou have to reloadit.

HTH,

Tamas Szecsy

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 3:13
PMTo: Multiple recipients of list ORACLE-LSubject:
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 PC with Oracle 8.1.7 client and
here a the strange behaviours.
Oracle 8.1.7 client shows instead of öäüß (german special
characters) oau?. I've never seen this. Normally the special characters would
be shown as unreadable signs. On client we tried these different NLS settings,
but nothing works:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
Windows 2000 territory settings are all to german.

All infos are welcome.
Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

Basic Database Question

2002-05-15 Thread Gavin D'Mello

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 = c.contentid;

and if the table persusercontentassoc is empty no rows are 
returned. However, if i populate this table i get meaningful data.
So what i'm asking is if any one table in a select contains no 
data will the select always return no rows ?


Thanks,

Gavin

AW: Strange problem with charactersets

2002-05-15 Thread v . schoen

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]
http://www.inplan.de

-Ursprüngliche Nachricht-Von: Szecsy Tamas
[mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002
14:58An: [EMAIL PROTECTED]; Schoen VolkerBetreff: RE:
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 conversion between the client and the database. If the characters
are still displayed in a bad fashon on the client side, then data in the
database is not correct andyou have to
reloadit.

HTH,

Tamas Szecsy

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 3:13
PMTo: Multiple recipients of list ORACLE-LSubject:
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 PC with Oracle 8.1.7 client and
here a the strange behaviours.
Oracle 8.1.7 client shows instead of öäüß (german
special characters) oau?. I've never seen this. Normally the special
characters would be shown as unreadable signs. On client we tried these
different NLS settings, but nothing works:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
Windows 2000 territory settings are all to
german.
All infos are welcome.
Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

Re: Order rows


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 your method (additional column SYSDATE)

Best Regards,
K Gopalakrishnan
Bangalore, INDIA




- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 7:33 PM




 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 order by ins_date



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to translate PL/SQL to C


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, arithmetic, etc)
that C/C++ does better than PL/SQL, and some things (i.e. bulk data
movement, large-scale data manipulation within the database, etc) that
PL/SQL does far better than C/C++.

Just curious!  It sounds like a bad idea.  I just wanted to find out if it
is a bad idea based on a misunderstanding of the strong/weak points of each
language or whether it was based on some really wild and interesting
requirements.

And if you decide to go to C/C++ after all, have you given thought as to
whether you'll use the Precompilers or OCI/OCCI?

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 7:13 AM


 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) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bernard, Gilbert
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to translate PL/SQL to C

2002-05-15 Thread Stephane Faroult



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 understanding (I have never tried it) 
is that it turns PL/SQL code into a dynamically loadable library, and the fact that C 
was involved is a pure coincidence. Could have been Cobol as well.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to translate PL/SQL to C

2002-05-15 Thread Igor Neyman


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 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) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Bernard, Gilbert
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

AW: Strange problem with charactersets

2002-05-15 Thread v . schoen

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 Tufar 
  [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002 
  16:03An: Multiple recipients of list ORACLE-LBetreff: 
  Re: 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: Multiple recipients of list ORACLE-L 

Sent: Wednesday, May 15, 2002 4:13 
PM
Subject: 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 PC with Oracle 8.1.7 client and 
here a the strange behaviours.
Oracle 8.1.7 client shows instead of öäüß (german 
special characters) oau?. I've never seen this. Normally the special 
characters would be shown as unreadable signs. On client we tried these 
different NLS settings, but nothing works:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 
Windows 2000 territory settings are all to 
german. 
All infos are welcome. 
Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

RE: list of events

2002-05-15 Thread Thomas Day



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 including tnsus.msq for SQL*Net error messages.  The msb files are
binary and are not easily readable.



   

Rachel_Carmic  

hael To: Multiple recipients of list ORACLE-L  

@Sonymusic.co[EMAIL PROTECTED]

mcc:   

Sent by: rootSubject: RE: list of events   

   

   

05/15/2002 

09:48 AM   

Please 

respond to 

ORACLE-L   

   

   







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 there with a Windows installation who can check this please?

And, in any case, the file just tells you what the event name is:

bash$ oerr ora 10053
10053, 0, CBO Enable optimizer trace
// *Cause:
// *Action:
bash$ oerr ora 10046
10046, 0, enable SQL statement timing
// *Cause:
// *Action:

and doesn't give you much other information. I'd love to see an Oracle doc
just
on these events

Rachel



|+---
||   |
||   |
||  Rajendra.Jamadagn|
||  [EMAIL PROTECTED]   |
||   |
||  05/14/2002 05:43 |
||  PM   |
||  Please respond to|
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: list of events  |
  |




Rachel,

Actually, error messages between 1 and 10999 are events (i.e. 10046,
10053 etc). In 9i there are some new events in the 297xx range as well.

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 opinion is an art!


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L



actually that's the list of error messages, not events

and it's not under the admin directory in any case the path to the error
messages is:

$ORACLE_HOME/rdbms/mesg/roaus.msg
(See attached file: ESPN_Disclaimer.txt)



 Attachment Removed : ESPN_Disclaimer.txt 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Strange problem with charactersets

2002-05-15 Thread Szecsy Tamas

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 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 4:03 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  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: Multiple 
recipients of list ORACLE-L 
Sent: Wednesday, May 15, 2002 4:13 
PM
Subject: 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 PC with Oracle 8.1.7 client and 
here a the strange behaviours.
Oracle 8.1.7 client shows instead of öäüß (german 
special characters) oau?. I've never seen this. Normally the special 
characters would be shown as unreadable signs. On client we tried these 
different NLS settings, but nothing works:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 
Windows 2000 territory settings are all to 
german. 
All infos are welcome. 
Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

RE: How to translate PL/SQL to C

2002-05-15 Thread Khedr, Waleed


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


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
understanding (I have never tried it) is that it turns PL/SQL code into a
dynamically loadable library, and the fact that C was involved is a pure
coincidence. Could have been Cobol as well.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Basic Database Question

2002-05-15 Thread Jack van Zanen



Hi,


Outer joins can still return rows when no match exists(or empty)

Jack


   

  Gavin D'Mello  

  [EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
  n   cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  Basic Database Question   

  [EMAIL PROTECTED] 

   

   

  15-05-2002 16:03 

  Please respond to

  ORACLE-L 

   

   




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 t
where
t.contentid = c.contentid OR
p.contentid = c.contentid;

and if the table persusercontentassoc is empty no rows are returned.
However, if i populate this table i get meaningful data.
So what i'm asking is if any one table in a select contains no data will
the select always return no rows ?


Thanks,

Gavin



==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
===


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED]

RE: list of events

2002-05-15 Thread Cary Millsap


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 list ORACLE-L



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 there with a Windows installation who can check this please?

And, in any case, the file just tells you what the event name is:

bash$ oerr ora 10053
10053, 0, CBO Enable optimizer trace
// *Cause:
// *Action:
bash$ oerr ora 10046
10046, 0, enable SQL statement timing
// *Cause:
// *Action:

and doesn't give you much other information. I'd love to see an Oracle
doc just
on these events

Rachel



|+---
||   |
||   |
||  Rajendra.Jamadagn|
||  [EMAIL PROTECTED]   |
||   |
||  05/14/2002 05:43 |
||  PM   |
||  Please respond to|
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: list of events  |
  |




Rachel,

Actually, error messages between 1 and 10999 are events (i.e. 10046,
10053 etc). In 9i there are some new events in the 297xx range as well.

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 opinion is an art!


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L



actually that's the list of error messages, not events

and it's not under the admin directory in any case the path to the error
messages is:

$ORACLE_HOME/rdbms/mesg/roaus.msg
(See attached file: ESPN_Disclaimer.txt)


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}

2002-05-15 Thread Grabowy, Chris


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 hate 9i.

And then Oracle announces a new version and I'm back in the school of
wishingoh please

-Original Message-
Sent: Tuesday, May 14, 2002 11:03 PM
To: Multiple recipients of list ORACLE-L


Chris, i'm of the school of thought, UNTIL I use it and see it work, its 
vaporware.

joe


Grabowy, Chris wrote:

 And constraintsand DBAs can revoke/grant other schemas objects

 -Original Message-
 *From:* Toepke, Kevin M [mailto:[EMAIL PROTECTED]]
 *Sent:* Tuesday, May 14, 2002 3:48 PM
 *To:* Multiple recipients of list ORACLE-L
 *Subject:* RE: {9i New Features: Online Reorg or DBMS_REDEFINITION
 Package}

 A quick followup to this...

  

 I've done some testing of this package and concur with Joe. Its
 kewl. Outside of renaming a column, it can be used to quickly
 partition a non-partitioned table. Its much faster and easier than
 using exchange partition.

  

 The 9iR2 new features whitepaper hints at a native rename column
 command.

  

 Caver

 -Original Message-
 *From:* JOE TESTA [mailto:[EMAIL PROTECTED]]
 *Sent:* Tuesday, May 14, 2002 2:58 PM
 *To:* Multiple recipients of list ORACLE-L
 *Subject:* {9i New Features: Online Reorg or DBMS_REDEFINITION
 Package}

 Welcome to the next installment of 9i New Features, today's
 topic is Online changes of objects, specifically we'll cover
 the new package called DBMS_REDEFINITION.

  

 The spec for this package is located where all of the other
 package sources are:

  

 ORACLE_HOME/rdbms/admin.  The file is dbmshord.sql

  

 So what does this package give us?  Well it gives the
 capability to do online reorganization of a table.  Ok so now
 if you're not confused, you should be :)


 In easy to understand terms, in the past when you wanted to
 move a table to a new tablespace, drop a column, add a column,
 change a column datatype, it require a exclusive lock on the
 table during the operation(which if it was a large table could
 lock it up for a long time).  Well that is no longer the case,
 those kinds of changes can be done while DML is still being
 applied to the object. 

  

 Let's take for an example something that all of us have been
 asking for YEARS, the rename of a column.

  

 Look at this code, I've included comments within it so its
 pretty much self-explanatory and you can run it against your
 9i database to see what if it really works.

  


 --   BEGINNING OF SCRIPT
 ---

  


 set serveroutput on size 10;

  

 -- let's drop a couple of tables so if we re-run we won't get
 errors
 drop table sales;
 drop table sales_temp;

  

 -- create a new table, handful of columns with the last one
 named incorrectly.

  

 create table sales
 (sales_id number not null,
  sales_amount number(10,2) not null,
  salesman_id number(5) not null,
  tax_amount number(5,2) not null,
  bad_column_name varchar2(20) not null);

  

 -- add a PK since for online reorg it's required

  

 alter table sales add primary key(sales_id)-

  

 -- insert some data

 insert into sales values(1,20,4,5.70,'bogus');
 insert into sales values(2,30,6,6.70,'no way');
 insert into sales values(3,40,7,7.70,'XX way');
 insert into sales values(4,50,8,8.70,'YY way');
 insert into sales values(5,60,9,9.70,'ZZ way');
 insert into sales values(6,70,1,0.70,'AA way');
 insert into sales values(7,80,2,1.70,'BB way');
 insert into sales values(8,90,3,2.70,'CC way');
 insert into sales values(9,10,4,3.70,'DD way');
 insert into sales values(10,25,5,4.70,'EE way');

  

 -- commit the data

  

 commit;

  


 -- run the proc to see if this table can be reorganized
 online, if we get an error,
 --then its not possible, otherwise we're good to go.

  

 execute dbms_redefinition.can_redef_table(USER,'SALES');

  


 -- we must create the temp table for this reorg to happen
 manually, either with a
 --create table statement or via a create table as

RE: Order rows


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 sequence number.  There is no other way to guarantee
this.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, May 15, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L


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 your method (additional column SYSDATE)

Best Regards,
K Gopalakrishnan
Bangalore, INDIA




- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 7:33 PM




 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 order by ins_date



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Order rows




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




|+---
||   |
||   |
||  ktoepke@trile|
||  giant.com|
||   |
||  05/15/2002   |
||  11:13 AM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: Order rows  |
  |




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]]
Sent: Wednesday, May 15, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L




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 order by ins_date




|+--
||  |
||  |
||  systems_ho/VGIL@vguard.sat|
||  yam.net.in  |
||  |
||  05/15/2002 02:08 AM |
||  Please respond to ORACLE-L  |
||  |
|+--
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Order rows  |
  |




Hi All

Is there any method in Oracle to capture or order the rows in a table in
the order they were entered.
I tried it with rowid but when a row is deleted, the rowid corresponding to
this row is reassigned for a new row
which is inserted into the table at a later stage.

Eg.

SQL select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB200
AAAFmYAASAAAYsqAAC300

I deleted one transaction.

delete from abc where a=200;
commit;

Then I inserted two rows.

insert into abc values(500);
insert into abc values(600);
commit;

Now when I order by rowid

SQL  select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB600
AAAFmYAASAAAYsqAAC300
AAAFmYAASAAAYsqAAD500

I.e The values I entered last appeared second.The rowid (AAAFmYAASAAAYsqAAB
) corresponding to the row I deleted was reassigned for the last entered
row (a=600).
What I want is that this must be sorted in the order of its entry.
Can anyone help me out.
Thanks in advance
Systems.


--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other

java enabled?

2002-05-15 Thread Ray Stell



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 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to translate PL/SQL to C

2002-05-15 Thread Peter Barnett


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
 
 
 
   -- 
   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 Internet
 access / Mailing
 Lists
 


   To REMOVE yourself from this mailing list, send an
 E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
   the message BODY, include a line containing: UNSUB
 ORACLE-L
   (or the name of mailing list you want to be removed
 from).  You may
   also send the HELP command for other information
 (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Bernard, Gilbert
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Order rows




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 space freed up by
deleted rows :)




|+---
||   |
||   |
||  kaygopal@yaho|
||  o.com|
||   |
||  05/15/2002   |
||  10:28 AM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re: Order rows  |
  |




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 your method (additional column SYSDATE)

Best Regards,
K Gopalakrishnan
Bangalore, INDIA




- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 7:33 PM




 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 order by ins_date



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to translate PL/SQL to C

2002-05-15 Thread torben . holm

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: Stephane Faroult[EMAIL PROTECTED]
Subject: RE: How to translate PL/SQL to C

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 understanding
(I have never tried it) is that it turns PL/SQL code into a dynamically
loadable
library, and the fact that C was involved is a pure coincidence. Could
have
been Cobol as well.

Regards,

Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Torben Holm
Miracle A/S

Mobil : +45 2527 7104
[EMAIL PROTECTED]
http://miracleAS.dk

--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Order rows

2002-05-15 Thread Toepke, Kevin M


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]]
Sent: Wednesday, May 15, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L




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 order by ins_date




|+--
||  |
||  |
||  systems_ho/VGIL@vguard.sat|
||  yam.net.in  |
||  |
||  05/15/2002 02:08 AM |
||  Please respond to ORACLE-L  |
||  |
|+--
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Order rows  |
  |




Hi All

Is there any method in Oracle to capture or order the rows in a table in
the order they were entered.
I tried it with rowid but when a row is deleted, the rowid corresponding to
this row is reassigned for a new row
which is inserted into the table at a later stage.

Eg.

SQL select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB200
AAAFmYAASAAAYsqAAC300

I deleted one transaction.

delete from abc where a=200;
commit;

Then I inserted two rows.

insert into abc values(500);
insert into abc values(600);
commit;

Now when I order by rowid

SQL  select rowid,abc.* from abc order by rowid;

ROWID   A
-- --
AAAFmYAASAAAYsqAAA100
AAAFmYAASAAAYsqAAB600
AAAFmYAASAAAYsqAAC300
AAAFmYAASAAAYsqAAD500

I.e The values I entered last appeared second.The rowid (AAAFmYAASAAAYsqAAB
) corresponding to the row I deleted was reassigned for the last entered
row (a=600).
What I want is that this must be sorted in the order of its entry.
Can anyone help me out.
Thanks in advance
Systems.


--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}

2002-05-15 Thread Vadim Gorbounov


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 ORACLE-L


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 hate 9i.

And then Oracle announces a new version and I'm back in the school of
wishingoh please

-Original Message-
Sent: Tuesday, May 14, 2002 11:03 PM
To: Multiple recipients of list ORACLE-L


Chris, i'm of the school of thought, UNTIL I use it and see it work, its 
vaporware.

joe


Grabowy, Chris wrote:

 And constraintsand DBAs can revoke/grant other schemas objects

 -Original Message-
 *From:* Toepke, Kevin M [mailto:[EMAIL PROTECTED]]
 *Sent:* Tuesday, May 14, 2002 3:48 PM
 *To:* Multiple recipients of list ORACLE-L
 *Subject:* RE: {9i New Features: Online Reorg or DBMS_REDEFINITION
 Package}

 A quick followup to this...

  

 I've done some testing of this package and concur with Joe. Its
 kewl. Outside of renaming a column, it can be used to quickly
 partition a non-partitioned table. Its much faster and easier than
 using exchange partition.

  

 The 9iR2 new features whitepaper hints at a native rename column
 command.

  

 Caver

 -Original Message-
 *From:* JOE TESTA [mailto:[EMAIL PROTECTED]]
 *Sent:* Tuesday, May 14, 2002 2:58 PM
 *To:* Multiple recipients of list ORACLE-L
 *Subject:* {9i New Features: Online Reorg or DBMS_REDEFINITION
 Package}

 Welcome to the next installment of 9i New Features, today's
 topic is Online changes of objects, specifically we'll cover
 the new package called DBMS_REDEFINITION.

  

 The spec for this package is located where all of the other
 package sources are:

  

 ORACLE_HOME/rdbms/admin.  The file is dbmshord.sql

  

 So what does this package give us?  Well it gives the
 capability to do online reorganization of a table.  Ok so now
 if you're not confused, you should be :)


 In easy to understand terms, in the past when you wanted to
 move a table to a new tablespace, drop a column, add a column,
 change a column datatype, it require a exclusive lock on the
 table during the operation(which if it was a large table could
 lock it up for a long time).  Well that is no longer the case,
 those kinds of changes can be done while DML is still being
 applied to the object. 

  

 Let's take for an example something that all of us have been
 asking for YEARS, the rename of a column.

  

 Look at this code, I've included comments within it so its
 pretty much self-explanatory and you can run it against your
 9i database to see what if it really works.

  


 --   BEGINNING OF SCRIPT
 ---

  


 set serveroutput on size 10;

  

 -- let's drop a couple of tables so if we re-run we won't get
 errors
 drop table sales;
 drop table sales_temp;

  

 -- create a new table, handful of columns with the last one
 named incorrectly.

  

 create table sales
 (sales_id number not null,
  sales_amount number(10,2) not null,
  salesman_id number(5) not null,
  tax_amount number(5,2) not null,
  bad_column_name varchar2(20) not null);

  

 -- add a PK since for online reorg it's required

  

 alter table sales add primary key(sales_id)-

  

 -- insert some data

 insert into sales values(1,20,4,5.70,'bogus');
 insert into sales values(2,30,6,6.70,'no way');
 insert into sales values(3,40,7,7.70,'XX way');
 insert into sales values(4,50,8,8.70,'YY way');
 insert into sales values(5,60,9,9.70,'ZZ way');
 insert into sales values(6,70,1,0.70,'AA way');
 insert into sales values(7,80,2,1.70,'BB way');
 insert into sales values(8,90,3,2.70,'CC way');
 insert into sales values(9,10,4,3.70,'DD way');
 insert into sales values(10,25,5,4.70,'EE way');

  

 -- commit the data

  

 commit;

  


 -- run the proc to see if this table can be reorganized
 online, if we get an error,
 --

Re: Order rows


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 PCTUSED to absolutely low value so that the used blocks never
linked to freelist chain. So everytime you look for a space you go for a
virgin
block. THe space reclaimed by any DELETEs never returns to freelists .

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 8:58 PM


 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 sequence number.  There is no other way to guarantee
 this.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Wednesday, May 15, 2002 10:28 AM
 To: Multiple recipients of list ORACLE-L


 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 your method (additional column SYSDATE)

 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA




 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, May 15, 2002 7:33 PM


 
 
  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 order by ins_date
 


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Order rows

2002-05-15 Thread Jamadagni, Rajendra


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 here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Wednesday, May 15, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L


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


***1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and 
delete this e-mail message from your computer, Thank you.

***1

Re: extents allocation in parallel load


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 -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 8:13 AM


 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 well...


 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Gurelei
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Order rows


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 it is still a trick depending
on how Oracle internals works.  In a year, this may change, and it may not
work any more, in which case, the application no longer works correctly.

It may be an option, but a poor one at best.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, May 15, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L


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 PCTUSED to absolutely low value so that the used blocks never
linked to freelist chain. So everytime you look for a space you go for a
virgin
block. THe space reclaimed by any DELETEs never returns to freelists .

Best Regards,
K Gopalakrishnan
Bangalore, INDIA


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 8:58 PM


 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 sequence number.  There is no other way to guarantee
 this.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Wednesday, May 15, 2002 10:28 AM
 To: Multiple recipients of list ORACLE-L


 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 your method (additional column SYSDATE)

 Best Regards,
 K Gopalakrishnan
 Bangalore, INDIA




 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, May 15, 2002 7:33 PM


 
 
  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 order by ins_date
 


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: K Gopalakrishnan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing

What does this phrase mean?

2002-05-15 Thread KENNETH JANUSZ




"single source (HTML)"

Thanks,
Ken Janusz, CPIM

Unsetting OPTIMAL in rollback segments

2002-05-15 Thread Cherie_Machler



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 references to bug 228441.   Following is
one such reference.   Sounds like one part of the work-around is to unset
OPTIMAL which we do currently have set.   I've looked through the docs and
Metalink.   I do see text for altering the OPTIMAL value but I don't see
any reference to unsetting OPTIMAL.   Is there a way to unset optimal in
rollback segments that are currently online?   Or do I have to create a
bunch of new rollback segments from scratch without OPTIMAL specified and
then roll them in and roll out the existing rollback segments.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network



   
  
 From: Oracle, Tom 
Villane   
 21-Sep-01 21:20   
  
 Subject: Re : 
ORA-01581, but
 seem to have more 
than enough   
 space 
  
   
  
   
  
   
  
 Hi,   
  
   
  
 The ORA-01581 is not 
normally   
 seen in Oracle8. Bug 
228441 has 
 an explanation of why 
it can
 happen.   
  
 This can happen when 
we are
 trying to extend a 
rollback 
 segment. We try to 
extend the   
 rollback segment when 
we cannot 
 wrap into the next 
extent and   
 we are near the end 
of the  
 current extent. When 
we try to  
 allocate the new 
extent we  
 generate undo, in 
addition, 
 space management may 
generate   
 undo to do a 
coalesce. If the   
 amount of undo we 
generate  
 cannot fit in the 
current   
 extent we will get a 
1581 as we 
 are now trying to use 
the   
 extent that we are 
trying to
 add. 
  
   
  
 Suggestions for 
resolving the   
 problems are to make 
the
 INITIAL EXTENTS a 
large number  
 ( maybe even set 
minextents =   
 maxextents), and 
unset OPTIMAL  
   
  
   
  
 Regards

How to drop a datafile from a tablespace quickly

2002-05-15 Thread Xie, Tom


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 
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to 
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that. 

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: java enabled?

2002-05-15 Thread Boivin, Patrice J


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 ORACLE-L
Subject:java enabled?


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 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Dba_tab_modifications question

2002-05-15 Thread BALA,PRAKASH (Non-HP-USA,ex1)


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 this table.

  1  select inserts,updates,deletes from dba_tab_modifications
  2* where table_name = 'NOTES_LOG'
WFM_ADMIN@VGRAFO /

   INSERTSUPDATESDELETES
   ---- ---
  6509  0   0

WFM_ADMIN@VGRAFO select count(*) from notes_log;

  COUNT(*)
--
   1592488

The difference between yesterday's and today's count is 6791 which does not
match the number in dba_tab_modifications. 

Does this mean that I cannot rely on dba_tab_modifications?


TIA
Prakash
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BALA,PRAKASH (Non-HP-USA,ex1)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly


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.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Xie, Tom [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  How to drop a datafile from a tablespace quickly
 
 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 
 tablespace. As I know, to drop a data file, I have to export the data,
 drop the tablespace and recreate it, and then import data back to 
 the tablespace. However, since our users can't stop using the table,
 I won't have enough down time to do that. 
 
 Is there anyway I can quickly drop a data file from a tablespace?
 
 Don't tell me using alter database datafile '...' offline drop command.
 It won't work.
 
 I am working on Oracle 7.3.4.
 
 Thanks,
 
 Tom Xie
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Xie, Tom
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unsetting OPTIMAL in rollback segments

2002-05-15 Thread Robert Pegram


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
-- --
SYSTEM
RBS0  4194304
RBS1  4194304
RBS2  4194304
RBS3  4194304
RBS4  4194304
RBS5  4194304
RBS6  4194304

8 rows selected.

SQL alter rollback segment rbs0 storage(optimal
null);

Rollback segment altered.

SQL  select segment_name, optsize
  2   from dba_rollback_segs, v$rollstat
  3  where usn=segment_id;

SEGMENT_NAME  OPTSIZE
-- --
SYSTEM
RBS0
RBS1  4194304
RBS2  4194304
RBS3  4194304
RBS4  4194304
RBS5  4194304
RBS6  4194304

8 rows selected.

--- [EMAIL PROTECTED] wrote:
 
 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 references to bug
 228441.   Following is
 one such reference.   Sounds like one part of the
 work-around is to unset
 OPTIMAL which we do currently have set.   I've
 looked through the docs and
 Metalink.   I do see text for altering the OPTIMAL
 value but I don't see
 any reference to unsetting OPTIMAL.   Is there a
 way to unset optimal in
 rollback segments that are currently online?   Or do
 I have to create a
 bunch of new rollback segments from scratch without
 OPTIMAL specified and
 then roll them in and roll out the existing rollback
 segments.
 
 Thanks,
 
 Cherie Machler
 Oracle DBA
 Gelco Information Network
 
 
 
 
 
 
 From: Oracle, Tom Villane   
 
 21-Sep-01 21:20 
 
 Subject: Re : ORA-01581, but
 
 seem to have more than enough   
 
 space   
 
 
 
 
 
 
 
 Hi, 
 
 
 
 The ORA-01581 is not normally   
 
 seen in Oracle8. Bug 228441 has 
 
 an explanation of why it can
 
 happen. 
 
 This can happen when we are
 
 trying to extend a rollback 
 
 segment. We try to extend the   
 
 rollback segment when we cannot 
 
 wrap into the next extent and   
 
 we are near the end of the  
 
 current extent. When we try to  
 
 allocate the new extent we  
 
 generate undo, in addition, 
 
 space management may generate   
 
 undo to do a coalesce. If the   
 
 amount of undo we generate  
 
 cannot fit in the current

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Xie, Tom



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.
--

\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
   (@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
   /   V  \   Oracle Database Administrator`~`~
  o--m-m--o  Infonet Services Corporation `~`~
   #   mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~



 

  Xie, Tom

  [EMAIL PROTECTED]To:   Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  om  cc:

  Sent by: Subject:  How to drop a
datafile from a tablespace quickly   
  [EMAIL PROTECTED]

 

 

  05/15/02 09:58 AM

  Please respond to

  ORACLE-L

 

 





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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a data file from a tablespace quickly

2002-05-15 Thread Mandal, Ashoke



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 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 
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to 
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that. 

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread Winnie_Liu



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
--

\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
   (@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
   /   V  \   Oracle Database Administrator`~`~
  o--m-m--o  Infonet Services Corporation `~`~
   #   mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~



   
 
  Xie, Tom   
 
  [EMAIL PROTECTED]To:   '[EMAIL PROTECTED]' 
[EMAIL PROTECTED]
  om  cc:   '[EMAIL PROTECTED]' 
[EMAIL PROTECTED]
   Subject:  RE: How to drop a datafile 
from a tablespace quickly   
  05/15/02 09:32 AM
 
   
 
   
 





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.
--

\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
   (@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
   /   V  \   Oracle Database Administrator`~`~
  o--m-m--o  Infonet Services Corporation `~`~
   #   mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~





  Xie, Tom

  [EMAIL PROTECTED]To:   Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
  om  cc:

  Sent by: Subject:  How to drop a
datafile from a tablespace quickly
  [EMAIL PROTECTED]





  05/15/02 09:58 AM

  Please respond to

  ORACLE-L









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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:How to drop a datafile from a tablespace quickly

2002-05-15 Thread dgoulet


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 the original table and
tablespace, and then rename the table back to it's old name.  Don't forget the
grants as well.

Dick Goulet

Reply Separator
Author: Xie; Tom [EMAIL PROTECTED]
Date:   5/15/2002 8:58 AM

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 
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to 
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that. 

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Calling an External Java Class from PL/SQL

2002-05-15 Thread Peter Barnett


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 Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: java enabled?

2002-05-15 Thread Hately Mike


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 mean 'have the objects been loaded and are they valid?'.

Cheers,
Mike Hately



-Original Message-
Sent: 15 May 2002 18:08
To: Multiple recipients of list ORACLE-L


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 ORACLE-L
Subject:java enabled?


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 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly

2002-05-15 Thread DENNIS WILLIAMS


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 PROTECTED]]
Sent: Wednesday, May 15, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


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.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: Xie, Tom [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 11:58 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  How to drop a datafile from a tablespace quickly
 
 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 
 tablespace. As I know, to drop a data file, I have to export the data,
 drop the tablespace and recreate it, and then import data back to 
 the tablespace. However, since our users can't stop using the table,
 I won't have enough down time to do that. 
 
 Is there anyway I can quickly drop a data file from a tablespace?
 
 Don't tell me using alter database datafile '...' offline drop command.
 It won't work.
 
 I am working on Oracle 7.3.4.
 
 Thanks,
 
 Tom Xie
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Xie, Tom
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unsetting OPTIMAL in rollback segments

2002-05-15 Thread Cherie_Machler



Rob,

Just what the Dr.  ordered.

Many thanks,

Cherie


   
  
Robert Pegram  
  
pegramrg@yaho   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
o.com   cc:   
  
Sent by: Subject: Re: Unsetting OPTIMAL in 
rollback segments 
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
05/15/02 12:38 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




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
-- --
SYSTEM
RBS0  4194304
RBS1  4194304
RBS2  4194304
RBS3  4194304
RBS4  4194304
RBS5  4194304
RBS6  4194304

8 rows selected.

SQL alter rollback segment rbs0 storage(optimal
null);

Rollback segment altered.

SQL  select segment_name, optsize
  2   from dba_rollback_segs, v$rollstat
  3  where usn=segment_id;

SEGMENT_NAME  OPTSIZE
-- --
SYSTEM
RBS0
RBS1  4194304
RBS2  4194304
RBS3  4194304
RBS4  4194304
RBS5  4194304
RBS6  4194304

8 rows selected.

--- [EMAIL PROTECTED] wrote:

 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 references to bug
 228441.   Following is
 one such reference.   Sounds like one part of the
 work-around is to unset
 OPTIMAL which we do currently have set.   I've
 looked through the docs and
 Metalink.   I do see text for altering the OPTIMAL
 value but I don't see
 any reference to unsetting OPTIMAL.   Is there a
 way to unset optimal in
 rollback segments that are currently online?   Or do
 I have to create a
 bunch of new rollback segments from scratch without
 OPTIMAL specified and
 then roll them in and roll out the existing rollback
 segments.

 Thanks,

 Cherie Machler
 Oracle DBA
 Gelco Information Network






 From: Oracle, Tom Villane

 21-Sep-01 21:20

 Subject: Re : ORA-01581, but

 seem to have more than enough

 space







 Hi,



 The ORA-01581 is not normally

 seen in Oracle8. Bug 228441 has

 an explanation of why it can

 happen.

 This can happen when we are

 trying to extend a rollback

 segment. We try to extend the

 rollback segment when we cannot

 wrap into the next extent and

 we are near the end of the

 current extent. When we try to

 allocate the new extent we

 generate undo, in addition,

 space management may generate

 undo to do a coalesce. If the

 amount of undo we generate

 cannot fit in the current

 extent we will get a 1581 as we

 are now trying to use the

 extent that we are trying to

Re: How to drop a data file from a tablespace quickly

2002-05-15 Thread Suzy Vordos



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 RECOVERY mode
and tell Oracle that you will recovery that file later.

You will HAVE TO DROP THAT TABLESPACE if you cannot recover that file.


Mandal, Ashoke wrote:
 
 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 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
 tablespace. As I know, to drop a data file, I have to export the data,
 drop the tablespace and recreate it, and then import data back to
 the tablespace. However, since our users can't stop using the table,
 I won't have enough down time to do that.
 
 Is there anyway I can quickly drop a data file from a tablespace?
 
 Don't tell me using alter database datafile '...' offline drop command.
 It won't work.
 
 I am working on Oracle 7.3.4.
 
 Thanks,
 
 Tom Xie
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Xie, Tom
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Mandal, Ashoke
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: extents allocation in parallel load

2002-05-15 Thread Gurelei


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 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 -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Wednesday, May 15, 2002 8:13 AM
 
 
  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 well...
 
 
  __
  Do You Yahoo!?
  LAUNCH - Your Yahoo! Music Experience
  http://launch.yahoo.com
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Gurelei
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


  To REMOVE yourself from this mailing list, send an
 E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
  the message BODY, include a line containing: UNSUB
 ORACLE-L
  (or the name of mailing list you want to be
 removed from).  You may
  also send the HELP command for other information
 (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Tim Gorman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a data file from a tablespace quickly

2002-05-15 Thread Sherman, Paul R.


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 you
did an export).

Thank you,

Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, May 15, 2002 1:44 PM
To: Multiple recipients of list ORACLE-L



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 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 
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to 
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that. 

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandal, Ashoke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly


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 serious
problems in the future.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:58 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: How to drop a datafile from a tablespace quickly
 
 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 PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 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.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, May 15, 2002 11:58 AM
  To: Multiple recipients of list ORACLE-L
  Subject:How to drop a datafile from a tablespace quickly
  
  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 
  tablespace. As I know, to drop a data file, I have to export the data,
  drop the tablespace and recreate it, and then import data back to 
  the tablespace. However, since our users can't stop using the table,
  I won't have enough down time to do that. 
  
  Is there anyway I can quickly drop a data file from a tablespace?
  
  Don't tell me using alter database datafile '...' offline drop
 command.
  It won't work.
  
  I am working on Oracle 7.3.4.
  
  Thanks,
  
  Tom Xie
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Xie, Tom
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 -- 
 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 Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other

Re: Calling an External Java Class from PL/SQL - FORGET IT

2002-05-15 Thread Peter Barnett


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 done, if so can you point me to a url with
 an
 example or two.
 
 Thanks,
 
 Pete
 
 
 
 =
 Pete Barnett
 Lead Database Administrator
 The Regence Group
 [EMAIL PROTECTED]
 
 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Peter Barnett
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Calling an External Java Class from PL/SQL

2002-05-15 Thread Vadim Gorbounov


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 implements these Java
specifications in JServer, that is you can develop Java classes providing
access to remote (i.e. external) classes, deploy these classes to Oracle
JServer and create PL/SQL wrapper. 
URLs
http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90
1/a90210/toc.htm
http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90
1/a90187/toc.htm
http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90
1/a90188/toc.htm

HTH
Vadim



-Original Message-
Sent: Wednesday, May 15, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L


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 Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vadim Gorbounov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:How to drop a datafile from a tablespace quickly




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, That will keep data out of it but you are going
to need downtime to fix this



|+---
||   |
||   |
||  dgoulet@vicr.|
||  com  |
||   |
||  05/15/2002   |
||  01:48 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re:How to drop a datafile from a|
  |   tablespace quickly   |
  |




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 the original table and
tablespace, and then rename the table back to it's old name.  Don't forget the
grants as well.

Dick Goulet

Reply Separator
Author: Xie; Tom [EMAIL PROTECTED]
Date:   5/15/2002 8:58 AM

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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Deadlock ORA-60

2002-05-15 Thread Seema Singh


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. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a data file from a tablespace quickly




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




|+-
|| |
|| |
||  ashoke.k.mandal@med|
||  tronic.com |
|| |
||  05/15/2002 01:43 PM|
||  Please respond to  |
||  ORACLE-L   |
|| |
|+-
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: How to drop a data file from|
  |   a tablespace quickly |
  |





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 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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly




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?




|+---
||   |
||   |
||  [EMAIL PROTECTED]|
||  ms.osd.mil   |
||   |
||  05/15/2002 02:39 PM  |
||  Please respond to|
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: How to drop a datafile from |
  |   a tablespace quickly |
  |




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 serious
problems in the future.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:58 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:   RE: How to drop a datafile from a tablespace quickly

 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 PROTECTED]]
 Sent: Wednesday, May 15, 2002 12:33 PM
 To: Multiple recipients of list ORACLE-L


 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.

 Scott Shafer
 San Antonio, TX
 210-581-6217


  -Original Message-
  From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, May 15, 2002 11:58 AM
  To: Multiple recipients of list ORACLE-L
  Subject: How to drop a datafile from a tablespace quickly
 
  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
  tablespace. As I know, to drop a data file, I have to export the data,
  drop the tablespace and recreate it, and then import data back to
  the tablespace. However, since our users can't stop using the table,
  I won't have enough down time to do that.
 
  Is there anyway I can quickly drop a data file from a tablespace?
 
  Don't tell me using alter database datafile '...' offline drop
 command.
  It won't work.
 
  I am working on Oracle 7.3.4.
 
  Thanks,
 
  Tom Xie
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Xie, Tom
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 --
 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 Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX:

RE: Dba_tab_modifications question

2002-05-15 Thread Grabowy, Chris


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 immediately,
but after a time lapse (usually 3 hours). 

Perhaps that explains the diff.  Check it out.

Chris

-Original Message-
Sent: Wednesday, May 15, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


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 this table.

  1  select inserts,updates,deletes from dba_tab_modifications
  2* where table_name = 'NOTES_LOG'
WFM_ADMIN@VGRAFO /

   INSERTSUPDATESDELETES
   ---- ---
  6509  0   0

WFM_ADMIN@VGRAFO select count(*) from notes_log;

  COUNT(*)
--
   1592488

The difference between yesterday's and today's count is 6791 which does not
match the number in dba_tab_modifications. 

Does this mean that I cannot rely on dba_tab_modifications?


TIA
Prakash
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BALA,PRAKASH (Non-HP-USA,ex1)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly


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
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L




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, That will keep data out of it but you are
going
to need downtime to fix this



|+---
||   |
||   |
||  dgoulet@vicr.|
||  com  |
||   |
||  05/15/2002   |
||  01:48 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re:How to drop a datafile from a|
  |   tablespace quickly   |
  |




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 the original table and
tablespace, and then rename the table back to it's old name.  Don't forget
the
grants as well.

Dick Goulet

Reply Separator
Author: Xie; Tom [EMAIL PROTECTED]
Date:   5/15/2002 8:58 AM

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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante,

RE: How to drop a datafile from a tablespace quickly


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 recipients of list ORACLE-L


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 the original table and
tablespace, and then rename the table back to it's old name.  Don't forget
the
grants as well.

Dick Goulet

Reply Separator
Author: Xie; Tom [EMAIL PROTECTED]
Date:   5/15/2002 8:58 AM

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 
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to 
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that. 

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Deadlock ORA-60


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


 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 world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly


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 tablespace quickly
 
 
 
 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?
 
 
 
 
 |+---
 ||   |
 ||   |
 ||  [EMAIL PROTECTED]|
 ||  ms.osd.mil   |
 ||   |
 ||  05/15/2002 02:39 PM  |
 ||  Please respond to|
 ||  ORACLE-L |
 ||   |
 |+---
   |
   ||
   |   To: [EMAIL PROTECTED] |
   |   cc: (bcc: Rachel Carmichael) |
   |   Subject: RE: How to drop a datafile from |
   |   a tablespace quickly |
   |
 
 
 
 
 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
 serious
 problems in the future.
 
 Scott Shafer
 San Antonio, TX
 210-581-6217
 
 
  -Original Message-
  From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, May 15, 2002 12:58 PM
  To:   Multiple recipients of list ORACLE-L
  Subject:   RE: How to drop a datafile from a tablespace quickly
 
  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 PROTECTED]]
  Sent: Wednesday, May 15, 2002 12:33 PM
  To: Multiple recipients of list ORACLE-L
 
 
  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.
 
  Scott Shafer
  San Antonio, TX
  210-581-6217
 
 
   -Original Message-
   From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
   Sent:   Wednesday, May 15, 2002 11:58 AM
   To: Multiple recipients of list ORACLE-L
   Subject: How to drop a datafile from a tablespace quickly
  
   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
   tablespace. As I know, to drop a data file, I have to export the data,
   drop the tablespace and recreate it, and then import data back to
   the tablespace. However, since our users can't stop using the table,
   I won't have enough down time to do that.
  
   Is there anyway I can quickly drop a data file from a tablespace?
  
   Don't tell me using alter database datafile '...' offline drop
  command.
   It won't work.
  
   I am working on Oracle 7.3.4.
  
   Thanks,
  
   Tom Xie
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Xie, Tom
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
   San Diego, California-- Public Internet access / Mailing Lists
   
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
  --
  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 Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail

RE: Deadlock ORA-60


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 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 world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Deadlock ORA-60




the problem is in the application code... find the sql (it's in the trace files)
and start from there




|+---
||   |
||   |
||  oracledbam@ho|
||  tmail.com|
||   |
||  05/15/2002   |
||  03:18 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Deadlock ORA-60 |
  |




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 world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

[Q] How to make Sql*loader run under nologging mode?

2002-05-15 Thread dist cash


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.



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dist cash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Deadlock ORA-60


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 modules.  It's usually a design/implementation issue in the
application...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 1:18 PM


 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 world's largest e-mail service with MSN Hotmail.
 http://www.hotmail.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Seema Singh
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to drop a datafile from a tablespace quickly


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 universe, I
think) had just been discovered to be 42, sometime in the mid-90s, I
believe...

His response was something along the lines of Well, actually I didn't know,
of course.  It's just that I needed an answer to the question 'What is the
meaning of life, the universe, and everything?' and 42 seemed like an
appropriate answer.  Just an ordinary, sort of smallish number...

I have to go back and re-read those...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 15, 2002 2:03 PM


 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 tablespace quickly
 
 
 
  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?
 
 
 
 
  |+---
  ||   |
  ||   |
  ||  [EMAIL PROTECTED]|
  ||  ms.osd.mil   |
  ||   |
  ||  05/15/2002 02:39 PM  |
  ||  Please respond to|
  ||  ORACLE-L |
  ||   |
  |+---
|
||
|   To: [EMAIL PROTECTED] |
|   cc: (bcc: Rachel Carmichael) |
|   Subject: RE: How to drop a datafile from |
|   a tablespace quickly |
|
 
 
 
 
  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
  serious
  problems in the future.
 
  Scott Shafer
  San Antonio, TX
  210-581-6217
 
 
   -Original Message-
   From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
   Sent: Wednesday, May 15, 2002 12:58 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:   RE: How to drop a datafile from a tablespace
quickly
  
   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 PROTECTED]]
   Sent: Wednesday, May 15, 2002 12:33 PM
   To: Multiple recipients of list ORACLE-L
  
  
   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.
  
   Scott Shafer
   San Antonio, TX
   210-581-6217
  
  
-Original Message-
From:   Xie, Tom [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 15, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Subject: How to drop a datafile from a tablespace quickly
   
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
tablespace. As I know, to drop a data file, I have to export the
data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.
   
Is there anyway I can quickly drop a data file from a tablespace?
   
Don't tell me using alter database datafile '...' offline drop
   command.
It won't work.
   
I am working on Oracle 7.3.4.
   
Thanks,
   
Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

RE: How to drop a datafile from a tablespace quickly




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




|+
|||
|||
||  [EMAIL PROTECTED]|
||  tate.ny.us|
|||
||  05/15/2002|
||  03:53 PM  |
||  Please respond|
||  to ORACLE-L   |
|||
|+
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: RE: How to drop a datafile from |
  |   a tablespace quickly |
  |




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
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:19 PM
To: Multiple recipients of list ORACLE-L




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, That will keep data out of it but you are
going
to need downtime to fix this



|+---
||   |
||   |
||  dgoulet@vicr.|
||  com  |
||   |
||  05/15/2002   |
||  01:48 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re:How to drop a datafile from a|
  |   tablespace quickly   |
  |




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 the original table and
tablespace, and then rename the table back to it's old name.  Don't forget
the
grants as well.

Dick Goulet

Reply Separator
Author: Xie; Tom [EMAIL PROTECTED]
Date:   5/15/2002 8:58 AM

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
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.

Is there anyway I can quickly drop a data file from a tablespace?

Don't tell me using alter database datafile '...' offline drop command.
It won't work.

I am working on Oracle 7.3.4.

Thanks,

Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
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 Internet access / Mailing Lists

RE: Dba_tab_modifications question

2002-05-15 Thread BALA,PRAKASH (Non-HP-USA,ex1)


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 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 immediately,
but after a time lapse (usually 3 hours). 

Perhaps that explains the diff.  Check it out.

Chris

-Original Message-
Sent: Wednesday, May 15, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L


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 this table.

  1  select inserts,updates,deletes from dba_tab_modifications
  2* where table_name = 'NOTES_LOG'
WFM_ADMIN@VGRAFO /

   INSERTSUPDATESDELETES
   ---- ---
  6509  0   0

WFM_ADMIN@VGRAFO select count(*) from notes_log;

  COUNT(*)
--
   1592488

The difference between yesterday's and today's count is 6791 which does not
match the number in dba_tab_modifications. 

Does this mean that I cannot rely on dba_tab_modifications?


TIA
Prakash
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BALA,PRAKASH (Non-HP-USA,ex1)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BALA,PRAKASH (Non-HP-USA,ex1)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Deadlock ORA-60

2002-05-15 Thread Ray Stell


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 PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Resizing RBSs in an LMT

2002-05-15 Thread Jesse, Rich


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
particular DB.  From the Oracle Perf Tuning class, this tells me that my
next extents may be too small.

But since this is in an LMT, the only way to increase the next extent size
on an RBS in an LMT is to recreate the whole TS, right?  Or am I missing
something?  At least we haven't hit any ORA-1555 errors in the past 9 months
since I hosed up these RBSs...  :)

TIA,
Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to drop a datafile from a tablespace quickly


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:   Multiple recipients of list ORACLE-L
 Subject:  Re: How to drop a datafile from a tablespace quickly
 
 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 universe,
 I
 think) had just been discovered to be 42, sometime in the mid-90s, I
 believe...
 
 His response was something along the lines of Well, actually I didn't
 know,
 of course.  It's just that I needed an answer to the question 'What is the
 meaning of life, the universe, and everything?' and 42 seemed like an
 appropriate answer.  Just an ordinary, sort of smallish number...
 
 I have to go back and re-read those...
 
 -Tim
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, May 15, 2002 2:03 PM
 
 
  Exactly my point.  The answer is 42.
 
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Deadlock ORA-60


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 15, 2002 at 12:03:22PM -0800, [EMAIL PROTECTED]
 wrote:
  kick the power cable to your server...
 
 whoa, talk about attack of the clones...take a break, man.
 ===
 Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
 
-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Deadlock ORA-60




true -- but 99% of the time, it's in the application code (and you listed 4, not
3, additional reasons :)   )


|+---
||   |
||   |
||  kaygopal@yaho|
||  o.com|
||   |
||  05/15/2002   |
||  04:38 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Re: Deadlock ORA-60 |
  |




Rachel:

Not very true. Deadlocks can happen for n number of reasons. You can not
always
tell ' the problem is with application code'.

For example you can deadlocks for

1. Missing indexes in Foreign keys
2. ITL Entry shortages
3. INVALID triggers
4. Oracle BUGS (!)

The above three are database/design issues. Application code has no role
here

Best Regards,
K Gopalakrishnan
Bangalore, INDIA



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 1:33 AM




the problem is in the application code... find the sql (it's in the trace
files)
and start from there




|+---
||   |
||   |
||  oracledbam@ho|
||  tmail.com|
||   |
||  05/15/2002   |
||  03:18 PM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED] |
  |   cc: (bcc: Rachel Carmichael) |
  |   Subject: Deadlock ORA-60 |
  |




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 world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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 Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT

Re: [Q] How to make Sql*loader run under nologging mode?

2002-05-15 Thread Bill Pass


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 their
 has way to make
 sql*loader run under nologging mode?
 
 Thanks.
 
 
 

_
 MSN Photos is the easiest way to share and print
 your photos: 
 http://photos.msn.com/support/worldwide.aspx
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: dist cash
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Resizing RBSs in an LMT


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 PROTECTED]
Sent: Wednesday, May 15, 2002 2:56 PM


 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
 particular DB.  From the Oracle Perf Tuning class, this tells me that my
 next extents may be too small.

 But since this is in an LMT, the only way to increase the next extent size
 on an RBS in an LMT is to recreate the whole TS, right?  Or am I missing
 something?  At least we haven't hit any ORA-1555 errors in the past 9
months
 since I hosed up these RBSs...  :)

 TIA,
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to drop a datafile from a tablespace quickly