RE: Upgrade 8.0.5 to 8.1.6

I would not do that. Those migrate scripts change the catalog tables to support the 8.1.6 engine and do other things. I would never consider upgrading a system without doing that step. -Original Message- Sent: Wednesday, November 21, 2001 10:36 AM To: Multiple recipients of list

Oracle Financials DBA Team Leader Needed in Chicago..

We are searching for an Oracle Financials DBA Team Leader for a client located in downtown Chicago. The individual will perform DBA and supervisory duties for Oracle Financials Systems. Only candidates who already live in the Greater Chicago area can be considered. This is a full time staff

RE: SQL question

Title: RE: SQL question update table_name set id = substr(id,-4); eg: [EMAIL PROTECTED] select substr('48900322',-4) from dual; SUBS 0322 1 row selected. Nirmal. -Original Message- From: Malik, Fawzia [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 7:04 PM

RE: parallize printing reports to different printers

Title: parallize printing reports to different printers You need to give more information when asking a question like this . 1) What are you using for the reports 2) Is this really a database issue ?? Is this some report that is coming from an oracle database or something ? 3) What

RE: SQL question

Fawzia How about: update table set column_name=substr(column_name,-4,4) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, November 21, 2001 11:04 AM To: Multiple recipients of list ORACLE-L Hi, Can you tell me if its possible to write some

Re: SQL question

Or if id is number update table set column_name=TO_NUMBER(substr(TO_CHAR(column_name),-4,4)) JP On Wed 21. November 2001 17:45, you wrote: Fawzia How about: update table set column_name=substr(column_name,-4,4) Tom Mercadante Oracle Certified Professional -Original

Re: Odd Listener.ora Stanza

Marlene goes over it in the networking 101 book -- it's a new feature --- Mohan, Ross [EMAIL PROTECTED] wrote: Anyone seen this fecality in their listener.ora? It's a new one on me, but then again, what with all the newfangled features in this here product, I am probably just losing

RE: SQL question

Fawzia, You should be able to use mod(field,1) to get the remainder of the number divided by 1, which should be the last four digits. Cheers Iain Nicoll -Original Message- Sent: Wednesday, November 21, 2001 4:04 PM To: Multiple recipients of list ORACLE-L Hi, Can you tell

Re: Re[2]: Index File Name

yeah that would work too :) --- [EMAIL PROTECTED] wrote: Rachel, I create a role called 'developer' in each instance at create time. Make it look something like resource, but without the unlimited tablespace priv, and use it in place of resource. saves a step. Dick Goulet

Re: SQL question

Malik, Fawzia wrote: Hi, Can you tell me if its possible to write some sql to change some data. Basically I need to run a scritp to change data of column: id from 12345678 to the last four digits. Is this possible to do in sql/plsql?? Any advice/hints would be greatly appreciated

Problem Running DDL SQL Script

I have this script that will generate a DB with a number of create table and create index statements. When I try to run it in SQL*Plus I get this error: ORA-00959 tablespace SOS2_TBLSPC does not exist. ORA-00942 table or view doesn't exist Here is a sample of one of the create statements:

Re: Index File Name

heck, I've occasionally logged in as system and forgotten to specify the tablespace. power is a dangerous thing --- Stephane Faroult [EMAIL PROTECTED] wrote: Mark Leith wrote: Yeah but for a tightly controlled schema *owner* - what's the problem? Wouldn't you *want* to have

close_cached_open_cursors error

Title: close_cached_open_cursors error Hello Guru's I hope someone can shed light on this problem, more a nuisance really. The below Alter Session statement has been appearing in the *alrt.log file. ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter ALTER SESSION

RE: Oracle 9i and OEM

Have you got all your instances defined in the oratab file? If not, define the missing one and restart the agent and see if that fixes your problem. -Original Message- Sent: Tuesday, November 20, 2001 8:50 PM To: Multiple recipients of list ORACLE-L Hi, I have a problem with

RE: Reliable alerting system that is not so costly??

Hi, There is a free monitoring/alerting system with escalation that is commonly used and is called Netsaint. We are to try this out. Thanks to those who responded. Kumanan -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 21 November 2001 15:52 To:

RE: Re[2]: Index File Name

That's precisely what I do.. I have *_user and schema_owner_developer role with just what they need. No more. No less. However, certain developers will have direct access to tables for coding stored procedures, but those are very limited in number. Standard ksh script to add these users to the

Have a good Thanksgiving--THANKSGIVING_LOAD.SQL

--THANKSGIVING_LOAD.SQL --T. Day, SAI, 21-NOV-01 --Run on WORLD.UNIVERSE using schema with DEITY role declare cursor c_thanksgiving is select PERSON_ID /* NOT SSN -- generated by sequence generator (Jared) */ ,RELATION ,CONDITION from YOUR.LIFE@WORLD where RELATION

Re: RE:

I have next problem , syntax its ok. SQL Startup mount alter database datafile '/data/db/database/core.dbf' offline drop; alter database open; drop tablespace tablespace_core including content; ORACLE instance started. Total System Global Area 178213024 bytes Fixed Size

RE: Upgrade 8.0.5 to 8.1.6

You need to move the database to 8.1.6 (upgrade, run catalog et al). Compatible will just keep certain feature turned off. Henry -Original Message- Sent: Wednesday, November 21, 2001 11:36 AM To: Multiple recipients of list ORACLE-L That's exactly what I was saying I think. ie. To

Re: Fwd: A problem

Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls

RE: applying patch 2032040 to Oracle Purchasing

Matt, I installed the whole HTML/PDF set of manuals that comes with the 11i CD Set onto my laptop. This then provides an indexed version of the manuals in PDF from a HTML page. FWIW, I am also one of those who recently (just about 1 year) 'migrated' from a normal DBA to doing Apps stuff, and

RE: Odd Listener.ora Stanza

For all this means to me I might as well post it on the OT list. LOL!!! yeait makes sense, at least in terms of all of the acronyms being internally self-consistent. Yours in Inflating Acronyms, Ross -Original Message- To: Multiple recipients of list ORACLE-L Sent: 11/21/2001

Re: OT: X Win client

Yes, Xfree86. Just do a search on google. I use it to run Oracle installs, so it works well enough. Jared On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote: Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac

Re[2]: RE:

In many a case on the list we don't have the information to fill in to all sql statements, like in this case the name of the tablespace. The common way to indicate that is to frame the variable with a set or '' brackets. What you need to do is replace the 'tablespace_core' with the rean

Re: Fwd: A problem

Try sumthin' like: EDATE=$(date +%C%y%m%d) FILENAME=name${EDATE}.dmp exp / file=${FILENAME} ... Do a 'man date' to see the different formatting options. HTH, Scott Shafer San Antonio, TX Jared Still wrote: -- Forwarded Message -- Date: Wed, 21 Nov 2001

Re: Upgrade 8.0.5 to 8.1.6

Ed, the whole point of compatable is to mimick behaviour of an older release .. like optimizer plans etc. upgrading the db would be the way to go for this.. like many have already pointed out Deepak --- Ed [EMAIL PROTECTED] wrote: A DBA here is trying to upgrade several 8.0.5 databases to

RE: Fixing a DB

The only problem with this technique is that you won't reclaim the space in the first tablespace that used to be used by the indexes (since the high water marke will be set). If this isn't an issue (either lots of storage space or the data is expected to grow enough to use this space) then I

ftp tools

Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Upgrade 8.0.5 to 8.1.6

Yes, I agree 100%, but people here are concerned that upgrading will break the database, and we have to QUICKLY move everything over to 8.1.6. (Long story). What I was really after in my original question was: why is the upgrade script a better solution than just recreating the tablespaces in

Re: ftp tools

At 01:10 PM 11/21/2001 -0800, you wrote: Does anyone know a site where one can get a FREE gui ftp tool? How about warftp i think that it is www.warftp.com. Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ:

Re: ftp tools

At 01:10 PM 11/21/2001 -0800, you wrote: Does anyone know a site where one can get a FREE gui ftp tool? Sorry it is http://www.jgaa.com. How about warftp i think that it is www.warftp.com. Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see

Re: ftp tools

Terry, check out www.vandyke.com .. Deepak PS: more so check out google.com .. ;) --- Ball, Terry [EMAIL PROTECTED] wrote: Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please

Re: Upgrade 8.0.5 to 8.1.6

Ed, If your databases are more than a couple of gig, upgrading is faster. If over 10 gig, don't even think about importing it. Jared On Wednesday 21 November 2001 13:15, Ed wrote: Yes, I agree 100%, but people here are concerned that upgrading will break the database, and we have to

RE: ftp tools

Terry, WS_FTP is a freeware Check www.tucows.com Regards Suhen Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball,

ORA-4031 error on one instance but not on other

Hi all, I have two 9i instances, one of them consistently produces following error, whereas other doesn't. SQLException:61000java.sql.SQLException: ORA-04031: unable to allocate 1028736 bytes of shared memory (shared pool,unknown object,hash-join subh,kllcqc:kllcqslt) ORA-06512: at

Re: ftp tools

not free, but ipswitch's ftp is nice and cheap ~$400. very easy to admin. http://www.ipswitch.com/ gene [EMAIL PROTECTED] 11/21/01 16:55 PM Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 --

RE: Upgrade 8.0.5 to 8.1.6

When I did this, the migration assistant was much quicker than export/import. Kent Yes, I agree 100%, but people here are concerned that upgrading will break the database, and we have to QUICKLY move everything over to 8.1.6. (Long story). What I was really after in my original question

RE: Upgrade 8.0.5 to 8.1.6

Yes it will save time as well ..all the upgrade does is mess the datafile headers so they are 816 format also the upgrade script will simply re-initialze the catalog to 816 is also quite fast and will complete in a few minutes .. if you have a 1TB db for e.g. upgrade would definitely be a far

RE: ftp tools

If you are using TOAD, there is one in there ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have

RE: Upgrade 8.0.5 to 8.1.6

Ed: If you track down the 8i migration manual, here's a comparison chart that shows the benefits of export/import versus migration (using the u scripts). It depends on your database configuration, but yes, the main benefit in using migration is speed. If your database is relatively

Re: ftp tools

At 02:10 PM 11/21/2001 -0800, you wrote: not free, but ipswitch's ftp is nice and cheap ~$400. very easy to admin. http://www.ipswitch.com/ www.cuteftp.com only $35 gene [EMAIL PROTECTED] 11/21/01 16:55 PM Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry

RE: Upgrade 8.0.5 to 8.1.6

Thanks all. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Upgrade 8.0.5 to 8.1.6

Correct me if I am wrong, but you don't migrate from 8.0 to 8.1. You just start up on the new binaries and run u080005.sql or something. The migration utility is for 7.x to 8.x. Read the manual. Re-creating the database, then exporting and importing will take much longer than just running a

Re: OT: X Win client

Try xwin32 from starnet -- On Wed, 21 Nov 2001 10:15:25 Jared Still wrote: Yes, Xfree86. Just do a search on google. I use it to run Oracle installs, so it works well enough. Jared On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote: Hi all! Is there any free

RE: Upgrade 8.0.5 to 8.1.6

Ed: If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a potential difficulty you need to know about. If you're not aware of the dictionary corruption problem, be sure you read the metalink alert (96117.1). This has something to do with block checking enabled in 8.1.6

Re: Upgrade 8.0.5 to 8.1.6

Yes, Oracle actually calls it an upgrade. I think the point everyone wanted to make though was it's not a good idea to just start your database with the 8.1 binaries. Jared On Wednesday 21 November 2001 16:40, Jeremiah Wilton wrote: Correct me if I am wrong, but you don't migrate from 8.0 to

Re[2]: Odd Listener.ora Stanza

Wednesday, November 21, 2001, 10:56:45 AM, you wrote: DK Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75, DK 85-86 in particular. Yeah, but I don't have any experience with the GIOP presentation. Like Srini pointed out earlier, it allows the listener to handle the

Re: TNS Listener service question

If I understand you correctly, you are shutting down a listener on your NT box, and then, from your NT box, you are connecting to a remote database using SQL*Plus. Am I understanding you correctly? You shouldn't need to have a listener running on your NT box to connect to a remote database, so

RE: applying patch 2032040 to Oracle Purchasing

There is a good article in Select Magazine (IOUG) Q4 2001 on Oracle Apps patching. Worth checking out. Gerardo -Original Message- Sent: Tuesday, November 20, 2001 6:00 AM To: Multiple recipients of list ORACLE-L After applying the c.drv portion of the patch, I'm attempting to

RE: VMS equivalent of ls -lrt

-- Hallas John [EMAIL PROTECTED] Top Man Rich. Works well and a satisfied user for the first time in my career!! Nice bit of coding, especially the line formatting bit DCL is a nice language to work in I always found. Once you know what lexicals are available it is amazing what you can

RE: Index File Name

I knew I'd forget something :) thanks Kirti! --- Deshpande, Kirti [EMAIL PROTECTED] wrote: And while making sure those tablespaces exist, I would also make sure that the user running the script has sufficient quota on those tablespaces. - Kirti -Original Message- From:

OT: X Win client

Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac

RE: Index File Name

And just to add to that - make sure that the user has the appropriate privileges on the system, such as CREATE TABLE / INDEX, or the role RESOURCE or whatever.. :) Just to nitpick :) -Original Message- Carmichael Sent: 21 November 2001 09:35 To: Multiple recipients of list ORACLE-L I

Re: PL/SQL package to emulate MySQL functions?

On Mon, Nov 19, 2001 at 11:50:20AM -0800, [EMAIL PROTECTED] wrote: I do know that when I used Migration Workbench to migrate an Access database to Oracle, it created Oracle PL/SQL functions to emulate Access builtins that Oracle doesn't duplicate - (ANDN, CCUR, CDBL, CINT, DATEADD, EQN, ERIC,

Re: Index File Name

Mark Leith wrote: And just to add to that - make sure that the user has the appropriate privileges on the system, such as CREATE TABLE / INDEX, or the role RESOURCE or whatever.. :) Just to nitpick :) NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you cannot grant it

Reliable alerting system that is not so costly??

Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com

RE: Metalink gone to sleep ?????

OK, Let's do a poll. Someone else says they have access. Could it be the browser? I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in. I am going to try from one of the servers (IE 5.0) to see what the result is. [...] IE 5.0 SP2 -- no problem accessing MetaLink. So it could

Re: OT: X Win client

X client? Don't know, but there are some free X servers for NT on the I-net. :-)) But this is Oracle maillist. JP On Wed 21. November 2001 10:40, you wrote: Hi all! Is there any free (important: free) X client software for NT? Regards, Vladimir Barac

RE: Metalink gone to sleep ?????

To all: I have IE 6.0 and NT Workstation 4.0 SP6 on my PC. My metalink entry is bookmarked. I click it, the log in screen comes up immediately and I'm in! I did a search on rollback and it returned the result very quickly.I also tried the attempt with Netscape Navigator 4.0.8. I tried:

Re: Reliable alerting system that is not so costly??

Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL

MetaLink Access: Solved (for me at least)

OK, I think I figured it out - had to clear the Internet Cache for IE. After I did that, I could access MetaLink. Don't know why though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J

tablespace

Hello I need a help with one problem. In the Oracle version 8.1.7 I´ve deleted a tablespace in the Linux, but before this I did´t use a function Drop. After reboot a database, there was a error: ERROR at line 1: ORA-01116: error in opening database file 7 ORA-01110: data file 7:

RE: Metalink gone to sleep ?????

NT 4.0 SP 6 with both IE 5.5 SP 1 and Netscape 4.73 Working... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Boivin,

RE: Upgrade 8.0.5 to 8.1.6

Title: RE: Upgrade 8.0.5 to 8.1.6 Ed, There's more to it than just setting the COMPATIBLE parameter. The basic steps are 1) install new 8.1.6 executables 2) copy init.ora file from old 8.0.5 home to 8.1.6 home, making whatever modifications are necessary due to new or obsoleted

RE: Metalink gone to sleep ?????

I tried to login thru metalink.oracle.com and logged in immediately. I was able to query and results were faster. I tried looking for RMan and it came up immediately. Srikanth, Saint louis, MO -Original Message- Sent: Wednesday, November 21, 2001 7:05 AM To: Multiple recipients of

RE: applying patch 2032040 to Oracle Purchasing

Title: RE: applying patch 2032040 to Oracle Purchasing I looked in metalink and maybe I'm just blind, but I don't find a 'Maintaining Oracle Applications' manual. URLs would be greatly apprecieated. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an

Re: Metalink gone to sleep ?????

[EMAIL PROTECTED] wrote: NT 4.0 SP 6 with both IE 5.5 SP 1 and Netscape 4.73 works fine with IE6 and Netscape 6.2 on Win2K. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED]

RE: Fixing a DB

Why not just create the tablespace and move the indexes? alter index rebuild with new storage parameters. -Original Message- From: Ken Janusz [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 8:26 AM To: Multiple recipients of list ORACLE-L Subject: Fixing a DB

RE: Metalink gone to sleep ?????

This is strange..I could not log into Metalink using the link metalink.oracle.com. But I could log in using the link oracle.com/support/metalink. Whats happening here, guysn and gals ?? Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL

RE: MetaLink Access: Solved (for me at least)

There's an easier fix: http://www.opera.com :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, November 21, 2001 06:25 To: Multiple recipients of list

RE: Index File Name

Title: RE: Index File Name Alistair I think you'll find that packages don't get stored in a tablespace per se... like you are describing below. They are stored in the data dictionary. So you don't need to allocate specific storage for them (other than the system tablespace) and for the most

Re: Fixing a DB

Ken, I don't think you will need steps 2 thru 5. After step 1, just write sql that will spool out alter index blah rebuild tablespace new_tablspace run the resulting sql. Will that work ? HTH Srini Chavali Oracle DBA Cummins Inc Ken Janusz [EMAIL PROTECTED]@fatcity.com on 11/21/2001

RE: applying patch 2032040 to Oracle Purchasing

Try clicking Technical Libraries, then Applications Install Upgrade under ERP Applications, then click Documentation link and viola ! HTH Srini Chavali Oracle DBA Cummins Inc Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on 11/21/2001 08:30:24 AM Please respond to [EMAIL

RE: Backup strategy

Bing, Please explain your reasoning for backing up the archivelogs when you backup the readonly tablespaces. One reason you change a tablespace to read only is to reduce the backup needed. After a tablespace is in read only mode no changes are made to the data and you only need to back it up

Re: Fixing a DB

Sorry forgot the command in my earlier email To recap, here are the steps 1. create the new tablespace 2. For all indexes that need to be moved, run the fol command alter index index_owner.index_name rebuild online tablespace new_tablespace; From: Ken Janusz [EMAIL PROTECTED] Reply-To:

RE: Upgrade 8.0.5 to 8.1.6

When I read through Oracle's migration info it looks to me like all init ora params from 8.0.5 are supported, though obsolete, in 8.1.6. What is the point of the compatible parameter then if you have to run the conversion script on the database? Thanks for answering. Best, Ed On Wed, 21 Nov

RE: Oracle 9i and OEM

Sepi, Just a guess - are all three instances listed in your /etc/oratab file? I'm pretty sure OEM looks at that to determine what instances the Agent should monitor. I could be wrong on this though - it's been a while since I've looked at OEM. JIm

RE: Metalink gone to sleep ?????

I have no problem accessing metalink in NYC. Could this be a local DNS, network issues to certain locations? [EMAIL PROTECTED] 11/21/01 08:35AM This is strange..I could not log into Metalink using the link metalink.oracle.com. But I could log in using the link

RE: MetaLink Access: Solved (for me at least)

LOL! *yes* !! -Original Message- Sent: Wednesday, November 21, 2001 9:40 AM To: Multiple recipients of list ORACLE-L There's an easier fix: http://www.opera.com :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

TNS Listener service question

I noticed that if I leave the TNS Listener service stopped on my NT workstation, I can't access anything using the GUI tools. But my script that runs command line can successfully login to the remote databases to verify that they are accessible. It uses c:\oracle\ora81\bin\sqlplus.exe. Do the

RE: Index File Name

Yeah but for a tightly controlled schema *owner* - what's the problem? Wouldn't you *want* to have unlimited tablespace for the schema owner - which the users *should not* have access to anyway? (no this is not rhetorical - I have no production experience) Thanks Mark -Original

RE: MetaLink Access: Solved (for me at least)

The only thing I don't like about Opera is the ads. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Jesse, Rich [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:40 AM To: Multiple recipients of

Re: TNS Listener service question

Patrice, SqlPlus uses the Bequeath protocol to access local databases if the @ is omitted in the connect string. If the @ is present (i.e. connect scott/tiger@db) then it uses Net8. See Note 118381.1 on Metalink. HTH Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL

RE: MetaLink Access: Solved (for me at least)

It certainly does!! I run IE6, Netscape 6 Opera 5.12 on a Win2K box. Opera is pretty cool! Though I sometimes have problems with things like DHTML in it.. Has anybody else seen this problem? Mark -Original Message- Gramolini Sent: 21 November 2001 15:10 To: Multiple recipients of list

RE: MetaLink Access: Solved (for me at least)

YES, it is a standard browser...follows all the rules. and so. any special tweaks that IE has given you over Netscape or over the browser standardare not supported.. Try it! My experience with it was very positive. -Original Message- Sent: Wednesday, November 21, 2001

RE:

cascade? probably more abject ignorance on my part, but wasn't it including contents? -Original Message- Sent: Wednesday, November 21, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Startup mount alter database datafile '/data/db/database/core.dbf' offline drop; alter database

RE: Upgrade 8.0.5 to 8.1.6

Ed, COMPATIBLE is there to allow backwards compatibility. If you upgrade from 8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will not be turned on, allowing an easier port back to 8.0.5 if necessary. Quoting from Oracle8i Reference Release: COMPATIBLE lets you use a new

RE: Oracle 9i and OEM

OEM does autodiscover based on what method of networking you told it to used when you configured autodiscovery: Names Server, tnsnames.ora, or directory server. We use tnsnames.ora and OEM looks to see what the SID names are in tnsnames.ora for sure. It may do this in conjunction with the

RE: Odd Listener.ora Stanza

Never mind, this is an IIOP operability hook. -Original Message- Sent: Wednesday, November 21, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Anyone seen this fecality in their listener.ora? It's a new one on me, but then again, what with all the newfangled features in this

Re: Index File Name

standard create user script for a user who will own objects: create user xyz identifed by abc default tablespace default temporary tablespace temp quota unlimited on default / grant connect, resource to xyz / revoke unlimited tablespace from xyz / I've gotten this drilled into my people's

Re:RE:

OOPS! sorry, your right Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 11/21/2001 7:40 AM cascade? probably more abject ignorance on my part, but wasn't it including contents? -Original Message- Sent: Wednesday, November 21,

Re: Index File Name

Mark Leith wrote: Yeah but for a tightly controlled schema *owner* - what's the problem? Wouldn't you *want* to have unlimited tablespace for the schema owner - which the users *should not* have access to anyway? (no this is not rhetorical - I have no production experience) Thanks

Re[2]: Index File Name

Rachel, I create a role called 'developer' in each instance at create time. Make it look something like resource, but without the unlimited tablespace priv, and use it in place of resource. saves a step. Dick Goulet Reply Separator Author: Rachel

RE: Odd Listener.ora Stanza

Ross, fecality? Is that the F in RTFM? Well, things are pretty slow here (who am I kidding. They have been, no wait. It has been pretty slow here for months) so I grabbed my Net8 book. Not that this makes a lot of sense, but this is what it says. PRESENTATIONIdentifies the presentation

RE: RE:

Jaysus, note the date and time. It's a freaking miracle. ;-) -Original Message- Sent: Wednesday, November 21, 2001 10:54 AM To: Mohan; Ross; Multiple recipients of list ORACLE-L OOPS! sorry, your right Reply Separator Author: Mohan; Ross

RE: Oracle and MQ

Title: RE: Oracle and MQ Tony - Do you have error handling built in to your VB program, or do you just load it into Oracle and then cleanse/validate the data there? Do you think it would also be possible to access MQ viaexternal stored procedures? -Original Message-From:

SQL question

Hi, Can you tell me if its possible to write some sql to change some data. Basically I need to run a scritp to change data of column: id from 12345678 to the last four digits. Is this possible to do in sql/plsql?? Any advice/hints would be greatly appreciated Rgds Fawzia

RE: Odd Listener.ora Stanza

Something to do with external procedure calls, Java support, GIOP support in 8.0.x versions ( 8i) Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75, 85-86 in particular. Cheers! - Kirti -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent:

RE: MetaLink Access: Solved (for me at least)

huh? Did you buy it, or just trial it? there are no ads in the regular version, AFAIK -Original Message- Sent: Wednesday, November 21, 2001 10:26 AM To: Multiple recipients of list ORACLE-L The only thing I don't like about Opera is the ads. Regards, Patrice Boivin Systems Analyst

Re: Odd Listener.ora Stanza

Ross, It's CORBA stuff. See note 69043.1 on Metalink. HTH Srini Chavali Oracle DBA Cummins Inc Mohan, Ross [EMAIL PROTECTED]@fatcity.com on 11/21/2001 10:15:27 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

  1   2   >