Recent content by kukuluku

Thank you for your input. I really appreciate it.

Thank you Mufasa. Maybe I wasn't clear... I just want to know if catalog is a common script that you can run while the system has low usage. I like to know if I just had bad luck this time due to the bug, or is catalog normally run only during maintenance window?

Hello, I need to ask whether people should run catalog.sql only in maintenance hour. What happened was we had a situation that we can not drop any SQLPLUS users. It generates following errors: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist ORA-06512...

Yes. After 3 whole days. We tried delete the cookies and things worked well then. Don't know if this is your situation. HOpe it helps.

Hello, I created a web site through IIS with new virtual directory and the port is 8080. When I click the defualt.html from Windows Exporer, it shows the page corretly. However, if I go to the page thru URL, http://server:8080/HR (HR is the virtual directory name) it only displays the source...

Hmmm... the exp/imp will take a long time. How about if I copy DB files to the same box and create a new DB with old version. After create, move it over to the test box with new version and run migrate script? Theoratically, it should work, right? When migrate to 9.2.0.6, I installed patch...

Hello, I have test machine upgrated to 9.2.0.6 from 9.2.0.3. Production is still running 9.2.0.3. I need to copy a DB from production to test. Can I just copy all data files over for a new DB (using backup control file script) and then run startup migrate as the instruction of upgrade from...

We are not planning to upgrade the existing systems. We are implementing new project (3rd party software - PeopleSoft to be exact) and it requires 9.2.0.6. For the old system, we'll just keep it on 9.2.0.3 (development and production).

Hello, We have Oracle 9.2.0.3 installed on the server. I need to install 9.2.0.6 in the same server for new databases. We have /oracle file system for Oracle binary. The current Oracle was installed on /oracle/product/9.2.0 and I am thinking to install new version on /oracle/product/9.2.0.6...

Thank you for all responses. I've found this site explain pretty well. http://asktom.oracle.com/pls/ask/f?p=4950:8:15894602223505950687::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:351017764854

I am still not clear... SQL> show parameter nls_date NAME TYPE VALUE ------------------------------------ ---------- ---------- nls_date_format string DD_MON_YYYY SQL> select * from ps_cost 2 where business_unit = 'TDMN' 3...

Thank you for all the replies. Can someone give more depth for this? I understand the client nls_date_format overwrites the init.ora. I did ALTER SESSION SET NLS_DATE_FORMAT='DD/MON/YYYY'; then it seems ignore the time (sql gets result). I did 'show parameter nls_date_format' and it did not...

I understand how to change the code to avoid the problem. But my question is why we get different results running same sql for same database on her machine and on mine. Anyone?

A developer runs this sql and gets 3 rows selected but when I run on my machine I get no row selected. I understand that due to time stamp if use trunc or even to_char (compare charactor) this works all the time. What puzzle me is that with same sql we get different results. I checked her...

Thank you Jeff. But I have used port 8080 on this web site and the other web site is port 80. So it should be unique with or without the host header. But why it's not working with the host header. It shouldn't make any difference, correct?