Re: Standby Databse Problem

09:08:18 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, --Winnt 4.0, Oracle 8.1.7.--- We have slight problem with our Standby Database Configuration

Re: Installing 8i on Windows 2000 Server / Pentium 4

server 512 MB RDRAM Jack David McVeigh [EMAIL PROTECTED]@fatcity.com on 13-02-2002 09:13:27 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) I know there have

Reorganising Database

Hi All, I am currently testing a database reorg and am facing extremely long table drop times due to too many extents. This is expected but is there a way to speed things up?? Jack === De informatie verzonden in dit

Scrolling Sideways in SQL*Plus

Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack

Re: Scrolling Sideways in SQL*Plus

by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't

RE: Euro Character Set

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) Thanks. We currently have WE8IS08859P1 set...to display a euro symbol, would I need to alter the nls parameters to do

Re: export/import on the same server

) Jack Farnsworth, Dave [EMAIL PROTECTED]@fatcity.com on 05-02-2002 15:20:34 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) I have a question on the export/import

RE: Euro Character Set

] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) To convert WE8IS08859P1 to WE8IS08859P15..would I need to do the export/import??Metalink presents the following solution (in restricted session): alter

Re: Backup and Recovery

on 04-02-2002 05:05:19 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) Listmembers, Are there any gotchas with restoring just one datafile from a hot backup

RE: Microsoft plans to bundle iFS copycat into it operating syste -- Attachment

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) yste Okay ... does anyone know what are Microsoft's own inventions? Raj

RE: Microsoft plans to bundle iFS copycat into it operating syste -- Attachment

Hi Sorry Kevin missed your post Jack [EMAIL PROTECTED]@fatcity.com on 30-01-2002 09:05:22 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) yste

RE: Rman again. Long screen output removed

PROTECTED]@fatcity.com on 30-01-2002 10:25:18 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) Subject: RE: Rman again. Long screen output removed Jack, Your

RE: Rman again. Long screen output removed/SOLVED

Hallas John [EMAIL PROTECTED]@fatcity.com on 30-01-2002 10:25:18 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) Subject: RE: Rman again. Long screen output

RE: Performance Tuning

van Zanen/nlzanen1/External/MEY/NL) Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti Oracle Performance Tuning 101

Re: Total extents

Zanen/nlzanen1/External/MEY/NL) Could I use the following query to get the total used extents :- SELECT t.tablespace_name, t.initial_extent, t.next_extent, t.min_extents, t.max_extents, t.pct_increase, status, contents, sum(extents) FROMsys.dba_tablespaces t

Re: how to grant selct on all the ables in schema

ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi all, Is there anyway of granting select on all the tables in a schema in one shot. Regards STAARSHIP TECHNOLOGIES www.staarship.com

RE: Rman again. Long screen output removed/SOLVED

PROTECTED]@fatcity.com on 30-01-2002 10:25:18 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) Subject: RE: Rman again. Long screen output removed

Rman again. Long screen output included

Hi , I copied jay's line for duplication until time exactly into my test script but recovering errors out in the end. I looked in the documentation for another example of the until time clause but no luck. Can anybody explain why this won't work. (the double single quotes to which it

RE: Rman again. Long screen output included

Hi Thomas, AFAIK this is generated code (by RMAN) based on the command duplicate that I issued. I sure didn't store any script yet. This is the next step when all secrets of RMAN are uncovered (than it's time to move to RMAN 9i) Jack Mercadante, Thomas F [EMAIL PROTECTED] on 29-01-2002

Re: Pl/sql question

Hi, Not much experience with pl/sql but.. [EMAIL PROTECTED]@fatcity.com on 28-01-2002 09:40:20 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) Hallo

RE: More Rman q's

Hi, Am I misreading all this, but should the auxiliary database be in existence before I can Clone to it? I created the init.ora and all directories and started TEST3 in nomount. I created the password file and can connect to it with a connect string no problem. Another point is. Did you mean

RE: More Rman q's /SOLVED dunno how

PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi, Am I misreading all this, but should the auxiliary database be in existence before I can Clone to it? I created the init.ora and all directories and started TEST3

Yet again more Recovery Manager questions

Hi All, I have a mixed environment 8.0.5 8.1.7 databases. I can not use the same catalog for both versions. I tried creating a new catalog for my 8.0.5 databases (different owner) in the same 8.1.7. database that my other catalog is in using the rman 805 executable. This also results in

Re: v$session question

Hi, Try module in v$session (just a guess) Jack Joe LaCascio [EMAIL PROTECTED]@fatcity.com on 25-01-2002 15:35:24 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

More Rman q's

Hi All, Trying my first attempt to clone a database using rman and ending up with errors. Situation: TEST1 database = catalog Status=OPEN TEST2 database= target database and to be cloned status= OPEN TEST3 database= future clone of TEST2 status = NOMOUNT (as per docs) I have all sorts of

Re: Encrypting Oracle Stored procedures

-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http

Re: Ftp command

[EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any

Re: RMAN backup and restore Q?

14:10:24 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) What version of the database are you using? My info here is based on 8.1.7. I connect to my databases

Re: TNSPING

] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi When I run tnsping servername on web server .Some of server shoe at bottom OK (10 msec) some of them are OK (50 msec) and some of them are OK (100 msec) What this meaning is? Which

RMAN backup and restore Q?

Hi All, I'm in the process of figuring out the workings of RMAN and created 2 test databases. TEST1 = catalog database TEST2 = target database I have created the catalogs and registered the database with the catalog. I than mad a full backup of the database TEST2 (is in Archivelog mode) with

Re: Need SQL*Loader Coding Help

/nlzanen1/External/MEY/NL) I need some help coding this scenario. I have multiple records coming in a delimited flat file. Some of the records are: RegNumber Cnum1 Cnum2 . . . Cnum10 There can be data in 1 to 10 of these fields. I need to load this into this table. Trademark_Class_Data

Re: Unix question

[EMAIL PROTECTED]@fatcity.com on 11-01-2002 13:25:18 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) Hallo, why do I get the error message No such file or directory

Re: A Simple Rollback Segment Question

recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Personally I never create one. First thing I do though is create the rbs tablespace with a couple of rollback seg's before all other create scripts. Yes, but in the pre-historic days, you couldn't create

Re: A Simple Rollback Segment Question

with a couple of rollback seg's before all other create scripts. Jack Naveen Nahata [EMAIL PROTECTED]@fatcity.com on 08-01-2002 10:50: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

Re: not using indexes

on 04-01-2002 06:40: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) Dear All, I have been entrusted to tune a web based application. This product is at development

Re: not using indexes

PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) I have analysed the schema using dbms_utility -- On Thu, 03 Jan 2002 23:25:18 nlzanen1 wrote: Hi, Tables Analyzed recently? Indexes

Re: Problem Granting Roles

problems (be specific to avoid the nasty RTFM reply) Jack Ken Janusz [EMAIL PROTECTED]@fatcity.com on 02-01-2002 13:30:17 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

Re: Shutdown Normal

Hi, After you've kicked them out already you can also do an alter system enable restricted session. (no need to shut it down if for instance batch jobs are already running) This will allow anybody with restricted session privileges to connect to the database (DBA role has it included). Jack

RE: sort aggregate vs sort order by

Hi Larry THX Jack Larry Elkins [EMAIL PROTECTED]@fatcity.com on 28-12-2001 14:25:18 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) Jack, I assume you

sort aggregate vs sort order by

Hi All, I have tried the Oracle Doc's but can't find the answer to what is the difference between the two Anybody can explain?? TIA Jack === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de

Re: Weid exp/imp problem

a parfile) Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 19-12-2001 09:25:20 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! I'm experiencing a weird

Startup O9i remote / SOLVED

Hi All, Having a SPFILE doesn't mean you do not need a local init.ora file anymore. It's just that it became a oneliner with just the SPFILE parameter specified. Jack === De informatie verzonden met dit E-mail bericht is

startup remote instance 9i

Hi All, client 8.1.6 (NT) Server 9.0.1 (W2K) I'm trying to start/stop the instance remotely and am not succeding. First it complains about obsolete parameters JOB_QUEUE_INTERVAL MTS_DISPATCHERS, but they should not be there since they are not in the pfile, nor the spfile (both on server)

Re: Find DBA users

:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden

RE: Find DBA users

attached. ah well we'll get it to work somehow. Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 26-11-2001 15:55:19 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

Re: How to port a DB(Ora815) on a different server (sameOS) but Ora817?

ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) ut Ora817? That won't work buddy, you will have to use the migration/upgrade tool to update the Data files to the new 'format' that oracle 8.1.7 uses if you want to copy it straight across. The easiest way would

Re: hide password

: Jack van Zanen/nlzanen1/External/MEY/NL) Jack, I think you are referring to PARFILE... Suren -Original Message- Sent: Thursday, November 15, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED

Re: DBA CHECKLIST

/nlzanen1/External/MEY/NL) hi, is there a dba checklist to know a dba does? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: hide password

Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] @fatcity.com on 15-11-2001 14:10:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1

Enqueue tuning

Hi All, I have a batch job that seems to have a lot of enqueue waits (second longest wait time (337156 cs?) from v$session_event). I have read that increasing the enqueue resources does not solve this problem as I have no ORA-52 ORA-53 errors. (I have increased it by a factor ten to try it

Re: How do you change default oracle home?

PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi I have Oracle, 8,8i,9i installed on Win 2k. I want to have 9i as default oracle home. Where can I do that? I have tried using Oracle Home selector which was set to 9i but still defaults to reading service name from 8.0. Oracle help says

Re: sqlquestion

] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 and I want the select the select to giv e me this: Jimmy Timmy How can I change this statement? SELECT ltrim(substr(mxurval_namn

Re: Ang: RE: komplex sql

] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) But if I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I solve this: I just want the last word in the field

Re: Login Scripts

] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hey gang; Is there any way to get your login script to run whenever the connection is change instead of just when sqlplus starts up ?? I have a script that displays the instance name when I log in but when I do a connect after sqlplus

Re: Insert into ... as select ...

] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello everybody, I have a problem to find the correct syntax for the following operation: The first table: SQL describe grandeur_mesure; Name

RE: 9i install on Win2K

golf handicap by now? take care Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 13-11-2001 11:15:20 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) Oh, don't

Re: Snapshot

20:20:17 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 List, I never used any snapshot, just want to know what's the usage of snapshot and what's

RE: recovery database!!

[EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) ok i need know is possible recover the database with only the datafile. If only have a datafiles the any database i can recreate a new db and use this datafiles... @lex

RE: Script for next_extent of objects = free space available

Hi, I have this Space Bound object script that will list every table that can not allocate it's next extent. It will not list tables in tablespace that is set to autoextent. This is not entirely correct as you may have set an upper limit to the auto extent (if you feel like adding it in please

RE: Instance Name in Sql Prompt

van Zanen/nlzanen1/External/MEY/NL) Thanks to Kevin and all that reply. I noticed when doing a connect inside a session. This will help. Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En

Re: ORA-04031, how to prevent fragmentation?

Hi, *Pin packages into the shared pool *enlarge the shared pool *flush the shared pool at regular intervals *use bind variables i.s.o hardcoded values or a combination of those Jack Blum, Marc [EMAIL PROTECTED]@fatcity.com on 26-10-2001 11:55:18 Please respond to [EMAIL PROTECTED]

Re: Sql not exists

PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hallo you DBA' Can anyone give me a good example on a sql select statement checking which ids exists in table one but not in table two? Table

Re: Instance Name in Sql Prompt

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 Friends, Excuse me for this dumb question, how do I display the instance name in the sql prompt. Have 3 DB and would like

DB FILE PARALLEL WRITE

Hi, I have this DB FILE PARALLEL WRITE as the top event (right after SQL*NET,rdbms.,pmon smon) and according to the documentation this has to do with my DBWR but no mention is done on how to solve this. Is this purely another indication of poor disk performance or should I be looking

Re: os block size versus oracle bock size

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

Re: Restricted mode

Hi Alter system disable restricted session; Jack Joe LaCascio [EMAIL PROTECTED]@fatcity.com on 05-10-2001 15:35:17 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1

Re: Platform

by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output

Re: Preventing user access

PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want

Tracing a sql statement also to include bind variables

Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend

Re: Tracing a sql statement also to include bind variables/SOLVED

PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter

Re: I/O Performance/bottlenecks on EMC Symmetrix

??), correct .? Jack Jonathan Lewis [EMAIL PROTECTED]@fatcity.com on 13-09-2001 22:20:50 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) !! Please do

Re: I/O Performance/bottlenecks on EMC Symmetrix

Jack Don Granaman [EMAIL PROTECTED]@fatcity.com on 14-09-2001 10:20:17 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) !! Please do not post Off Topic to this List

Re: which patch number?

van Zanen/nlzanen1/External/MEY/NL) !! Please do not post Off Topic to this List !! Hi Which oracle patch number is required to upgrade from 8.1.7.0 to 8.1.7.2? Thanks in advance -Seema _ Get your FREE download of MSN Explorer at http

Re: Lots and lots of redo logs

15:20:18 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) !! Please do not post Off Topic to this List !! I am planning setting up a new database with the redo

Re: Webserver..

PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi Listers, Now, I want to publish the customer information (lets say address,phone number,etc) from Oracle 8.0.5 on the web. Do I need Oracle

RE: db link from oracle 8.1.7 to 8.0.5

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) I think I forgot to mention that a public synonym has to be involved... Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head

I/O Performance/bottlenecks on EMC Symmetrix

!! Please do not post Off Topic to this List !! Hi All, Does anybody here on the list have experience with EMC/symmetrix storage units.? We have our databases on this machine and I have a feeling the the I/O performance is not very good. I can not proof it since I do not have any

EBU Question

!! Please do not post Off Topic to this List !! Hi All I have following request. At one of our customers site they are working with EBU and since I have no knowledge of this I figured to tap into the list's

Re: I/O Performance/bottlenecks on EMC Symmetrix

] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) !! Please do not post Off Topic to this List !! WOW! Is the other workload on these similar when this job runs? Are you sure the problem is the Symmetrix and not something in the OS or instance configuration? Does this job spend a lot of time

Re: db link from oracle 8.1.7 to 8.0.5

/nlzanen1/External/MEY/NL) hi list, i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5, but its failing, giving message DB LINK NOT ACTIVE global_names parameter is false on both the database, the schema in which its being created exists in both the databases with same password

Re: Is 9i Certified with NT and 11i?

] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Given the events of the day this is a very insignificant question. Is 9i certified with NT/2000 and 11i? Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http

Re: Need some help: Table Space Free Space

/nlzanen1/External/MEY/NL) Hello all, I have an interesting problem on hand. I am using the following query to determine the free space in table space and corressponding data files:- SELECT d.tablespace_name,d.file_name, SUM(d.bytes)/1048576, free_space/1048576, extent_cnt

Re: Need some help: Table Space Free Space

ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello all, I have an interesting problem on hand. I am using the following query to determine the free space in table space and corressponding data files:- SELECT d.tablespace_name,d.file_name, SUM(d.bytes

RE: db link from oracle 8.1.7 to 8.0.5

by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Try doing a describe across that db link from 8i to 8.0.5... Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin Operations Bedford

NLS_ Client settings

Hi All, Someone came up to me today with a list of 17 NLS parameters and wanted to know what the settings were on our clients. I have been able to find some of the parameters in the v$nls_parameters view and asssume that these are client/session related since they change with alter session

Re: ORA-12705 - REALLY URGENT

Hi, What is exactly that you are trying to do. Alter session? What syntax? Start the database? What O/S? What is your environment like (on UNIX env |grep nls) Jack Viraj Luthra [EMAIL PROTECTED]@fatcity.com on 11-09-2001 12:05:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL

Re: dbms_jobs

on 07-09-2001 08:00: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) Any thoughts on how this was scheduled this way? Schedule a job that takes 10 minutes, set

Re: PK Violation on insert

:40:34 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) Good Morning, I am selecting information from 3 tables and inserting it into a new table. My compound primary

Re: PK Violation on insert

out how it works. Jack Rusnak, George A. [EMAIL PROTECTED]@fatcity.com on 07-09-2001 14:40:34 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) Good Morning, I am

Re: dbms_jobs

PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) I was wondering if you schedule a job to run every hour and say the job takes 2 hours to run. Will the next run of the job queue up or will it run in parallel with the current job

Re: Standby database

to get rid of it. Thx Jack Ray Stell [EMAIL PROTECTED]@fatcity.com on 04-09-2001 00:00:23 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) On Mon, Sep 03

Re: Standby database

: Jack van Zanen/nlzanen1/External/MEY/NL) Well, you can configure the tnsnames.ora to check multiple listeners, so you do that... the first listener/port you check is the primary, the second is the standby From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE

Standby database

Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle

Re: is this a resource problem?

recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) hi guys, first sorry my English and second sorry if this is a stupid question (or it's the wrong place to ask it) I'm new to Oracle (few mounts) and I developed a search engine for my Univeristy. One

Re: Convert 7.3 users to 8.17 users

] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi all Can I take all the users created in a 7.3 database and somehow import them into a 8.1.7 database with the original passwords and roles/access

Re: results of analyze

Hi DBA_TABLES DBA_INDEXES ORACLE 8.0.5 Jack Ruth Gramolini [EMAIL PROTECTED]@fatcity.com on 29-08-2001 15:40:33 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

Re: tnsnames error

PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) I am getting an error when I try to connect to the DBA Studio of Or9iAS the error is failed to parse tnsnames.ora file Error:100 --NLNV-NLNV

Re: startup time v7

Try v$thread instead jack Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on 24-08-2001 20:21:31 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

Re: pl/sql examples

Hi Try www.revealnet.com Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] @fatcity.com on 25-08-2001 10:25:39 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1

Re: Nested loop very slow

, Remco To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] R.Daemen@face cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) nt.nl

  1   2   >