Oracle

Work from anywhere, Get payout daily.
WOW!! Get seen -- get paid! You can now get paid to drive your car, wear T-shirts, and more! Just join the EyeEarn Advertising Network and start earning money effortlessly while you go about your day! It's fun, easy, and no experience is necessary! http://www.eyeearn.com/10122618/signup ... 19 Jun 2008 01:14

9iR2 exp -> 10g imp
Arch wrote,on my timestamp of 15/06/2008 2:06 AM: All in all, it has been a learning experience for me. Thanks to all who offered suggestions. Users expect to go live in the new database on Monday. Well done! Welcome to the joys of administering production Oracle sites without the tools that have... 19 Jun 2008 01:14

Administration assistant for Windows NT
Hi, Oracle 9.2.0.6 W2000 When I run : administration assistant for windows NT then process information info on threads are empty do you know why ? Thanks for your help ... 19 Jun 2008 01:14

Index organized table
I'm thinking about some changes in my DB app. to switch one table to an IOT. That table has pri. key wich is always stored in sequence order (in inserting new row). Currently, that table is 240Mb big (with more than 2 mil. rows) with an average row size of 100 bytes. There is an pri. key index and a single B-tre... 19 Jun 2008 01:14

how to count elapsed time between sysdate and some saved timestamp?
question is simple... I have an date field in an table and I would like to measure time difference (minutes or sec.) between current time and that field. at wich way you propose? ... 7 May 2008 14:14

RMAN recovery question
A cold backup was taken of a 10.2.0.3 database using rman. The database was shut down cleanly before the backup was started. When I tried to restore the backup a few days later, it would not let me open the database. It said that file 1 (system01.dbf) file needed further recovery. Why would a file need *any* re... 7 May 2008 15:04

What is the oralce$SID process?
I type "ps -ef | grep oracle" and find that there are many oracle$SID processes. I search from the google that it says they are "nonessential Oracle processes from the server side". Could anyone please explain more? Thanks. Woody Ling Hong Kong ... 7 May 2008 11:47

10.2.0.4.0 bug?
Hi, I have a Oracle server with 10.2.0.2.0 patchset. Because of known bugs, I have installed 10.2.0.4.0 patchset. It is over! I cannot connect to the server again by net8, sqlplus and so on. How can I do? However, I can use tnsping to find the listener. Ming ... 7 May 2008 13:24

why listener 's chang_password not work?
hi all: i'm using oracle 10g on a Windows XP system. for my oracle system's security, i change listener password by follow steps: ----------------------------------------------------------------------------------------------------------------------------------- c:>lsnrctl LSNRCTL> change_password Old password: ... 7 May 2008 05:05

Oracle 10g Express Connection Limitations?
Hello, I used Oracle 10g XE a lot last summer and will likely be using it again this summer. My database is essentially for experiment purposes and most connections to it are VIA ODBC. I noticed last year after so many (like 20 perhaps? I'm not sure an exact number) sequential ODBC connections (that is connect a... 7 May 2008 15:04