View Full Version : Oracle Database



  1. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  2. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  3. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  4. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  5. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  6. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  7. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  8. Help with select statement (pivot table?)
  9. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  10. Copying DBs between heterogenous environments
  11. Insert data into varray
  12. Import hangs with 12801 oracle 8174
  13. getting error ADMN-202005
  14. =?Big5?B?vselSK1QtEmhQaZ+wX6myrhVsU2u1w==?=
  15. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  16. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  17. Oracle data into Microsoft Excel
  18. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  19. =?Big5?B?p0GhQaS1pNGmWd/TpEa23KFI?=
  20. Job openings for scientifically-oriented programmers
  21. selection from dual table
  22. Oracle Lite
  23. which is better for you ?kakg
  24. =?Big5?B?p0Gko7dRpkG1uabbpHakQKa4vve3fKVYwFmk0bbco Ug=?=
  25. Archive Error
  26. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  27. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  28. Number to word convertion error
  29. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  30. =?Big5?B?vselSK1QtEmhQaZ+wX6myrhVsU2u1w==?=
  31. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  32. problems loading multilingual data using SQL*Loader with External Tables ...
  33. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  34. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  35. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  36. Advise on a statement
  37. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  38. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  39. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  40. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  41. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  42. Mutex contention on database server
  43. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  44. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  45. How critical is RAC experience
  46. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  47. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  48. Oracle tries to read RBS in Automatic Undo Mode?
  49. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  50. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  51. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  52. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  53. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  54. [FAQ] Oracle Database FAQ
  55. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  56. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  57. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  58. How to invoke Windows SQL command from a batch file?
  59. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  60. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  61. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  62. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  63. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  64. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  65. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  66. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  67. update statement PL/SQL
  68. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  69. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  70. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  71. On-Commit trigger?
  72. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  73. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  74. I mean, what is that all about...
  75. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  76. SELECT ANY TABLE except from these schema
  77. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  78. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  79. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  80. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  81. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  82. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  83. using a clob in a where clause
  84. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  85. 9.2 Patch release dates
  86. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  87. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  88. =?Big5?B?vdCw3adBqrqkcKvEpF2sT7lqpU6x0L5pttyhSA==? =
  89. =?Big5?B?p0GhQaS1pNGms6hTprOmWaatwFxcoUg=?=
  90. Insufficient Privileges as system when dropping a user
  91. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  92. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  93. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  94. index creation fails because temp tablespace is too small
  95. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  96. slightly OT: another free oracle resource profiler
  97. Enterprise Manager
  98. =?Big5?B?OK3TrVC0SbDypl2kp6RAoUexaq9QqrrByL/6sf2x5g==?=
  99. How to use a statement level trigger?
  100. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  101. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  102. Tablespace growth
  103. NCLOB fields and CLOB.createTemporary does not work
  104. anonymous transaction and altering table
  105. Co-operative FAQ
  106. 10g 64 bit on AMD64/Linux--which Linux?
  107. HELP: SLES9 + Oracle 9.2.0.4 = I'm getting crazy
  108. RedoLog utilization investigation
  109. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  110. =?Big5?B?obe487DqsdCofKFBqU2lQKzJtdetXqTxuKOzVQ==? =
  111. QUESTION: 9i install: missed root.sh - can I run it after exiting OUI?
  112. Instead Of Triggers
  113. Help with this Select statement please
  114. Problem with Oracle 10g + latest 10g JDBC Thin driver + NCLOB's of1K-32K in size
  115. Hep with Oracle 9i, RADIUS and W2003
  116. uploading the contents of a spreadsheet
  117. Establishing connection from Oracle Database to DB2 database
  118. Can I, too, become an overpaid Oracle DBA
  119. Configuring Shared Server Mode
  120. Temp tablespace Database File Overgrown (20 Gigs)
  121. iasconsole won't start
  122. Proper use of ROLLUP when multiple columns should be treated as one
  123. Versionning with Oacle
  124. Successful login via SQLPlus produces a server error
  125. =?Big5?B?t+3CvrP1uEmo7KRGvH7Ge69n?=
  126. Data Centre Failover and Oracle Grid
  127. =?Big5?B?wXi1sqXbIKSjpm6o/A==?=
  128. locked_mode=3, no open transactions on the table?
  129. Rollback Segment Question
  130. How much data can you put in v$session_longops
  131. Rollback Segment Question
  132. ODBC connectivity - minimum installation
  133. Oracle 9i and Oracle 10g
  134. Toad error.
  135. =?ISO-8859-1?Q?Recuperaci=F3n_tras_backup_fr=EDo?=
  136. Character set while export and import drives me crazy
  137. Problem running .sql scripts for upgrade
  138. Resize redo log without making DB in restricted mode
  139. EM2GO....
  140. FAQ - Etiquette - and how to get an answer
  141. NESTED TABLE ... how to SCOPE?
  142. Oracle database
  143. Error while installing Oracle 9i on Mandrake 10.1
  144. ORA-27101 and ORA-12640
  145. backup control file
  146. oracle 10g and solaris 10
  147. tablespace problem
  148. RHEL AS3.0(kernel 2.4.21-15ELsmp) + Oracle10g RAC Freeze
  149. UTL_FILE revoke from PUBLIC
  150. GIS connections?
  151. UPDATE using multiple tables
  152. 10g RAC - fail over test issue
  153. Oracle Bug?
  154. Duplicates in SQL statement
  155. Global Temporary Tables
  156. password
  157. =?Big5?B?pKO2aa3XoUGt/qjTpc2yo6R1qOOhSA==?=
  158. =?Big5?B?sLexZLtQsF20SaRAvMuquq2rrW4=?=
  159. Execute Immediate : Can't run ...Please help
  160. How to audit/trigger "ALTER SESSION" Statements?
  161. Oracle with HP-UX memory windows
  162. archivelog_compression
  163. AQ to 10gASJMS
  164. parallel and append hint in insert statement
  165. Oracle 10g for linux x86-64 - Installer crash on RHEL 3 dual cpu xeon
  166. inner without outer transaction committing
  167. Committing an Inner Transaction question without affecting an Outer Transaction.
  168. what determines the info sent to the alert log and trace files
  169. drop XMLCONCAT (function/synonym) on applying 9.2.0.6?
  170. drop XMLCONCAT (function/synonym) on applying 9.2.0.6?
  171. Oracle installation and user
  172. SQL*Loader - How to load only a few columns from a .csv file to ora table
  173. IBM shifts software price for dual-core x86 chips. Oracle next?
  174. Oracle Standard Edition One
  175. back - up strategy
  176. Default and temp tablespaces
  177. Oracle 10g x86-64 installation on Linux RHEL 3 Xeon EM64T
  178. Advanced Replication: What is the best design for our situation?
  179. character set, territory, language
  180. Seondary Unique index on Workspace - version enabled tables (9i specific)
  181. 9.2.0.5 No temp file shrinkin after db restart
  182. Re: New York -- Singer Britney Spears...
  183. copying oracle dbf files on hp-ux
  184. DBA HELP: Performane Tune SELECT, SUM, & CASE
  185. passing in arguments to oracle procedure
  186. How to update a view using "left join" when one of the base table is changed
  187. Oracle DB and Compiere
  188. How to activate os authentication on XP test machine?
  189. sqlldr / as sysdba
  190. Creating and Starting Oracle instance...
  191. Oracle and Unicode 0xb
  192. Rman Restore
  193. populate cursor with array
  194. OracleOraHome81Agent
  195. creating a 3 dimensional database (almost) Is it possible
  196. upgrade 8.1.6 to oracle 10g
  197. export with consistent=y raise snapshot too old error.
  198. =?utf-8?B?UmU6IFRIRSBHUkVBVEVTVCBORVdTIEVWRVIhILC6ty5fLl 8ut7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8u t7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8ut7 qwYLC6ty5fLl8ut7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8ut7qw YLC6ty5fLl8ut7qwYLC6ty5fLl8ut7qwYLC6ty5fLl8u
  199. merging rows
  200. Re: Do You Want To Know For Sure That You Are Going To Heaven? The reason some people don't know for sure if they are going to Heaven when they die is because they just don't know. The good news is that you can know for sure that you are going to Hea
  201. Call a sp from other intances
  202. online redef
  203. Bulk Collect into Associative Array question
  204. What are the ports involved with DB Link
  205. Off Topic, but brilliant
  206. Oracle 9i and 10g on same server
  207. SQL transaction timeout
  208. OMS not found
  209. NewBee - Read Cursor
  210. ora-12162 error on Solaris
  211. oracle lite 10i OracleParameter
  212. SQL*Plus web interface
  213. Real World Experience of Oracle RAC and its ability to Scale
  214. FAQ - Etiquette - and how to get an answer
  215. How to get the ID of a newly added record from ADO
  216. How to get single developer licence with support?
  217. Query from Forms not using Index
  218. ODBC error on XP
  219. partition change tracking
  220. Archiver question
  221. Locking issues caused by self-referencing foreign key
  222. query help
  223. Doing multiple row inserts using one insert statement
  224. Opening multiple cursors in a loop in Oracle
  225. Errors running scheduled job
  226. PL/SQL script for Indendted Bill of Material BOM
  227. from a cursor to a recordset
  228. RMAN Recovery Error
  229. Made stupid mistake, how can I recover?
  230. Performance considerations during Oracle imp/load
  231. hotmail password request tool (intranet usage)
  232. Redo Log File - Analysis
  233. PL/SQL newbie question
  234. OEM Console - Missing Databases
  235. tablespaces & schemas
  236. Oracle SQL creating table as a copy of table
  237. Doubt about cursors
  238. ASM on Solaris logical volumes
  239. Problem with Oracle Timezones
  240. It seems that Dr. OMLET has been shot 10 days ago!
  241. new opatch and/or Apr2005CPU on hpux rac
  242. Use of htp.print........
  243. automatic startup on solaris
  244. Java Trigger and SP
  245. Java Trigger and SP
  246. sqlldr and sort_area_size
  247. SQL Server CE to other databases
  248. converting from "cooked" to "raw" oracle database
  249. Counting unique customers per day, week, month, year..
  250. Data Skew