Dear OIPStaff OIPStaff,

This is your DBA-Village Weekly Newsletter for Jan 03, 2005.

Prologue

First of all we wish everybody a Merry Christmas and a Happy New Year.
As kind of a present, you get a totally new layout of the site and a lot of new features. These include:

• Possibility to add a comment to an item
• Sort by date and by score
• More search options
• ...

You can read more about this and about the migration to 10g in the news section of the site.
We hope you will enjoy the new look and feel and don't hesitate to give us your feedback and suggestions for the DBA-Village site.

New items

Question

This is the new question for the next two weeks. Below you see the results of the previous question. Please share your answer with us.
(You will have to enter your DBA-Village username/password, which you may find at the bottom of this Email)

There are 433 responses so far

Imho

Please feel free to give your opinion in our Imho section, or just read the opinions of others. The current topic is:

• How do you like the new layout of DBA-Village? Give your opinion or read the opinion of others.

New forum threads

The following threads are new since the previous newsletter. Remember that you can follow up interesting threads by clicking on the little white envelope on the website. In that case you get an email when there is a reply in the thread. And of course at any moment you can deregister.

1. Permission/stored procedures (2 repl.)
2. JDeveloper - Deploy to Tomcat target (2 repl.)
3. 2005's wishes (2 repl.)
4. Create Trigger (1 repl.)
5. Interview Questions (2 repl.)
6. WorkFlow
7. SQL Query (1 repl.)
8. calculate database size (3 repl.)
9. backup storage (1 repl.)
10. Unchanged size of objects for a long time (5 repl.)
11. service_died in Listener (14 repl.)
12. ORA-01017 Invalid Username/Password when Connecting to an APPS Mode In Discoverer (3 repl.)
13. Max number of processes (2 repl.)
14. Archivelog (2 repl.)
15. export/import (10 repl.)
16. No connection to 9iRAC second instance from Oracle E_Business suite 11i (7 repl.)
17. Listener errors before changing IP adresse on Linux (2 repl.)
18. oracle streams (2 repl.)
19. Problem with date in procedure (6 repl.)
20. online backup (3 repl.)
21. how many partition should I create? (9 repl.)
22. Block Corruption (9 repl.)
23. Dynamically declaring a cursor (5 repl.)
24. Rman duplicate on 9i (5 repl.)
25. Has anyone done Cach`e Database and Oracle 8i integration? (1 repl.)
26. Oracle 10g client ... (4 repl.)
27. Installing Oracle Standard Edition ONE (7 repl.)
28. Export error exp-222 (5 repl.)
29. Urgently : metalink Note 168277.1 (1 repl.)
30. using materialized view to get better performance. (8 repl.)
31. problems using CLOB (6 repl.)
32. Error into SQl Query (4 repl.)
33. Error Sending Mail In HTML Format !! (1 repl.)
34. create catalog for rac database (5 repl.)
35. remote export (4 repl.)
36. auto update ftp script (4 repl.)
37. ORA-01940: cannot drop a user that is currently connected (6 repl.)
38. statspack report help (1 repl.)
39. Replication (5 repl.)
40. Oracle first version (4 repl.)
41. How to receive mail? (3 repl.)
42. size of sga (5 repl.)
43. backups record (2 repl.)
44. can not display my stored script in RMAN 10g RAC (3 repl.)
45. Tape Configuration (4 repl.)
46. unable start listener (3 repl.)
47. creat a new database (5 repl.)
48. Check if allocation of next extent will fail. (6 repl.)
49. QUERY ON VIEWS (2 repl.)
50. Forms
51. Oracle 9i Jobs Not automatically running (2 repl.)
52. Error :ORA-12560 (3 repl.)
53. Rman Question (10 repl.)
54. SQL Query Tuning (2 repl.)
55. dbv (2 repl.)
56. Day/date query in SQL (8 repl.)
57. Error in Invoking target 'ihsodbc sdo_on' (1 repl.)
58. Unexpected append on existing trace file (1 repl.)
59. Sessions on first page of Statspack versus UNIX sessions (1 repl.)
60. questions (1 repl.)
61. What is STATSPACK? (1 repl.)
62. concatenat files ?!! (13 repl.)
63. using CLOB in proC programs... (1 repl.)
64. Oracle Apps 11i Report Output Printing .. Page Break
65. database verify (4 repl.)
66. Not able to locate "Oracle_Home\plsql\demo" (1 repl.)
67. Unable to connect through perl script
68. RMAN setup. (5 repl.)
69. DBMS_JOBS Monitoring (1 repl.)
70. calling a C code from PL/SQL (3 repl.)
71. Well Can any body tell me How to set up Replication on ORacle 9i?? (3 repl.)
72. OEM management service problem ... (3 repl.)
73. PACKAGE DBMS_WM VERSUS USER TRIGGER (1 repl.)
74. RAC (2 repl.)
75. cant mount able to mount (2 repl.)
76. Apache server (Syntax Error) (1 repl.)
77. how can I list files of the last month (7 repl.)
78. password file error (3 repl.)
79. execute the Package,Procedures & Function (13 repl.)
80. No duplicates in view (9 repl.)
81. New Features of oracle 9i (5 repl.)
82. COALESCE function (6 repl.)
83. using traditional RBS in Oracle 9i (3 repl.)
84. Statistics Example (3 repl.)
85. statistics (1 repl.)
86. hash join,merge join and explain cost (5 repl.)
87. Killed cron (2 repl.)
88. Lock modes (2 repl.)
89. one stupid sql question (sum, max) (2 repl.)
90. I want to set password for connect sqlplus internal (3 repl.)
91. Table Space (2 repl.)
92. Force distributed transactions to commit rollback/Tablespace having deffered rollback (1 repl.)
93. Unused Indexes (1 repl.)
94. monitoring a table (1 repl.)
95. DML count, (7 repl.)
96. urgent-difference of performance between oracle and tera data warehouse in olap data cube (1 repl.)
97. shared memory linux startup hang (2 repl.)

Epilogue

We remind you that your username for DBA-Village is OIPStaff and that your password is OIPStaff. If you don't want this information to be included, go to the DBA-Village website and click on Update Account.
Do not reply on this mail. At the moment, replies are ignored. Use the feedback form instead.

Regards,
The DBA-Village Team