RE: script for comparing two schemas in two databases

functions to propagate changes between databases, but capturing baselines for later comparison is nice. I found the earlier versions buggy, slow and painfull to use, but version 2.2.0 under Oracle 8.1.7 seems to work OK. Hope this helps. Simon Anderson. Please respond to [EMAIL PROTECTED

RE: the ora certified masters cert, yet again

and what I need to find out (And what I've forgotten) better than the multiple-choice exam questions Oracle offer. Most of us don't give presentations at the various OUG's, etc, but getting a good result at that interview is a good thing to aim for. Simon Anderson .. weaknesses and which way

Re: Oracle 9i, can't break it?

is an Oracle Partner, or they're keeping very quiet about getting the Database for free... Somebody tell me this stuff doesn't run on Oracle software. Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

RE: Upgrade from 9.0.1.2 - NOPE!

[EMAIL PROTECTED] on 07/03/2002 04:17:56 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) Does anyone have the bug number on this security bug? Thanks, Cherie Machler Oracle DBA Gelco Information

RE: Upgrade from 9.0.1.2 - NOPE!

. _ With apologies for the mangled quick quote. Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: 8.1.7/HP-UX 11/PRODUCT_USER_PROFILE

. PRODUCT_USER_PROFILE is useful only where users can't get round it by installing their own client software, and don't know enough PL/SQL to be dangerous. Even then, you should think about backing it up with audit trails, just in case. Hope this helps. Simon Anderson I have entries

Re: User access within/outside of app

to implement it to work with the application...Without changing the code, you could try setting up a logon trigger to enable the role, but I've not tried it so I won't guarantee it would work. Hope this helps. Simon Anderson We have purchased a system where users login through an ODBC

RE: Stanby Database- Archive Transfer Problem

. Hope this helps, theres much more info on Metalink Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) If you find a solution for this, I would be interested in it. We have the same problem

RE: subtract minute from date/time

in an hour * number of seconds in a minute) You can probably do the same thing with decimals, but the numbers are messy. If Oracle handled anything smaller than a second, we'd probably start seeing issues with rounding errors... Hope thats clear and I haven't made any obvious mistakes. Simon

RE: User_product_profile and sqlplusw

. Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) I haven't tried this for a while, but I think it's case sensitive. try 'sqlplusw.exe' -Original Message- Sent: Monday, April 15, 2002 4:13

RE: How come I don't get postings

' mode, which would mean you have to wait a week for the whole list to arrive at once. Sorry that this is a RTFM, but it's been so long since I turned off digest mode I can't remember exactly how I did it... Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list

OT: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!

' with multiple exclamation marks. Don't panic - just follow these simple steps: 1) Trust no-one 2) Prevent this insidious virus from spreading any further by not posting any replies containing the 'V-Word' virus. Simon Anderson (Note to the humour impaired - just ignore me, it's been a slow week

Re: DB Size

are taking on the disks. What all these numbers actually mean is a much longer and more difficult question, best left 'till next week. Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) Hi all, How

Re: I have a black hole in my database

... You could try creating an explain plan of the Select that the view uses, and running the statements themselves without making them into a view might get you something traceable, but it's a long shot. Hope This Helps Simon Anderson. Please respond to [EMAIL PROTECTED] To: Multiple

RE: designer6i vs. designer2000

Alas, the last time I looked, the OTN download for Designer was missing. The latest is Des6i release 4, which it said was 'coming soon' Simon Anderson Andrea, Designer 6i is the newest one - release 3. You can actually download it from OTN. Designer2000 was renamed to 6i after the Y2K

RE: Standby Instance questions and HA

. Alas, it rarely worked that well when there was an actual problem. As with the Sun solution, no extra charge from Oracle, but added costs from SG. Still, who in their right mind would choose to run a production database on discontinued SGI machines? Simon Anderson Please respond to [EMAIL

Re: Steps for removing jobs

it in the O'Reilly Oracle Built-in Packages book It saves messing around with password-swapping and becoming other users. Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: Steps for removing jobs

There's a note on Metalink that outlines it and states that it's not supported, not documented in the Oracle manuals and that the 'supported' method of manipulating jobs is as the jobs owner. Seems strange to me, but Ours is not to reason why... Simon -- Please see the official ORACLE-L

Re: Standby Databse Problem

this is to get a faster link between the two systems, but that's another issue entirely. Hope this helps - I'm currently working on a standby database project, so I've been looking at the same problems. Simon Anderson Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

Re: Is it possible???

it. If you can't write the roles into the application, you can use logon triggers and auditing to provide some protection. IMHO, PRODUCT_USER_PROFILE gives you a false sense of security, when what you need is enough understanding of Oracle to have a *real* sense of security. Simon Anderson

Re: Client install from hell

Farnsworth, Dave [EMAIL PROTECTED] on 10/19/2001 07:15:24 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Simon Anderson/SSplc) I think I've seen this before, it certainly sounds familiar... I've no idea what causes

Re: Replacing the pesky '

their name to four single quotes... Anyone know a better way of coping with this kind of 'problem' data ? Simon Anderson Gotta love Mondays, We've been through this before, and I usually don't have a problem, but today my brain must think it's the weekend. Hey, I've got a bunch of names

Re: Help with passwords

It's just ALTER USER username IDENTIFIED BY VALUES 'hex-key-whatever'; Substituting the username and password value from dba_users as appropriate. There are scripts that save it in a file with the commands to switch it back, but it's easy enough to do manually. Simon Anderson Hi all

RE: 9i install on Win2K

, just : Any platform that uses the Intel Pentium 4 processor, with the Sun JRE and Symmantec JIT, OUI version 1.7.1.9.0 and earlier, will encounter this problem. Without the patch, it doesn't look like you're going anywhere. HTH Simon Anderson -- Please see the official ORACLE-L FAQ: http

Re: Methods to get DDL

There are scripts out there that will do the job, though most of them start to fall down if the indexes are at all unusual. I bought a book a couple of years ago with a whole selection of scripts to create ddl for database objects - It should still be available on Amazon. Cheers Simon Anderson

RE: Methods to get DDL

'Annotated Archives' for years, I'll have to take a look at 'Instant PL/SQL Scripts' as well. Simon Anderson To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: The original is SQL PL/SQL Annotated Archives --- Bob Metelsky [EMAIL PROTECTED] wrote: Simon, thanks for the plug

RE: Oracle 9i hanging when linking during install !!!

There's a note on metalink that covers some of the relevant parameters: 68105.1 'Commonly Misconfigured HP-UX Kernel Parameters'. 9i is a lot more resource hungry than 8i, and you need to make sure you have the right HP-UX patchsets. Cheers Simon Anderson Deshpande, Kirti [EMAIL PROTECTED

Re: AUDITs

like 'audit session by access whenever not successful;' has turned auditing on, you can look at it using 'select * from dba_stmt_audit_opts;' and turn it off with 'noaudit session;' Hope that helps Simon Anderson Solaris V2.6 Oracle V7.3.4.5 For the last hour or more I've tried to RTFM, but I

Re: Partitions of table read only

. Your suggestion about the metadata makes sense, the bitmap held in the LMT can't be the only information about that segment. When I get my brain back in gear, I'll try and work out where else to look for a better idea of what's happening. Cheers Simon Anderson Rachel Carmichael [EMAIL

RE: Restricting access via sqlplus

security, you need to back these schemes up with auditing failed logons, audit triggers to record who made changes to data, etc. Simon Anderson Jacques Kilchoer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/07/2003 01:29 Please respond to ORACLE-L To: Multiple recipients

Re: OUI download

I think it's patch 2878462 for the OUI placeholder for the latest version - Metalink patch search, by patch number. They don't make it easy to find... Cheers Simon Anderson Is there another location for downloads? (I don't think there is...) I am looking for a simple package

Re: backwards export

I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon

Create Table..As Select: Number formats

, so how else can I force the columns to a particular format? Any ideas much appreciated. Cheers Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Create Table..As Select: Number formats

...As Select..' Cheers Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RE: Create Table..As Select: Number formats

to the extra redo/undo generated despite my best efforts to persuade it otherwise. I've done enough tests with changing the format of the number columns to convince myself that that the calculated Number columns are the only remaining issue. Cheers Simon Anderson I'm trying to create a table using

Re: Table recovery from RMAN backup

You can use export and flashback to recover a dropped table. The only time I needed it, it gave a warning on the export but still worked OK. Simon Anderson SciSys Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/12/2003 17:49 Please respond to ORACLE-L