nls_sort
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 IDM 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
i did exactly the first thing you named. RE: composite primary key versus unique index ---BeginMessage--- 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
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) RE: composite primary key versus unique index ---BeginMessage--- 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
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 IDM 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
thanks all for your quick replies. I think i will write a few triggers to do the trick. Re: fine grained access ---BeginMessage--- 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---
RE: copying datafile nt4-w2k
100% correct Re: copying datafile nt4-w2k ---BeginMessage--- 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=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 http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=68720.15. 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/PASSWORD 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 'oldfullpath\filename' to newfullpath\filename'; 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 'oldfullpath\redologfilename' to lt;newfullpath\redologfilename'; 7. Now open the database: ALTER DATBASE OPEN; Re: copying datafile nt4-w2k 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
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=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 http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=68720.15. 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/PASSWORD 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 'oldfullpath\filename' to newfullpath\filename'; 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 'oldfullpath\redologfilename' to lt;newfullpath\redologfilename'; 7. Now open the database: ALTER DATBASE OPEN; Re: copying datafile nt4-w2k ---BeginMessage--- 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 IDM 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
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 IDM 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
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 IDM 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?
hi try this one, it's a freeware tool called Tora http://www.globecom.se/tora/ Freeware tool to browse data in Oracle tables? ---BeginMessage--- 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: oracle or mssql
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
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
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).
cobol-oracle
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).
X_$KGLCURSOR view
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).
Intrekken: X_$KGLCURSOR view
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).
RE: X_$KGLCURSOR view
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 may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
RE: cache settings NT
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 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).
cache settings NT
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).
grant sysdba rights
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: grant sysdba rights
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).
RE: Accessing Synonym
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 mailto:inventory/invent@test_server Connected. SQL create public synonym company for company; Synonym created. SQL connect scott/tiger@test_server mailto: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
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 user/passwd@alias 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
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
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
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
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
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
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. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:
os block size versus oracle bock size
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
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
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
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).
public roles urgent
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
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
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
you just installed the oracle 8 clint 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 clint 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 clint Hi all Is it a problem to have oracle 7.3.4 clints and a oracle 8.1.7. server enterprise edition, or is it also necessary to upgrade all the clints 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).