RE: Another Character Set Problem

2002-09-13 Thread Cherie_Machler
The utility is called csscan for character set scan. It runs at the unix prompt with additional parameters (some optional and some not) much as export or import would. Before you use it the first time, you need to run csminst.sql from $ORACLE_HOME/rdbms/admin to set up the work tables, etc. C

Re: * Oracle 11i DBA position in Wisconsin..

2002-09-13 Thread Cherie_Machler
Baraboo is in a fairly rural area more than an hour from Madison or from Milwaukee. Neither of those cities are a vast metropolis. Not everyone is keen to live in the country. Plus I would imagine that a DBA job in this part of the country wouldn't pay a massive salary. However, the cost of

RE: SQL help

2002-09-13 Thread Rick_Cale
Thanks but unfortuneately we only have standard edition so I do not have these features. Rick "Larry Elkins"

Locking Problem

2002-09-13 Thread Suman S K
Hi Everybody, I am facing problem while invoice Processing. We have Invoice_Header table and Invoice_Lines Table. One Record in Invoice_Header table can have multiple related records in Invoice_Lines. We have not implemented locking mechanism at header

RE: * Oracle 11i DBA position in Wisconsin..

2002-09-13 Thread Farnsworth, Dave
You betcha, hey. -Original Message- Sent: Thursday, September 12, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Why yes I can: "M-cow" Actually, the Dells area (Baraboo is a few miles south) is pretty nice if you're an outdoorsy-type. Or if you just like to live in or

killing nohup processes

2002-09-13 Thread kommareddy sreenivasa
Hello all, solaris: 2.8 there is a strange problem with nohup compress in unix. I am trying to compress all my export dmp files with nohup compress *.dmp & But later I realized and not to do that and grep the process and killed it. But the system is skipping compression of the current file an

recovery scenarios

2002-09-13 Thread kommareddy sreenivasa
Hello all, when sometimes, oracle will ask tool old archive logs that are even 2-3 days older, when recovering a datafile that is taken from todays backup. does it mean the datafile is not properly backed up or something wrong with controlfile. todya there is another scenario: creating a datab

RE: SYSDBA privilege with ORAPWD utility

2002-09-13 Thread Naveen Nahata
Check for these things... 1. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in initSID.ora 2. ORA_SID_PWFILE = location_of_ur_passwordfile in the WINDOWS REGISTRY of the server. 3. Check the SYS password, or from some other USER do a 'ALTER USER sys IDENTIFIED BY ...' and then try connecting I hope this

RE: SYSDBA privilege with ORAPWD utility

2002-09-13 Thread Nirmal Kumar Muthu Kumaran
Hei... Is your sys password is correctly mentioned while logon?. I tested your case, it's doing proper, while i misspelled sys pwd, it thrown the error as u mentioned... HTH, Nirmal -Original Message- Sent: Wednesday, September 11, 2002 3:38 PM To: Multiple recipients of list ORA

RE: SYSDBA privilege with ORAPWD utility

2002-09-13 Thread Chindarkar,Chetan
Yechiel , I have administrator permission on the NT domain; but its still not working. What can be possible cause of this ? Thx, Chetan > -- > From: Yechiel Adar[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, September 12, 2002 6:53 PM > To:

RE: SYSDBA privilege with ORAPWD utility

2002-09-13 Thread Chindarkar,Chetan
Hey , Im able to connect as SYSDBA from all other users (for e.g. WIP, SYSTEM) except SYS. Can anyone pls advise on this. Thanks, Chetan > -- > From: Yechiel Adar[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, September 12, 2002 6:53 PM > To