View Full Version : Oracle Database



  1. Security question.
  2. ORA-01578 data block corrupted with 10G
  3. sqlplus command line using
  4. XML and binary data into Oracle
  5. weird ORA-12514 error
  6. Automatic Mirroring of Rollback Segment(s) and Control File
  7. 2 Buffer Cache Questions
  8. Oracle 9i usage question
  9. Unable to install Oracle 9i on solaris 9
  10. HP SuperDome Looking For A New Home!
  11. MERGE - INSERT/UPDATE
  12. C# Program, Passing LongVarChar to Package expecting CLOB.
  13. Time diff
  14. Need good idea
  15. RMAN Question
  16. "identifier must be declared"
  17. 10g on XP Pro with dynamic IP
  18. bringing together two different databases (with different schemes) into one database
  19. generate random numbers
  20. Oracle 9i Performance Counters
  21. www.dizwell.com/BB
  22. Download oracle 8i
  23. how to find the SQL statement in V$SQLAREA with bind variable
  24. 10g OCP: Installation Performance Enhancements?
  25. How to tell which PATCH I have in Oracle 8.1.7.4?
  26. HS connection to SQL*Server
  27. parallel query
  28. suggestions for maintaining master/child task list
  29. Standby database & licensing
  30. Help needed for ORA-00822: MMAN process terminated with error
  31. massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
  32. Applying Oracle Critical Patch Update Apr 2005 for 8174 on Unix Servers
  33. Memory Problem
  34. install a new font on Oracle10G
  35. force oracle database shutdown
  36. ORA-10631: what does it mean?
  37. standby db log sequence gap
  38. =?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upo n_your_location._I_want_to_ask_you_the_most_import ant_question_of_your_life._Your_joy_or_sorrow_for_ all_eternity_depends_upon_your_answer._The_questio n_is:_Are_you_saved=3F_It_is_not_a_ques
  39. =?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upo n_your_location._I_want_to_ask_you_the_most_import ant_question_of_your_life._Your_joy_or_sorrow_for_ all_eternity_depends_upon_your_answer._The_questio n_is:_Are_you_saved=3F_It_is_not_a_ques
  40. W2K3 vs RHAS performance: Windows wins.
  41. Grant Select without Grant Update
  42. v$session.program
  43. Oracle Stored Procedure Permissions Problem
  44. I need a free iPod and so do you!
  45. Dress code for DBA's
  46. problem with character set using 10g
  47. Having big trouble trying to improve performance of XML parsing...
  48. Live Reorganize from SQL-script?
  49. Question: cleaning up PK indexes
  50. curious
  51. Oracle sqlldr, load fields and a constant value?
  52. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  53. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  54. connect to mysql
  55. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  56. Processor comparison
  57. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  58. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  59. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  60. Two databases on one server
  61. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  62. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  63. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  64. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  65. converting transactSQL to PLSQL
  66. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  67. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  68. Starting up oracle listener and database
  69. Dynamically execute sql statements in oracle
  70. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  71. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  72. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  73. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  74. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  75. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  76. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  77. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  78. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  79. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  80. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  81. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  82. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  83. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  84. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  85. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  86. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  87. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  88. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  89. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  90. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  91. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  92. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  93. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  94. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  95. Character Set, Language, Territory
  96. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  97. Business justification for Oracle db server?
  98. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  99. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  100. RAC query
  101. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  102. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  103. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  104. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  105. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  106. Oracle Listener not responding
  107. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  108. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  109. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  110. Comparison between Quest CENTRAL and VERITAS indepth Oracle
  111. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  112. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  113. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  114. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  115. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  116. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  117. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  118. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  119. Help with select statement (pivot table?)
  120. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  121. Copying DBs between heterogenous environments
  122. Insert data into varray
  123. Import hangs with 12801 oracle 8174
  124. getting error ADMN-202005
  125. =?Big5?B?vselSK1QtEmhQaZ+wX6myrhVsU2u1w==?=
  126. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  127. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  128. Oracle data into Microsoft Excel
  129. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  130. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  131. Job openings for scientifically-oriented programmers
  132. selection from dual table
  133. Oracle Lite
  134. which is better for you ?kakg
  135. =?Big5?B?p0Gko7dRpkG1uabbpHakQKa4vve3fKVYwFmk0bbco Ug=?=
  136. Archive Error
  137. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  138. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  139. Number to word convertion error
  140. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  141. =?Big5?B?vselSK1QtEmhQaZ+wX6myrhVsU2u1w==?=
  142. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  143. problems loading multilingual data using SQL*Loader with External Tables ...
  144. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  145. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  146. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  147. Advise on a statement
  148. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  149. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  150. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  151. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  152. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  153. Mutex contention on database server
  154. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  155. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  156. How critical is RAC experience
  157. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  158. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  159. Oracle tries to read RBS in Automatic Undo Mode?
  160. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  161. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  162. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  163. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  164. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  165. [FAQ] Oracle Database FAQ
  166. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  167. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  168. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  169. How to invoke Windows SQL command from a batch file?
  170. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  171. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  172. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  173. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  174. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  175. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  176. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  177. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  178. update statement PL/SQL
  179. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  180. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  181. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  182. On-Commit trigger?
  183. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  184. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  185. I mean, what is that all about...
  186. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  187. SELECT ANY TABLE except from these schema
  188. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  189. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  190. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  191. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  192. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  193. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  194. using a clob in a where clause
  195. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  196. 9.2 Patch release dates
  197. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  198. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  199. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  200. =?Big5?B?p0GhQaS1pNGms6hTprOmWaatwFxcoUg=?=
  201. Insufficient Privileges as system when dropping a user
  202. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  203. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  204. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  205. index creation fails because temp tablespace is too small
  206. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  207. slightly OT: another free oracle resource profiler
  208. Enterprise Manager
  209. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  210. How to use a statement level trigger?
  211. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  212. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  213. Tablespace growth
  214. NCLOB fields and CLOB.createTemporary does not work
  215. anonymous transaction and altering table
  216. Co-operative FAQ
  217. 10g 64 bit on AMD64/Linux--which Linux?
  218. HELP: SLES9 + Oracle 9.2.0.4 = I'm getting crazy
  219. RedoLog utilization investigation
  220. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  221. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  222. QUESTION: 9i install: missed root.sh - can I run it after exiting OUI?
  223. Instead Of Triggers
  224. Help with this Select statement please
  225. Problem with Oracle 10g + latest 10g JDBC Thin driver + NCLOB's of1K-32K in size
  226. Hep with Oracle 9i, RADIUS and W2003
  227. Janet Don Burleson -- in the nude
  228. uploading the contents of a spreadsheet
  229. Establishing connection from Oracle Database to DB2 database
  230. Can I, too, become an overpaid Oracle DBA
  231. Configuring Shared Server Mode
  232. Temp tablespace Database File Overgrown (20 Gigs)
  233. iasconsole won't start
  234. Proper use of ROLLUP when multiple columns should be treated as one
  235. Versionning with Oacle
  236. Successful login via SQLPlus produces a server error
  237. =?Big5?B?t+3CvrP1uEmo7KRGvH7Ge69n?=
  238. Data Centre Failover and Oracle Grid
  239. =?Big5?B?wXi1sqXbIKSjpm6o/A==?=
  240. locked_mode=3, no open transactions on the table?
  241. Rollback Segment Question
  242. How much data can you put in v$session_longops
  243. Rollback Segment Question
  244. ODBC connectivity - minimum installation
  245. Oracle 9i and Oracle 10g
  246. Toad error.
  247. =?ISO-8859-1?Q?Recuperaci=F3n_tras_backup_fr=EDo?=
  248. =?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upo n_your_location._I_want_to_ask_you_the_most_import ant_question_of_your_life._Your_joy_or_sorrow_for_ all_eternity_depends_upon_your_answer._The_questio n_is:_Are_you_saved=3F_It_is_not_a_ques
  249. Character set while export and import drives me crazy
  250. Problem running .sql scripts for upgrade