Re: OEM - Change Management Pack - opinions, please

I have used Change Management Pack. It helps manage changes when you need to capture them , especially when moving from Development, to Certification/UAT and Production. It can reverse engineer existing databases and schemas, but it does not put the files in a usable format. The files are in a

RE: Best method to move Filesystems to RAW Devices.

Nat - Thanks for taking the time to explain that. As I said, it has been quite some time since I worked with raw, and at that time the system admin just gave me a single mount point for the entire device. Best of luck with your project, sounds like you've planned well, but don't skip that full

RE: How can I change Oracle as well as NT Domain passwords

Thanks for responding I need to change oracle application user's password from within application. I also need to change same user's W2K/NT domain account password whenever that user changes their password in oracle application. Hope I am clear here. Appreciate your response and Thanks a

RE: How can I change Oracle as well as NT Domain passwords

If you are Oracle Applications 11.5, look at the FNDCPASS utility. This allows you to change application user passwords from the command line. They have also exposed password change functionality in the FND_USER_PK (I think thats the name). You would need to roll your own interface into

Getting a zero value..

Evening all - Starting new here in Oracle. I havethis table with a field described as Number. I'm trying to move the values in a MSAccess field of type Double to this Oracle field. Although all the number in the MSAccess fields are in a domain of 1 ...3 they show up in Oracle as a Zero. I'm

RE: Lost ofall redo logs

Thomas, If you rely on the premise that cold backups can only be taken after a non-abort shutdown, then there is no reason to backup on-line redo logs. (If you rely on backing up redo because you do cold backups after shutdown abort, well, then we can have an argument about best practices.) In

Re: Best method to move Filesystems to RAW Devices.

Nat, SQL-generating-UNIX commands works well... select 'dd bs=1024k if='||name||' of=/dev/rX' from v$datafile union all select 'dd bs=1024k if='||member||' of=/dev/rX' from v$logfile union all select 'dd bs=1024k if='||name||' of=/dev/rX' from v$controlfile;

Re: Any good RMAN books?

On Fri, 13 Sep 2002 13:08:26 -0800, Dennis Williamswrote: You must have a copy of the Oracle RMAN Pocket Reference at your elbow. At only $13, it is a steal. Jonathan Gennick who participates on this list edited it. Yes, I did, but please give Darl Kuhn and Scott Schulze some credit for writing

Re: count(*)

If you can live with 10 minutes, why not 60 minutes or 120 minutes ? Examine why this app feels so insecure that it needs to know the number of rows every 10 minutes. On Thursday 19 September 2002 20:28, you wrote: Hi Gurus, In one of our insert intensive application we are inserting around

RE: sqlplus question

Title: RE: sqlplus question SQLPlus outputs data in columns based on their Maximum length or the COLUMN format set in SQLPlus. Value of SQLPlus COLUMN attribute takes precedence. Even when you do a substr() based on length, SQLPlusdoesn't calculate the length of the maximum length value

RE: PL/SQL help

Ron We've run into this problem and haven't really found a satisfactory answer. It sounds like a job for dbms_sql, but the docs say its slower than native dynamic sql. Has anyone tested this? One other alternative I can think of (but have never tried) is to use dummy conditions in the sql;

RE: Lost ofall redo logs

Hey Gilberto, I was just yanking your chain with the CV line. Well done for getting the thing back Regards Lee -Original Message- Sent: 19 September 2002 19:08 To: Multiple recipients of list ORACLE-L Hi People I don't think that i need to update my CV, since I don't administer the

RE: High values

Basically what I want to do is put a value in a VARCHAR2 column that will ensure it appears as the last row when selected using an ORDER BY on the column John -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: 19 September 2002 21:09 To: Multiple recipients of

sql - ignoring index...

Hi Oracle 8.0.5 Tru64 Unix 4.0f Have you any idea whether you can force the usage of the first column in a multi-column index with a hint? The code below works fine to force key order lookups on non-unique indices where the column specified in the hint has it's own non-unique index. But it

RE: High values

At 03:18 AM 9/20/2002, you wrote: Basically what I want to do is put a value in a VARCHAR2 column that will ensure it appears as the last row when selected using an ORDER BY on the column Does the column presently have NULL's in it? If not, you could insert a NULL value and add the NULLS LAST

RE: Why does my insert creates so many logs?

PK has it's own index... did u drop that too ? -- From: Gurelei[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, September 20, 2002 1:23 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why does my insert creates so many logs?

Re: Inserts are taking time !

Marul, "11 are indexed." - That's the first place I would look into. Check it out just dropping them. Make sure you realy needall the indexes. Consider to drop them before and recreate after loading. Alexandre - Original Message - From: Marul Mehta To: Multiple

Job postings was:Re: Lost ofall redo logsOTHER...

Bill I'm kinda surprised no one has replied. I'm seeing pockets of oracle work in cols most of it is short-term(ie: 3 months). This is the best place to find what I'd consider the brightest people in the oracle world(of course the brightest are also the most expensive) :) joe Bill

RE: Consulting Position Available-Oracle DBA/Developer/NYC

T is for trasnsactional SQL which is SQL Server and Sybase terminology. -Original Message- Sent: Thursday, September 19, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Datawarehouse meta data. But what the heck is T SQL?

<    1   2