RE: Unable to rebuild database from hot backup

, shutdown, and opened the database. It worked fine. Why would it work with a standby controlfile and not with the regular control file? I have my QC database working but I'm really puzzled. Jay Miller -Original Message- Sent: Thursday, October 25, 2001 7:05 PM To: Multiple recipie

Unable to rebuild database from hot backup

ow I'm really concerned that my hot backup is invalid for some reason. Does anyone have any suggestions for what else I can look at? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (

Concealing SQL Loader password from ps -ef

When running Sql Loader from a Unix script is there a way to code it so that the password will not be displayed when someone does ps -ef? I know how to do it for sqlplus, exp and imp but not sql loader. TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: SOLARIS VERSION

I tried to log into Metalink to get the matrix for you but it was down. But I just came across a printout so here it is. 8.1.7 is compatible with 2.6, 2.7 and 2.8. It is not compatible with 2.4 or 2.5. Jay Miller -Original Message- Sent: Wednesday, October 17, 2001 6:20 PM To

RE: getting password request on connect internal

running on the same machine. And they've been running (with a nightly shutdown) with no problems for the last 2 weeks. Jay Miller -Original Message- Sent: Friday, October 05, 2001 11:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] are you part of the dba, oinstall group? >>> [E

RE: getting password request on connect internal

Yep. In fact I had no problem connecting to another instance running on the same machine. And they've been running (with a nightly shutdown) with no problems for the last 2 weeks. Jay Miller -Original Message- Sent: Friday, October 05, 2001 11:56 AM To: [EMAIL PROTECTED]; [

RE: getting password request on connect internal - more info

any results. Any ideas? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

getting password request on connect internal

internal Password: I've already gone through every step in the Oracle Note 69642.1 (Checklist for Resolving CONNECT INTERNAL PASSWORD Issues) without any results. Any ideas? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay

RE: Dropping table is not completing

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

RE: When optimizer reevaluate SQL statement

Yes, but I think Chris' point was if each statement was accessing the *same* table (say, through a public synonym) then running it under a different user wouldn't cause a hard parse. Maybe I'll have time to check this myself tomorrow, right now I have to leave. Jay Miller -O

RE: ORACLE VS. SYBASE

who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I

RE: 2nd DBA or ?

ECTED] (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://

RE: Design Issue - Quick response appreciated

as the only prior_id column. With regards to the second question you can then go back as far as you like using the START WITH/CONNECT BY clauses in your SELECT statement. Jay Miller -Original Message- Sent: Friday, September 21, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Jay

RE: Design Issue - Quick response appreciated

to have a different account. Jay Miller -Original Message- Sent: Friday, September 21, 2001 12:35 PM To: Multiple recipients of list ORACLE-L List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari

RE: 2nd DBA or ?

Not to mention having the time to study and read. I'm back to the Oracle 101 Performance Tuning Book for the first time in over a month today. And that's only because all changes have been frozen except for Disaster Recovery... Jay Miller -Original Message- Sent: Friday, Se

RE: Better Way Of DeFragmentation

, and move the datafiles from the cold backup that contained the appropriate tablespaces. I don't think that that would work. "Miller, Jay" <[EMAIL PROTECTED]> Sent by: cc:

Sql to create 'ALTER USER...'

USER command. The type of output I am looking for is: alter user him default role role1,role4,role7; alter user her default role role4,role5,role7; etc... Maybe this is easy and I am just having trouble concentrating this afternoon... Thank you, Jay Hostetter Oracle DBA D. & E. Communicat

RE: 2nd DBA or ?

TECTED] (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

RE: Better Way Of DeFragmentation

other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

RE: Better Way Of DeFragmentation

I assume you intend to also: .5) Clone database to second machine .6) Drop all objects in schema on 2nd machine 4.5) Take cold backup of 1st machine With those caveats, it looks fine. Jay Miller -Original Message- Sent: Thursday, September 20, 2001 10:35 AM To: Multiple recipients of

RE: Copy Oracle's binary.

Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

Lock Manager in Enterprise Manager 2.1?

t now part of a different app? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: database disaster recovery

that we had to have our standby server in a different datacenter than our production server. When I first joined this group they were both in NY. Jay Miller x48355 -Original Message- Sent: Friday, September 14, 2001 10:50 AM To: Multiple recipients of list ORACLE-L !! Please do not po

slightly OT: Way to prevent FTP users from changing dirs?

ow to implement this.. hints? And please, don't start telling me about setting/removing no world permissions on a directory... that's not what I'm talking about. J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker INET: [EMAIL

RE: STOP THE PRESS!!

e with all list members in the area or with friends and relatives in the area. Jay Miller -Original Message- Sent: Tuesday, September 11, 2001 10:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35

RE: Cloning Database failed

me error. > > It's not a high priority since my SA just called to let me know he was able > to find a few extra Meg for the filesystem (I was only short a frustrating > 300K), but I'd still like to know what the problem was and any suggestions > (in case it happens again

RE: Last time an Index was used..

Wow, that's a nice feature. Any idea what the overhead is for this (not that we'll be moving to 9i for at least a year)? Jay Miller -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L Under 9i MONITORING USAGE | NOMONITO

RE: How do you audit a DBA?

erwork but occasional interesting stuff feel free to send my your resume. We need a DB2 DBA too. Oh, and my great-grandboss knows my name but his office is only about 15' from my cubicle so I don't know if that counts. Jay Miller -Original Message- Sent: Friday, September 07, 2001

Cloning Database failed

short a frustrating 300K), but I'd still like to know what the problem was and any suggestions (in case it happens again in the future). Oracle 8.0.4.3, Solaris 2.5.1 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PRO

RE: How do you audit a DBA?

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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Net

RE: multiple temp tablespaces

temp space. Don't see the benefit to having seperate tablespaces for every user though. Jay Miller -Original Message- Sent: Friday, August 31, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Hi all, Someone suggested to me to have seperate temp tablespaces for each use

RE: archive query - revisited

Sent: Tuesday, September 04, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Mohammad and Jaymany thanks for the responses. Upon running your script Mohammad, I noticed that archive files were being written to the archive directory during a large insert operation and stopped being wr

RE: How do you audit a DBA?

and the administrator account on a NT system can't do everything too? >From: "Miller, Jay" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How do you audit a DBA? >Date: Wed, 05

RE: Interesting News..

ople turn to the HP products. That one might work... Jay Miller -Original Message- Sent: Wednesday, September 05, 2001 7:16 AM To: Multiple recipients of list ORACLE-L I agree. First of all there is no certainty that the marriage will ever be consummed (there has been a lot of

RE: How do you audit a DBA?

It was our Internal Audit department. And their issue with Unix is the same issue they have with Oracle. root can do anything, sys can do anything. This is evil incarnate. External security problems aren't nearly as important. And yes, it's crazy. Jay Miller -Original Message

RE: How do you audit a DBA?

st 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network

RE: USE_HASH hint

Thanks for posting the results. I'm endlessly fascinated (and frustrated) by Optimizer behavior. Jay Miller x48355 -Original Message- Sent: Sunday, September 02, 2001 5:50 PM To: Multiple recipients of list ORACLE-L The problem with the USE_HASH hint is due to the order of the t

RE: !! Keeping the list alive

s and went to Columbia to do a career shift and study Oracle. All in all, one of the best things that ever happened to me :). Jay Miller -Original Message- Sent: Monday, September 03, 2001 6:30 PM To: Multiple recipients of list ORACLE-L I went through several major cuts when I work

RE: Column Name

k, populate the recreated columns from the new table. Jay Miller -Original Message- Sent: Tuesday, September 04, 2001 3:21 PM To: Multiple recipients of list ORACLE-L If you have 8i you can add new column name,populate with old column data,drop old column. Rick -Original Me

RE: archive query

Even if the table is set to nologging DML will still generate redo unless the data is loaded using a) direct load from sql loader b) insert /*+APPEND*/ Updates and deletes will always generate redo. Jay Miller -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04

RE: ADMIN: Update on donations...

You might also consider a regular e-mail (sort of like Public Television) where you remind people every 6 months or so of the situation and where to send voluntary contributions. This way people new to the list will get the history of the situation. Now I'm off to make my first donation!

RE: football fan-hood

e. Violence and committee meetings." Jay Miller -Original Message- Sent: Wednesday, August 29, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Lisa, The stereotypical football fan is, of course, a male, whose wife/significant other usually wants nothing to do with the sport.

RE: char vs. varchar2

ntaining: 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Serv

RE: Logical Backup for a large database

ng 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). Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA US

RE: help execution plan changes when using a dblink

Have you tried using a /*+ PUSH_SUBQ */ hint? If I'm interpreting what you say correctly you want the subquery to execute first so this might (or might not) help. Good luck! Jay Miller -Original Message- Sent: Wednesday, August 29, 2001 12:01 PM To: Multiple recipients of list O

RE: OT RE: RE: How do you audit a DBA?

insisting that expensive 3rd party software be installed since Unix isn't a secure operating system (root can do anything). Jay Miller -Original Message- Sent: Monday, August 27, 2001 10:25 AM To: Multiple recipients of list ORACLE-L C'mon. I'd vote for The Rock i

RE: conversion from public to private synonym

Actually, it's even easier. You can create the private synonym (which will then take precedence over the public synonym when logged in as the synonym owner) and then drop the public synonym. Users wouldn't even notice any change. Jay Miller -Original Message- Sent: Tuesday,

Shrinking datafiles in a locally managed temporary tablespace

cold right now and feel like my thoughts are wrapped in cotton at the moment. Any ideas? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: database upgrade policy?

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

RE: High DML Table - Suggestions??

Walter, Couple of other areas to watch while DMLs are being issues against this table are: LGWR and DBWR statistics and activities. Based on DBWR/LGWR statistics, you may need to tune these parameters. Jay -Original Message- Sent: Monday, August 20, 2001 5:31 PM To: Multiple recipients

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

se this feature. Jay ORADB SQL>CREATE TABLE REJ_TEST ( 2ACCESSCONTROLID NUMBER (10) NOT NULL, 3RESOURCE_NAMEVARCHAR2 (10) NOT NULL, 4ACTION VARCHAR2 (10) NOT NULL, 5ISALLOWEDNUMBER (5)NOT NULL, 6PARTYID NUMBER (10

Ways to improve speediness of truncate, drop, coalesce

f tablespace is the best I can do. Thoughts? J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Index space not freed when rows deleted?

all that space is still claimed. That would explain why when I rebuilt the indexes recently I regained a huge amount of space. Always glad to learn something new :). Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Inde

RE: Speed up Truncate tables

new table. Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Also,if the problem is caused by a large number of extents my understanding is that it will take just as long to DROP it as to TRUNCATE it. Jay Miller -Original

RE: Speed up Truncate tables

Also,if the problem is caused by a large number of extents my understanding is that it will take just as long to DROP it as to TRUNCATE it. Jay Miller -Original Message- Sent: Wednesday, August 15, 2001 4:11 PM To: Multiple recipients of list ORACLE-L THAT depends on what all the

Index space not freed when rows deleted?

;s a primary key sequence based index. Any ideas? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: OT -- training

Pretty amazing actually. I won't feel so bad about missing the cruise this year :-( If I get get to attend this one. Jay Miller -Original Message- Sent: Monday, August 13, 2001 10:21 PM To: Multiple recipients of list ORACLE-L >On the other hand, I can take the day off fo

RE: OT -- training

means that I would be sitting here with everyone asking me to do my usual work while "training". Don't think I'll notice much difference. On the other hand, I can take the day off for the NY Users Group when there aren't any emergencies (about 50% of the time). Jay Mille

RE: Password_verify_function in 8.1.6 doesn't allow ALTER USER ID

Never mind, I just found the workaround. It just involves creating a procedure owned by system to do the actual password change. I should have thought of that :( Jay Miller -Original Message- Sent: Thursday, August 09, 2001 4:16 PM To: '[EMAIL PROTECTED]' IDENTIFIED BY

RE: Unix Client Install

taining: 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: Miller

RE: completely off-topic question...

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

Password_verify_function in 8.1.6 doesn't allow ALTER USER IDENTI

USER (*not* an option :) to each user 2) OCIPasswordChange() can be called from Powerbuilder, and where I could find sample code to do so if it is possible 3) There is any other solution? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [

RE: O/S copies of datafiles

RACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo

RE: Extent's datafile.

sage 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: Miller, Jay INET: [EMAIL

RE: import size problem ???

iling 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5

RE: Optimizer Mode......how to choose the right one?

You probably already thought of this, but I hope you aren't analyzing the SYS schema? This can cause terrible performance problems. Jay Miller -Original Message- Sent: Tuesday, August 07, 2001 12:06 PM To: Multiple recipients of list ORACLE-L ... I tried FIRST_ROWS, analyzin

RE: completely off-topic question...

Well, okay. But gee, he didn't invent his own language or anything... Jay -Original Message- Sent: Monday, August 06, 2001 3:33 PM To: Multiple recipients of list ORACLE-L Jay, That's okay -- I'll get my mom to talk to your aunt to have her talk to your mom... t

RE: Missing Table

e made any difference since I was logged in as the table owner but the program compiled! I have a note on my calendar to remove the schema name from the program after my upgrade... Try specifying the the schema owner in the sql loader script and see if it makes a difference. Jay Miller -Origin

RE: completely off-topic question...

el: I'm afraid I can't speak to you any more now that I know you don't like Tolkien :). Jay Miller -Original Message- Sent: Friday, August 03, 2001 6:17 PM To: Multiple recipients of list ORACLE-L > -Original Message- > From: Rachel Carmichael [ mailto:[EM

RE: deletion of data from a large table

e amount of data you have remaining, you might be able to resize the one remaining datafile down after you truncate the table. (e.g., if your initial exent is 5 Meg and you don't anticipate ever having more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate).

RE: deletion of data from a large table

ing more than 1 Meg of data, you can RESIZE the datafile down to 5 Meg after the truncate). Jay Miller -Original Message- Sent: Thursday, July 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L This can be done . But what about the constraints ? - Original Message

RE: Tuning question - Why did this index help so much?

Hi Tom, That's why I expected a 25% decrease in processing time (instead of reading 2 index blocks and 2 table blocks it read 2 index blocks and 1 table block). But why would it give a 75% decrease? Jay -Original Message- Sent: Wednesday, July 25, 2001 2:29 PM To: Multiple recip

RE: re-archiving a redo log file

ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To RE

RE: Tuning question - Why did this index help so much?

4,000 rows in memory seems rather small. Hmm, is it possible to Cache an index? I just tried an ALTER INDEX xxx CACHE; command and it didn't work. Jay Miller -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L it's possible tha

RE: both dbms_stats & dbms_utility are gathering stats on sys obj

ote 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

Tuning question - Why did this index help so much?

itional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: ERROR IN INSTALING PATCH 8.1.6.3.0

We had a similar problem when installing the patchset for Oracle Client on Windows. We ended up renaming each existing .dll (.dll.old) and continuing. Worked fine. Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Had a

RE: how to run explain plan on SP???

=no explain=username/password Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Hi, Can anyone show me how to run explain plan on a whole stored procedure? 815 on Sun 5.6. Thanks a lot. Leslie

RMAN problem after Duplicate

duplicate the database I'll trash my production db. Anybody ever been here before? Thanks, Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat Cit

RE: Listener Security !!

tp://www.orafaq.com -- Author: Miller, Jay 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

Re: RMAN

pposed to do some of the thinking for me. I'm going through the school of hard knocks here, so I would love to hear from others. Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 07/23/01 11:28AM >>> Well looks like i've held o

Re: Listener Security !!

Set a password for listener administration to prevent this. PASSWORDS_LISTENER=(mysecretpassword) Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 07/23/01 10:11AM >>> Hi All !! Today I came across a typical Hole in Listener

Re: WinNT / 8.0.5 / Import anomaly, or is it?

The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay >>> [EMAIL PROTECTED] 07/20/01 02:55PM >>> >From out of

Re: New Listener Question

With 8i, the databases automatically register with the listener. You can disable it by pointing to a port that is not used by a listener. In the initSID.ora put the following entry: local_listener = "(address = (protocol = tcp)(host = mymachine.mydomain.com)(port = 1522))" Jay

Re: rman question

Joan, RMAN does not backup online redo files. If you take a cold backup, then restore it, you need to issue an 'open database resetlogs'. These documents on MetaLink may be helpful: Note: 61801.1 and Note: 106432.1. Jay Hostetter Oracle DBA D. & E. Communications Ep

RE: DB Backup Question

We don't back up the filesystems that have the live data during our tape backups. Since these files are effectively unusable there's no point in saving them. Jay Miller -Original Message- Sent: Wednesday, July 11, 2001 3:29 PM To: Multiple recipients of list ORACLE-L Hi a

RE: can i place online redologs with oracle engine ?

t Not Complete errors and had to increase the log file size). Jay Miller -Original Message- Sent: Friday, July 06, 2001 6:51 AM To: Multiple recipients of list ORACLE-L infact i should have been more clearer offcourse i can place them on any disk..the reason i asked was... how much IO

RE: A danger in cloning databases

to notify me of the problem (it says something about the processes here that it was 45 minutes after I restarted the listener that that our Help Desk contacted me me about the problem, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits fro

RE: OT - interviewing your superior(fun question)

ent anyone was interested :). I think it was Wired magazine that first used the word 'invented'. Jay Miller -Original Message- Sent: Thursday, June 21, 2001 11:25 PM To: Multiple recipients of list ORACLE-L Yes, the statement is different, but just based on the words in the sen

RE: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

ling 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

A danger in cloning databases

me about the problem, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits from my mistake. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Serv

Re: Installation oracle through responsefile

Has ANYBODY ever been able to successfully use a response file? Please share the secret with us! Thanks, Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 07/10/01 04:35PM >>> With WWS help, we have tried the non-interactive insta

RE: Client Connection-SQLNET ?/? ODBC.

Hello James, Every ODBC connection I've seen or used has connected through SQL Net (i.e,., app->odbc->sqlnet->database). But ODBC isn't really my area of expertise... Jay Miller -Original Message- Sent: Tuesday, July 10, 2001 11:15 AM To: Multiple recipients of l

RE: Gaping holes found in Oracle 8i (patch 1654631 info)

_ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Netwo

RE: Griping about auditing (not the Oracle Kind)

am) is that this is the latest management fad. According to my friend this goes in waves, with everyone moving to functional division, then project division, then back again. He's been through a few shifts back and forth in his time. This is my first one. Jay Miller -Original Mes

RE: Good Beginner Oracle book recommendations:

tween phone calls and e-mails. Once things calm down (ha!) I intend to implement a thorough performance review of all our Oracle databases using that book. I'm really looking forward to it (in fact, the prospect of being able to do it is one of the few things keeping me here at the moment).

RE: Griping about auditing (not the Oracle Kind)

t fix it. If you say it > is broke then why is it we aren't having any problems?" > > I wasn't looking for confirmation that this is silly (I know it is) so much > as just wondering if anyone else has had to deal with this level of > bureaucracy. And maybe a little commisera

RE: Griping about auditing (not the Oracle Kind)

ORACLE-L > > > > Hi, > > Been there recently > > We had change management here breathing down our necks at one point. They > wanted everything documented and approved. I flooded them with change > request forms (even for changing a users password

RE: Griping about auditing (not the Oracle Kind)

ical). So, any similar horror stories? Jay Miller Sr. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

Re: Legato NetWorker & RMAN: A troublesome pair?

backup to disk seems to save us a lot of headaches and gray hairs. Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 06/26/01 02:35PM >>> The subject line may be overstating things a bit, but I'm pretty frustrated at the moment. Back

<    1   2   3   4   5   6   >