nls_sort

[GKor]

hi all

we had a strange sort order on a attribute in a table with dashes (-) in the
data.

example

query with default NLS_SORT (NLS_LANGUAGE=american)

R/10-02 
R/1-01  
R/101-00
R/101-03

query with NLS_SORT=BINARY

R/1-01  
R/10-02 
R/101-00
R/101-03

Anyone with an explanation why this parameter is not default BINARY ?


thanks

vr.gr.
G. Kor
Sr. System Engineer I&DM Db
RDW Voertuiginformatie en -toelating 
Ict Bedrijf




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: composite primary key versus unique index

[GKor]

i did exactly the first thing you named.

 <> 
--- Begin Message ---
You mean you created an index A on the table with the descending column
order, and then added a primary key constraint, which created another index
on the same columns (except that all the columns are in ascending order).
Or did you do something different? If you did something different I'd be
curious to know exactly what you implemented.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> 
> i didnt that try on Oracle, but our mainframe Rdms. We have 
> that situation
> there with the ascending en descending attributes in the primary key.
> The workaround is to create a unique index (with and without desc) and
> create afterwards a primary key constraint on it in oracle.
> we have oracle 8.1.7.4.10. (including patches)
> 
> 
> -Original Message-
> From: Jacques Kilchoer
> 
> I don't understand how you can have those types of objects created.
> 
> Let's assume this situation:
> 
> create table T (a number, b number, c number) ;
> create unique index t_pk on t (a asc, b desc) ;
> alter table t add (constraint t_pk primary key (a, b)) ;
> 
> In 8.1 and later, the third statement (add constraint) will return an
> ORA-0955 error because Oracle is unable to build the index 
> needed for the
> primary key constraint.
> 
> In 8.0 and earlier, the "desc" keyword will be ignored in the 
> "create index"
> statement, so there will be no reason why you cannot create 
> the primary key
> constraint and foreign key constraints referencing that primary key
> constraint.
> 
> 
> Now, in 8.1 and later, if the index and the PK have different 
> names, like
> so:
> 
> create table T (a number, b number, c number) ;
> create unique index t_idx1 on t (a asc, b desc) ;
> alter table t add (constraint t_pk primary key (a, b)) ;
> 
> then the third statement (add constraint) will create a 
> second index on the
> table named t_pk, and again you will be able to create foreign key
> constraints referencing the primary key constraint.
> 
> What version of Oracle are you running, and could you describe the
> tables/indexes/constraints involved?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
--- End Message ---

RE: composite primary key versus unique index

[GKor]

i didnt that try on Oracle, but our mainframe Rdms. We have that situation
there with the ascending en descending attributes in the primary key.
The workaround is to create a unique index (with and without desc) and
create afterwards a primary key constraint on it in oracle.
we have oracle 8.1.7.4.10. (including patches)


 <> 
--- Begin Message ---
I don't understand how you can have those types of objects created.

Let's assume this situation:

create table T (a number, b number, c number) ;
create unique index t_pk on t (a asc, b desc) ;
alter table t add (constraint t_pk primary key (a, b)) ;

In 8.1 and later, the third statement (add constraint) will return an
ORA-0955 error because Oracle is unable to build the index needed for the
primary key constraint.

In 8.0 and earlier, the "desc" keyword will be ignored in the "create index"
statement, so there will be no reason why you cannot create the primary key
constraint and foreign key constraints referencing that primary key
constraint.


Now, in 8.1 and later, if the index and the PK have different names, like
so:

create table T (a number, b number, c number) ;
create unique index t_idx1 on t (a asc, b desc) ;
alter table t add (constraint t_pk primary key (a, b)) ;

then the third statement (add constraint) will create a second index on the
table named t_pk, and again you will be able to create foreign key
constraints referencing the primary key constraint.

What version of Oracle are you running, and could you describe the
tables/indexes/constraints involved?

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> 
> I have the following question for you :
> We have a mainframe database with tables which have composite 
> primary keys
> with an ascending and a descending item.
> For example a table with license regisitrations with primary key items
> LICENSE in ascending and REGISTRATION_DATE in descending order.
> As far as i know this is not possible with Oracle, only a unique index
> should be a candidate to do this. 
> I said should be, because if you need a foreign key relation to this
> specific composite index i get an ORA-2270 !.
> Anyone with an explanation why a create of a composite unique 
> index with an
> ascending and descending order works and not with the primary 
> key clause ?
> Is this triggered in oracle 9i or 10i ?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
--- End Message ---

composite primary key versus unique index

[GKor]

hi all

I have the following question for you :
We have a mainframe database with tables which have composite primary keys
with an ascending and a descending item.
For example a table with license regisitrations with primary key items
LICENSE in ascending and REGISTRATION_DATE in descending order.
As far as i know this is not possible with Oracle, only a unique index
should be a candidate to do this. 
I said should be, because if you need a foreign key relation to this
specific composite index i get an ORA-2270 !.
Anyone with an explanation why a create of a composite unique index with an
ascending and descending order works and not with the primary key clause ?
Is this triggered in oracle 9i or 10i ?

thanks




vr.gr.
G Kor
Sr. System Engineer I&DM Db
RDW 
Holland




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: fine grained access

[GKor]

thanks all for your quick replies. I think i will write a few triggers to do
the trick.

 <> 
--- Begin Message ---
Hi Arup,

LogMiner is fine for certain tasks but not for auditing everything, it
has some deficiencies such as it cannot be used in an MTS environment as
it uses PGA memory, it doesn't fully support chained and migrated rows
(fixed in 9i), doesn't support selects (as they are not recorded in the
redo prior to 9i), doesn't fully support objects of analysis of IOT's or
clustered tables. 

But I do agree with you that the best solution is to use regular audit
or normal user triggers.

If the poster wants to use Fine Grained audit then there are a few links
to some good documents on my site http://www.petefinnigan.com/orasec.htm
that cover FGA.

kind regards

Pete

>However, FGA is bit of an overkill in your case. It's typically the only
>solution for auditing the seelct statements. For changes
>(insert/update/delete), you could employ the regular auditing (AUDIT). that
>will tell you who changed something, but not what. To see the what, you
>could use log miner to unearth those statements with the data.
>
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
--- End Message ---

fine grained access

[GKor]

Hi list

We have a dozen authorisation tables who are visibible for end-users and
changeable for application owners.
What our security officer wants is that he can see who changed something in
those tables (including timestamp and update statement)
Is FGA the solution for this ?
Anyone with a few tips/hints how to do this with FGA ?

thanks 




vr.gr.
Geo Kor
Sr. System Engineer I&DM Db
RDW Voertuiginformatie en -toelating 
Ict Bedrijf
Holland
* [EMAIL PROTECTED]  



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: copying datafile nt4-w2k

[GKor]

100% correct

 <> 
--- Begin Message ---

This only works if you don't want to rename the database.

Jared

On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote:
> i saw this document on Metalink, it is possible to copy everything even
> without creating the controlfiles!!
>
> * goal: How to copy an Oracle database to another machine
> * fact: Oracle Server - Enterprise Edition
> fix: Pre-requisites: The copy is between 2 machines, both have to be on
the
> same OS and have to have exactly the same database version installed. 1.
> Make sure the database you want to copy was closed with a SHUTDOWN
> IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and
> control files to create instance and be able to go in mount mode. Check
the
> init.ora for the locations where the controlfiles have to be, if those
> locations are not valid on the machine put the control files on different
> places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all
of
> them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the
> environment variables: ORACLE_SID - set to the database name you wish to
> create ORACLE_HOME - set to full pathname of the Oracle system home
> directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do
> 'set ORACLE_SID=' Use oradim to create the service for the instance.
> For more information on oradim please refer to (the part that refers to
> creating a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1
> Instance/Database
> 5.
Use
> servermanager (check the name to use for your version of oracle) or
sqlplus
> (version 9i and above) to startup the database in mount mode. Do CONNECT
> INTERNAL/ then STARTUP MOUNT Then do a rename of the copied
> datafiles if they are not in the same path as on the other machine. For
all
> the files that are in the result of the query: SELECT NAME FROM
V$DATAFILE;
> do ALTER DATABASE RENAME FILE '\' to <
> newfullpath>\'; 6. Query the datadictionary for the old location
> of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place
> is not the same as the old do: ALTER DATABASE RENAME FILE
> '\' to & lt;newfullpath>\';
> 7. Now open the database: ALTER DATBASE OPEN;
>
>
>  <>


Content-Type: message/rfc822; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: Re: copying datafile nt4-w2k

--- End Message ---

RE: copying datafile nt4-w2k

[GKor]

i saw this document on Metalink, it is possible to copy everything even
without creating the controlfiles!!

*   goal: How to copy an Oracle database to another machine 
*   fact: Oracle Server - Enterprise Edition 
fix: Pre-requisites: The copy is between 2 machines, both have to be on the
same OS and have to have exactly the same database version installed. 1.
Make sure the database you want to copy was closed with a SHUTDOWN
IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and
control files to create instance and be able to go in mount mode. Check the
init.ora for the locations where the controlfiles have to be, if those
locations are not valid on the machine put the control files on different
places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all of
them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the
environment variables: ORACLE_SID - set to the database name you wish to
create ORACLE_HOME - set to full pathname of the Oracle system home
directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do 'set
ORACLE_SID=' Use oradim to create the service for the instance. For
more information on oradim please refer to (the part that refers to creating
a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1 Instance/Database
5. Use
servermanager (check the name to use for your version of oracle) or sqlplus
(version 9i and above) to startup the database in mount mode. Do CONNECT
INTERNAL/ then STARTUP MOUNT Then do a rename of the copied
datafiles if they are not in the same path as on the other machine. For all
the files that are in the result of the query: SELECT NAME FROM V$DATAFILE;
do ALTER DATABASE RENAME FILE '\' to <
newfullpath>\'; 6. Query the datadictionary for the old location
of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place
is not the same as the old do: ALTER DATABASE RENAME FILE
'\' to & lt;newfullpath>\';
7. Now open the database: ALTER DATBASE OPEN; 


 <> 
--- Begin Message ---

Yes, the database is down while doing this.

Opening the database and creating a controlfile works,
but I really didn't expect recovery on an 8.0 database 
to work with 8i executables.

Jared

On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote:
> Presuming this is a cold backup. I recall trying it about a year or so ago
> with a hot backup and had a problem with recovery not knowing when to stop
> - it kept wanting more log files.
>
> >>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>
>
> Certainly possible.
>
> I'm currently copying 8.0 files on NT to Win2k servers with
> 8.1.7 installed.  Rebuild the controlfile, open the database
> and upgrade.  Works great.
>
> Jared
>
> On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:
> > hi all
> >
> > We are planning an upgrade from NT4 to W2K.
> > I am considering to create a new instance on another server with W2K
> > installed and copying the datafiles
> > from the server with NT4 on it.
> > Is this possible ? Or do i have to use the exp/imp strategy ?
> >
> > thanks
> >
> > vr.gr.
> > Geo Kor
> > Sr. System Engineer I&DM Db
> > RDW Voertuiginformatie en -toelating
> > Holland


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
--- End Message ---

copying datafile nt4-w2k

[GKor]

hi all

We are planning an upgrade from NT4 to W2K.
I am considering to create a new instance on another server with W2K
installed and copying the datafiles
from the server with NT4 on it. 
Is this possible ? Or do i have to use the exp/imp strategy ?

thanks

vr.gr.
Geo Kor
Sr. System Engineer I&DM Db
RDW Voertuiginformatie en -toelating 
Holland



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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

moving away from mainframe

[GKor]

hi list

Is there somebody on this wonderfull list considering to move away from the
mainframe computer with
his old RDMS to another platform (MS or UNIX)  with oracle/sqlserver ?
What are your scenarios : Big bang or keep 2 database in synch (how ?)
Anyone with Unisys Clearpath systems with this case ?

Thanks for your contribution

vr.gr.
G.g. Kor
Sr. System Engineer I&DM Db
RDW Voertuiginformatie en -toelating 




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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Freeware tool to browse data in Oracle tables?

[GKor]

hi

try this one, it's a freeware tool called Tora
http://www.globecom.se/tora/

 <> 

--- Begin Message ---
Hi! 

Does anybody out there know of a freeware tool that allows you to browse
through Oracle tables and edit data? 

I know this can be done through ODBC and Excel, but I need this for
"regular" users who need this tool to be quite simple...

Thanks, 
Helmut 


--- End Message ---

RE: OS Authentication on Win2K

[GKor]

when you create the registry setting in HKLM\software\oracle :
OSAUTH_PREFIX_DOMAIN=FALSE, then is it possible to log on
with domain account as /

it dit work for me.

> -Oorspronkelijk bericht-
> Van:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 30 oktober 2002 19:10
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: OS Authentication on Win2K
> 
> run:
> 
> select username from dba_users 
> where password = 'EXTERNAL'
> 
> Is there a user that matches the currently logged on
> Win2k account? 
> 
> Is it a domain account?  It needs to be a local account,
> as I don't think you can use a domain account without
> also using 'remote_os_authent=true'.
> 
> At least, it doesn't work for me that way.  I've only used
> external auth with local accounts.
> 
> HTH
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Mike Sardina" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  10/30/2002 09:24 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:OS Authentication on Win2K
> 
> 
> I am having problems getting OS authentication to work on a Win2K oracle
> server (8.1.7.1.1).
> 
> All parameters are set properly (from what I can see). There cannot be a
> prefix so the following parameter is set as follows: os_authent_prefix = 
> ""
> 
> I need to be able to log into the server as a user identified externally 
> and
> just type sqlplus / for access. It is also necessary for the users 
> identified
> externally to be  able to use a password as well.  Any suggestions? Anyone
> else run into problems with this?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mike Sardin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

upgrade 8-9 and ofa compliance

[GKor]

hi list

We are planning to migrate our database from 8i to 9i soon, i had the idea
to use the migrate utility from oracle.
So far so good, but at one moment i have 2 OFA compliant software trees on
my server :
/oracle/ora81 and /oracle/ora90 with the corresponding registry settings.
What is the correct procedure to eliminate everything of oracle 8i
afterwards and that nothing is pointing
to the /oracle/ora81 directory ??

vr. gr.
g.g. kor
rdw ict netherlands
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: oracle or mssql

[GKor]

goodmorning
everybody who responded to my basic question : thanks

summary

professional : use oracle enterprise edition
semi professional : use oracle standard edition / mssql enterprise edition
in all other cases mssql standard edition



> -Oorspronkelijk bericht-
> Van:  Mohammad Rafiq [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 23 oktober 2002 20:51
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle or mssql
> 
> Xenix is history now...SCO itself stopped it sometime in 1990
> 
> 
> 
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 23 Oct 2002 09:02:19 -0800
> 
> XENIX maybe.
> 
> : )
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> 
> Systems Admin & Operations | Admin. et Exploit. des systèmes
> Technology Services| Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO  | Région des Maritimes, MPO
> 
> E-Mail: [EMAIL PROTECTED]
> 
> 
> 
> 
> -Original Message-
> Sent: Wednesday, October 23, 2002 12:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Is MSSQL server available on UNIX?
> 
> -Rachna
> --
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).
> 
> 
> _
> Get faster connections -- switch to MSN Internet Access! 
> http://resourcecenter.msn.com/access/plans/default.asp
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohammad Rafiq
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

oracle or mssql

[GKor]

Hi list

Please input why my boss must invest into oracle rather than the cheaper
mssql.
His opinion is that most features are almost the same but mssql does that at
half the price as oracle does.
So why he should not choose mssql is the question




g.g. kor
rdw ict groningen

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Is it possible to copy one db to another if the SID is differ

[GKor]

hi

you have to do a 
alter database backup controlfile to trace on the source database

change all occurrences PROD in TEST in the created backup controlfile
the create controlfile reuse has to be create controlfile SET database
"test"

oracle note 61590.1 on metalink

g.g. kor
rdw the netherlands

> -Oorspronkelijk bericht-
> Van:  CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 9 oktober 2002 9:13
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Is it possible to copy one db to another if the SID is
> different 
> 
> Hi,
> 
> Qn : Is it possible to copy one database to another if the source database
> name is different from the target database name ? 
> 
> I need to clone Oracle Applications 11I from one machine (source
> instance:PROD) to another (target instance:TEST). I followed the
> instructions on Metalink doc 135792.1 "Cloning Oracle Applications Release
> 11I". Everything works fine until I re-create the controlfile in the
> target
> instance.
> 
> In svrmgrl =>
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
> MAXLOGFILES 16
> MAXLOGMEMBERS 2
> MAXDATAFILES 500
> MAXINSTANCES 1
> MAXLOGHISTORY 453
> LOGFILE
>   GROUP 1 (
> '/dg3/oracle/testredo/log01a.dbf',
> '/dg4/oracle/testredo/log01b.dbf'
>   ) SIZE 10M
>   
> DATAFILE
>   '/dg7/oracle/testdata/system01.dbf',
>   '/dg7/oracle/testdata/system02.dbf', 
>   ...
>   '/dg8/oracle/testdata/ctxd01.dbf',
> .
> CHARACTER SET US7ASCII
> CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01161: database name PROD in file header does not match given name of
> TEST
> 
> Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])
> 
> Regds,
> New Bee
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: CHAN Chor Ling Catherine (CSC)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: X_$KGLCURSOR view

[GKor]

yes, i came to the same conclusion as you did.
i tried to withdraw my posting but it was too late.
it was the script create_xviews

thanks

> -Oorspronkelijk bericht-
> Van:  Jack van Zanen [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 18 september 2002 13:43
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: X_$KGLCURSOR view
> 
> Hi
> 
> 
> Isn't that part of the Steve Adams scripts prerequisites?
> 
> 
> www.ixora.com.au
> 
> 
> Jack
> 
> 
>  
> 
>   [EMAIL PROTECTED]
> 
>   Sent by: To:   Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]> 
>   [EMAIL PROTECTED] cc:   (bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)  
>Subject:  X_$KGLCURSOR view
> 
>  
> 
>   18-09-2002 12:58
> 
>   Please respond to
> 
>   ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> hi everyone
> 
> anyone where the sys view X_$KGLCURSOR is being created ? I have several
> X_$
> views on that particular scheme.
> 
> strange is that these views not appear on all servers, so i don't think
> these are created via catalog or catproc procedures.
> 
> this is a oracle 8.1.7.0. install on a windows nt4 platform.
> 
> thanks
> 
> g.g. kor
> rdw ict groningen
> 
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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).
> 
> 
> 
> ===
> 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 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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 

Intrekken: X_$KGLCURSOR view

[GKor]

Kor, Geo wil graag bericht X_$KGLCURSOR view intrekken.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

X_$KGLCURSOR view

[GKor]

hi everyone

anyone where the sys view X_$KGLCURSOR is being created ? I have several X_$
views on that particular scheme.

strange is that these views not appear on all servers, so i don't think
these are created via catalog or catproc procedures.

this is a oracle 8.1.7.0. install on a windows nt4 platform.

thanks
 
g.g. kor
rdw ict groningen
 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).

cobol-oracle

[GKor]

hi all

how to define a number(10) oracle datatype in microfocus cobol. 
when we code it as pic s9(10)  comp-5 we get an error message
PCC-0026 Undeclared host variable "name" at line num in file "name" 

with a number(5) datatype and a cobol  definition pic s9(5) comp-5 we don't
get the error message.
i read in the oracle manuals that there is no representation for the NUMBER
datatype in COBOL.
Anyone with an explanation ?


with regards
g.g. kor
rdw ict groningen
holland

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: cache settings NT

[GKor]

thanks for your explanation, i'll go for the 0% read - 100% write cache.

> -Oorspronkelijk bericht-
> Van:  Igor Neyman [SMTP:[EMAIL PROTECTED]]
> Verzonden:vrijdag 6 september 2002 22:43
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: cache settings NT
> 
> That's why you use write cache only if it's "battery supported".  Then it
> should be safe.
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
> 
> 
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, September 06, 2002 2:28 PM
> 
> 
> >
> > I'll take a shot at this.
> >
> > Don't have any write caching.  Oracle may think that it has safely
> > committed the transactions and they are written to disk when they are in
> > fact only in cache.  If the machine were to shut down ungracefully,
> i.e.,
> > someone kicks out the plug, then your database would not be in a
> consistent
> > state.  Granted, the odds are small, but is it worth the risk?  If the
> > database is archived and you don't mind the increased chance of having
> to
> > do a recovery then I would say 0% read - 100% write.  Oracle is doing
> it's
> > own read caching in the SGA and it's unlikely that the disk cache will
> > correctly anticipate Oracle's read requirements.  Therefore, caching on
> the
> > read side is only likely to increase IO.  Write caching does not lead to
> > any increased IO but it does have some small risk of producing an
> > inconsistent database.
> >
> >
> >
> > GKor
> > @rdw.nl  To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> > Sent by: rootcc:
> >  Subject: cache settings NT
> >
> > 09/06/2002
> > 04:18 AM
> > Please
> > respond to
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> > Hi all
> >
> > I have the following question for you :
> >
> > what are the preferred values for the several cache settings on the
> fysical
> > disk units (NT W2K)
> >
> > e.g. 100 % read cache - 0 % write cache
> > 50%   read cache - 50% write cache
> >
> > is there a difference between settings for an OLTP or DSS solution.
> >
> > etc
> >
> > anyone with an explanation
> >
> > vr. gr.
> > g.g. kor
> > rdw ict groningen
> >
> >
> > --
> > 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: 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).
> 
> -- 
> 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 

cache settings NT

[GKor]

Hi all

I have the following question for you :

what are the preferred values for the several cache settings on the fysical
disk units (NT W2K)

e.g. 100 % read cache - 0 % write cache 
50%   read cache - 50% write cache

is there a difference between settings for an OLTP or DSS solution.

etc

anyone with an explanation

vr. gr.
g.g. kor
rdw ict groningen


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

[GKor]

we have W2K platform
so if i understand correctly i put my NT account in the ORA_DBA group, then
connect / as sysdba and grant the rights.

> -Oorspronkelijk bericht-
> Van:  Peter Gram [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 15 mei 2002 12:49
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: grant sysdba rights
> 
> 
> The answer depends on what O/S you are on.
> 
> Unix :
> When the oracle software was installed you where asked about a Unix 
> group (normally called dba) that has privileges
> this group is then compiled and linked into the Oracle executable.
> When member of this group you can connect with "/ as sysdba" and 
> from there grant sysdba to the user
> 
> NT :
> Since it is not possible to relink the code on NT the group is hard 
> coded to "ORA_DBA" on NT/W2K
> When member of this group you can connect with "/ as sysdba" and 
> from there grant sysdba to the user
> 
> VMS :
> 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 user
> 
> MVS :
> Help ???
> 
> [EMAIL PROTECTED] wrote:
> 
> >Hi list
> >
> >When the system account needs the SYSDBA role granted , i simply connect
> as
> >internal and grant that role to system. 
> >But the connect internal is obsolete in oracle 9i, so how do i grant the
> >sysdba role to other accounts ??
> >
> >thanks
> >
> >
> >vr. gr.
> >g.g. kor
> >rdw ict groningen
> > 
> >
> 
> -- 
> 
> /regards
> 
> Peter Gram
> 
> Mobil : +45 2527 7107
> Fax   : +45 4466 8856
> 
> Miracle A/S
> Kratvej 2
> 2760 Måløv
> 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).
--
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).

grant sysdba rights

[GKor]

Hi list

When the system account needs the SYSDBA role granted , i simply connect as
internal and grant that role to system. 
But the connect internal is obsolete in oracle 9i, so how do i grant the
sysdba role to other accounts ??

thanks


vr. gr.
g.g. kor
rdw ict groningen
 

-- 
Please see 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: Accessing Synonym

[GKor]

you have to grant that user rights on that specific table

grant select on inventory.table to user;

> -Oorspronkelijk bericht-
> Van:  Abdul Aleem [SMTP:[EMAIL PROTECTED]]
> Verzonden:donderdag 18 april 2002 8:18
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Accessing Synonym
> 
> Hi,
> 
> I tried to create a public synonym for a table in schema "inventory", but
> it
> does not seem to be working, i.e., when I connect as another user, and try
> to select from the synonym it says table or view does not exist. 
> 
> I would appreciate any help.
> 
> Aleem
> 
> Following are the commands from SQL*Plus:
> 
> SQL> connect inventory/invent@test_server
>  
> Connected.
> SQL> create public synonym company for company;
> 
> Synonym created.
> SQL> connect scott/tiger@test_server  
> Connected.
> SQL> select * from company;
> select * from company
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> SQL> select * from inventory.company;
> select * from inventory.company
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Abdul Aleem
>   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).

Rman issue with oracle patch

[GKor]

Hi list

The setting :   A NT server upgraded to Oracle 81732 with the target
database installed on it.
A NT server with Oracle 81730 and the RMAN catalog
installed.

i did the following after applying the 81732 patch

After creating/installing new oracle and rman executable user should do 
 the following 
  sqlplus '/ as sysdba'; 
%ORACLE_HOME%\rdbms\admin\dbmsrman.sql 
%ORACLE_HOME%\rdbms\admin\prvtrmns.plb 
 If using catalog, then they should upgrade the catalog 
   rman catalog  
   upgrade catalog; 
   upgrade catalog;
this was executed with the new rman executable just installed.

After that the hotbackup fails with the following error messages :

RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1,
column 21:
PLS-00302: component 'LOCKFORCKPT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
RMAN-06097: text of failing SQL statement: begin dbms_rcvcat . lockForckpt ;
end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 2121


anyone with a clue what happened ?

thanks

g.g. kor
rdw ict the netherlands

-- 
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: Excel's Oracle connectivity

[GKor]

sqlxl maybe?

> -Oorspronkelijk bericht-
> Van:  Szecsy Tamas [SMTP:[EMAIL PROTECTED]]
> Verzonden:maandag 11 maart 2002 14:13
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Excel's Oracle connectivity
> 
> Hi,
> 
> some monthes back I read about a free utility that one could plugin to
> Excel. From then on Excel could read any data into it from Oracle. The SQL
> command could be written into the Excel sheets, so the user could refresh
> data any time he/she had Oracle connectivity and OLE connection. I forgot
> the link. Could some one please help me? (It was NOT Oraxcel!!)
> 
> TIA,
> 
> Tamas Szecsy
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Szecsy Tamas
>   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).

characterset database

[GKor]

hi all

we use 2 different character sets on our oracle servers
one sap server uses US47ASCII and our delphi-oracle server uses
WE8ISO8859P1.
can anyone tell me what the difference is and which problems i can
encounter.



g.g. kor
rdw ict groningen
the netherlands

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

function based index

[GKor]

hi everyone

we have a query with several max functions in it. 
The performance of the query is not so well, can i achieve better
performance with function based index on 
max(columnname)? 
according the manuals this is not allowed because max is a group function.
anyone with a solution for this ?

vr. gr.
g.g. kor
rdw ict groningen
 

-- 
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: IP Address Change

[GKor]

we changed serveral times and did'nt encounter any problems, you correctly
mentioned the listener en tnsnames files 
(the hostname doesn't change accidentally?)

g.g. kor
rdw ict the netherlands

> -Oorspronkelijk bericht-
> Van:  O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
> Verzonden:woensdag 14 november 2001 13:05
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:IP Address Change
> 
> Our network folk have informed me that they are going to have to change
> the
> scope of IP addresses at our site and hance the IP addresses of our
> servers
> will change.  We don't use Oracle names or MTS.  We're all NT/W2K servers
> and use DNS.  Are there any gothca's I need to be aware of.  Our TNSnames
> and Listener files use the host name and not specific IP addresses.  I've
> had a browse around MetaLink and have not ID'ed any problems thus far but
> more experienced feedback would be appreciated.
> 
> -
> Sean O' Neill
> Organon (Ireland) Ltd.
> [subscribed: digest mode] 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: O'Neill, Sean
>   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).

OT_salary

[GKor]

Hi 
i'd like to know what average salarys are in european countries for a medium
skilled DBA.
my first contribution is 40 USD


vr. gr.
g.g. kor
rdw ict the netherlands


-- 
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: Re[2]: os block size versus oracle bock size

[GKor]

ok, thanks for your explanation.

> -Oorspronkelijk bericht-
> Van:  [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Verzonden:dinsdag 23 oktober 2001 17:50
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re[2]: os block size versus oracle bock size
> 
> WHOA, No that is not a performance problem.  The Oracle block size needs
> to
> always be a multiple of the OS block size.  Most operating systems today,
> W2K
> being no exception, do not simply read the number of OS blocks that you
> request.
>  They always 'read ahead' in the anticipation that you'll want that data
> in the
> very near future.  The amount of read ahead that is done is OS specific. 
> Therefore if your Oracle block size is <= the OS block size the operating
> system
> will be doing a lot of reading for you that is irrelevant, which can lead
> to a
> phantom performance problem namely your wasting OS reads.  The idea here
> is to
> pick an Oracle block size that is appropriate for your application and a
> multiple of the OS block size.  Also set db_file_multiblock_read_count
> carefully
> since this controls the number of blocks that Oracle requests from the OS
> at one
> time.  If you need one block and have db_file_multiblock_read_count set to
> 100,
> then you get 100 blocks, if the OS allows.
> 
> Dick Goulet
> 
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   10/23/2001 7:05 AM
> 
> 
> Hi
> 
> 
> I'd say yes. For every Oracle block read the OS has to read two block
> which
> causes overhead.
> 
> 
> Jack
> 
> 
> 
> 
> [EMAIL PROTECTED]@fatcity.com on 23-10-2001 16:05:21
> 
> Please respond to [EMAIL PROTECTED]
> 
> Sent by:  [EMAIL PROTECTED]
> 
> 
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> 
> hi all
> 
> we have an oracle block size of 8k and i believe our W2K server has a
> default
> os block size of 4k.
> Is this a problem with the performance ?
> 
> thanks
> 
> 
> g.g. kor
> rdw ict groningen
> 
> 
> --
> 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).
> 
> 
> 
> 
> =
> 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.
> 

os block size versus oracle bock size

[GKor]

hi all

we have an oracle block size of 8k and i believe our W2K server has a
default
os block size of 4k.
Is this a problem with the performance ?

thanks

 
g.g. kor
rdw ict groningen
 

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

external authentication issue

[GKor]

Hi everyone

We introduced external authentication on windows 2000.

I had the following init.ora parameter set 

REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
OS_AUTHENT_PREFIX= ""
and i forgot to set REMOTE_OS_AUTHENT = true.

connect with a / didn't work (of course).

I searched on Metalink and found 2 possible causes

the REMOTE_OS_AUTHENT = true parameter was not set in init.ora
and the SQLNET.AUTHENTICATION_SERVICES = (NTS) was not set in sqlnet.ora
(server and cliënt)

I set both parameters and stopped/started the database, but connect / did
still not work
(invalid username/password was the message).

When i change SQLNET.AUTHENTICATION_SERVICES in (NONE) (the default value)
it WORKED!!

Can anyone explain to me why SQLNET.AUTHENTICATION_SERVICES = (NTS)  doesn't
work as described
by Metalink.

Thanks in Advance

vr. gr.
g.g. kor
rdw ict groningen
 

--
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: export user definitions

[GKor]

something like this i have found on teamdba.com

select 'create user '||username||' identified by values '
||chr(39)||password||chr(39)||
' default tablespace '||default_tablespace ||
' temporary tablespace '|| temporary_tablespace||' ;'
from dba_users
where username not in ('SYS','SYSTEM','DBSNMP','OUTLN');

> -Oorspronkelijk bericht-
> Van:  Jared Still [SMTP:[EMAIL PROTECTED]]
> Verzonden:maandag 10 september 2001 15:47
> Aan:  [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Onderwerp:Re: export user definitions
> 
> On Monday 10 September 2001 02:45, [EMAIL PROTECTED] wrote:
> > hi everyone
> >
> > can anybody help me with a script that recreates
> > user definitions and the granted roles ?
> >
> > thanks
> >
> > g.g. kor
> > rdw ict groningen
> 
> Someone asked this just a couple of weeks ago. That 
> script will recreate a user.
> 
> Take a look through the archives at www.fatcity.com for this.
> 
> Recreating the roles is a simple exercise I'll leave to you.
> 
> Jared
-- 
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).

export user definitions

[GKor]

hi everyone

can anybody help me with a script that recreates
user definitions and the granted roles ?

thanks
 
g.g. kor
rdw ict groningen


-- 
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: public roles urgent

[GKor]

the situation is not exactly as you mentioned

after the revoke of the role from public i did not changed the role !!
the point is that the users don't see the tables after i grant the role to
public again without changes to that role.

> -Oorspronkelijk bericht-
> Van:  Ron Rogers [SMTP:[EMAIL PROTECTED]]
> Verzonden:maandag 23 juli 2001 17:29
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: public roles urgent
> 
> GG
> I think it has to do with the internal recording that Oracle uses. 
> You have granted priv's to a role.
> Then granted the role to public.
> revoked the role from public.
> changed the priv's granted to the role.
> granted the role to public.
> 
> With the role revoked does it still show up in the user_role_privs ?
> The changes to the users does not take effect until they log out ond login
> after you have grante the role to public. The user still maintains the
> "old" role privs until their user space is updates on login.
> 
> Test: as dba create table test1( code number, name char(2))
> table created.
> insert into test1 values (1,'xx')
> commit;
> create public synonym test1 for test1;
> create role testrole
> grant select on test1 to testrole;
> grant testrole to public.
> 
> as a user login and select from test1;
> >1,xx
> as a user insert into test1 values (2,'zz')
> denied insuff privs.
> as dba revoke testrole from public
> as dba grant insert, delete , update on test1 to testrole;
> grant testrole to public.
> as a user insert into test1 values (2,'zz')
> denied insuff privs.
> as the user logout and login again to update your "user area"
> 
> as a user insert into test1 values (2,'zz')
> 1 row inserted.
> 
> Have your users logout and login again to pickup the new permissions
> granted to the role.
> ROR mª¿ªm 
> as user 
> >>> [EMAIL PROTECTED] 07/23/01 09:20AM >>>
> Hi everyone
> 
> I have the following situation :
> oracle 7.3.4. on windows NT 4.0 sp5
> 
> 
> I have a public role with several grants in it.
> 
> Then i revoked the role from public today , after that i granted the role
> to
> public.
> 
> Several users are complaining about the follwing  : ORA-00942: table or
> view
> does not exist
> 
> The user still has the public role (via user_role_privs) but doesn't see
> the
> granted tables.
> When i drop and create the user everything is ok.
> 
> Does anyone has a clue why this happens and how i can eliminate this
> without
> dropping the users.
> 
> 
> tia
> 
> g.g. kor
> rdw ict
> the netherlands
> -- 
> 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: Ron Rogers
>   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).

public roles urgent

[GKor]

Hi everyone

I have the following situation :
oracle 7.3.4. on windows NT 4.0 sp5


I have a public role with several grants in it.

Then i revoked the role from public today , after that i granted the role to
public.

Several users are complaining about the follwing  : ORA-00942: table or view
does not exist

The user still has the public role (via user_role_privs) but doesn't see the
granted tables.
When i drop and create the user everything is ok.

Does anyone has a clue why this happens and how i can eliminate this without
dropping the users.


tia

g.g. kor
rdw ict
the netherlands
-- 
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: Function based index - insufficient priveleges

[GKor]

hi 

i found this on metalink

the proper privilege required to create function-based indexes.
Connect as dba and provide the user with the privileges required to create a
function based index.
If the user is creating indexes in their own schema: 
SVRMGR> grant query rewrite to ;
 If the user is creating indexes in schemas other than their own: 
SVRMGR> grant global query rewrite to ; 


> -Oorspronkelijk bericht-
> Van:  Andor, Gyula [SMTP:[EMAIL PROTECTED]]
> Verzonden:maandag 28 mei 2001 12:45
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Function based index - insufficient priveleges
> 
> Hi Gurus !
> 
> Please help me. I can't create function based index because it says:
> 
> 
> ERROR at line 1:
> ORA-01031: insufficient privileges
> 
> I have a table which contains a column called lang_name. I try to create
> function based index on the table with the following  sql statement:
> 
> create index func_idx_lang_name on lang (upper(lang_name));
> 
> I have "create any index privilege"
> 
> Enviroment:
> Oracle 8.1.6 on WinNT
> 
> Thanks in advance.
> Gyula
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Andor, Gyula
>   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).

Bde-oracle

[GKor]

Hi all

Anyone using Nt authentication with oracle 8i and the Borland Database
Engine ?
We got the message invalid user 

oracle 817
BDE version 511

thanks

g. kor
rdw the netherlands
-- 
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: oracle cliënt

[GKor]

you just installed the oracle 8 cliënt software i suppose ?

> -Oorspronkelijk bericht-
> Van:  Trivedi, Hitarth [SMTP:[EMAIL PROTECTED]]
> Verzonden:dinsdag 30 januari 2001 16:00
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:RE: oracle cliënt
> 
> We had problems when we migrated only the database because of the new
> rowid
> format. But our clients were Developer/2000 which uses rowid. We also had
> to
> change ora73.dll from the Oracle 8 cd on all clients for the same.
> 
> Hitarth Trivedi
> Oracle Certified DBA (7.3)
> Sun Certified Java 2 Programmer
> MCSE, MCP+I
> 315-362-1162
> [EMAIL PROTECTED]
> 
>   -Original Message-
>   From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>   Sent:   Tuesday, January 30, 2001 9:00 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:oracle cliënt
> 
>   Hi all
> 
>   Is it a problem to have oracle 7.3.4 cliënts and a oracle
> 8.1.7. server
>   enterprise edition,
>   or is it also necessary to upgrade all the cliënts as well.
>   Most of our applications are developed with Delphi and
> connect via the
>   Borland Database Engine.
> 
> 
>   tia
> 
>   g.g. kor
>   rdw the netherlands
>   -- 
>   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: Trivedi, Hitarth
>   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: oracle cliënt

[GKor]

I believe that the BDE is slowing down the performance but is works good
enough for us with oracle 7.
The problem is if we don't know if the BDE still exists with Delphi 6.
What if we decide to use DOA then all the programs must be redesigned i
believe?

> -Oorspronkelijk bericht-
> Van:  Dennis Taylor [SMTP:[EMAIL PROTECTED]]
> Verzonden:dinsdag 30 januari 2001 16:31
> Aan:  Multiple recipients of list ORACLE-L
> Onderwerp:Re: oracle cliënt
> 
> At 06:00 AM 1/30/01 -0800, you wrote:
> >Hi all
> >
> >Is it a problem to have oracle 7.3.4 cliënts and a oracle 8.1.7. server
> >enterprise edition,
> >or is it also necessary to upgrade all the cliënts as well.
> >Most of our applications are developed with Delphi and connect via the
> >Borland Database Engine.
> >
> 
> How do you like using the BDE? Problems? Complaints? We use DOA with
> Delphi
> 5, and are quite happy with it.
> 
> 
> 
> Dennis Taylor
> 
> Misery loves company, but company does not reciprocate.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dennis Taylor
>   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).

oracle cliënt

[GKor]

Hi all

Is it a problem to have oracle 7.3.4 cliënts and a oracle 8.1.7. server
enterprise edition,
or is it also necessary to upgrade all the cliënts as well.
Most of our applications are developed with Delphi and connect via the
Borland Database Engine.


tia

g.g. kor
rdw the netherlands
--
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).