View Full Version : Oracle Database



  1. Need dumps for OCA 10g 1Z0-042 exam,pls
  2. cannot delete backupset
  3. Lost sys and system passwords
  4. Question about dataguard and Security Patch
  5. oracle performance
  6. Write table data into flat file(.csv,.txt) and again read it from flat file(.csv,.txt)
  7. Help ORACLE 9i spfile and pfile
  8. XE owa_sec.GET_CLIENT_HOSTNAME problem
  9. Do LMT's ignore initial & next parameters in the storage clause?
  10. Creating & Using Package in Current Session
  11. Sql*plus Auto-Commit
  12. Retrieving a value (currency conversion factor) from the Internet
  13. Domestic Alternative To Offshore Outsourcing
  14. Oracle 10g OCA..
  15. 10gR1 - Checkpoint not complete -
  16. Start With/Connect By problem
  17. The delay in backup controlfile as trace?
  18. Oracle 10g install on Windows XP
  19. Oracle 10g RAC Windows
  20. Q: an Inline SELECT forming a column
  21. setenv usage
  22. find/replace on long field
  23. Oracle 10g - Anyone?
  24. DDL for triggers.
  25. Oracle & binary serialization -- BLOB or CLOB?
  26. DB Design - Architecture Question.
  27. SGA and PGA
  28. Help with ORA-04031 error
  29. Hot Back Up in oracle 9i.....
  30. Does Optimizer use P.A.T to calculate cost..?
  31. Recover deleted rows from a table from archive logs?
  32. Combining columns of two tables
  33. Oracle PL/SQL Developer: Nashville
  34. Reading CLOBs
  35. Show content of Export DMP file
  36. Does Ref. Integrity help CBO ?
  37. ORA-12541: TNS:no listener when using utl_http.request
  38. Oracle 10g Install Question
  39. Sending an email with attachment and message
  40. Negative numbers in undo advisor
  41. maybe a error question in Sybex test exam..!?
  42. Installing the Oracle ADO for 9i?
  43. Make an Existing Table NOLOGGING
  44. max_dump_file_size - what value to use?
  45. Calling function from select statement is slower then using subselect in select
  46. DBMS_STATS and partitioned tables with Bitmap indexes
  47. Oracle external authentication on 10g in mixed operating system environment
  48. Sybase/Sql server Outer Joins, nulls, and counts
  49. tnsping resolves but ORA-12154
  50. Problems with Listener after patching to 10.2.0.2.0
  51. Enterprise Data Architecture
  52. extract dev2000 files to xml
  53. lost some data in table
  54. [c.d.o.s] 10gR2 Simple Data Guard question...
  55. Re-import Question
  56. How to restore over an existing DB
  57. date subtraction, ok from SQL Developer, not ok from JSP
  58. Query Problems Across Database Link
  59. Explanation of UTL_FILE.PUT_LINE please
  60. Can anyone explain this huge increase in logical I./O....?
  61. Problem with linked Server
  62. lost datafile :(
  63. Agent10g silent deinstall
  64. How many private memory does one single oracle server process allocate?
  65. Export 8.05 ----> 7.3.4
  66. Consolidation of specific rows retaining another ones unaltered
  67. Where does everyone BUY/SELL PC's/MAC's online???
  68. Looks like the 11g name is going to stick ... we will know for sure tomorrow
  69. What Kind of People go to OOW really ?
  70. 15 thousand runners out at Oracle Open World
  71. Freezing database statistics
  72. Oracle listener going down
  73. How to read long raw column data into a file
  74. date subtraction, ok from SQL Developer, not ok from JSP
  75. Ann: A web based tool for sql to cgi conversion
  76. Apps DBA
  77. log_buffer sizing
  78. The Application requires more database privileges
  79. Installing Oracle 9.2 on Suse Linux 10.1
  80. Statistics for CBO
  81. re - posting ODM.DMS_QUEUE_TABLE question
  82. ORA-01461: can bind a LONG value only for insert into a LONG column
  83. Explain plan from hell
  84. Query compare, which one of query is better?
  85. Turng oracle 10g automatic staitistics collection job
  86. TNS Service Name selector of ODBC configuration on Windows 2000 shows trash with Instant Client 10g
  87. The Need for speed
  88. ANYDATA data type
  89. why people delete statistics bore running statistics
  90. need help setting up test of global users
  91. Package Constants vs Literals
  92. Segment Advisor for 10g
  93. ORA-00289 (suggestion) path wrong for STANDBY instance
  94. Oracle Collaboration Suite
  95. how to generate a randomized "seqno" column
  96. Sybase and inline views, Intersect, MINUS
  97. Moving Oracle from one computer to another
  98. Creation of a FBI leads to drastic path change and catastrophical perf
  99. Web services
  100. Strange problem: Tracing a Zope web application session
  101. LGWR process on standby database
  102. What is DICT.BASE?
  103. [ANN] VTD-XML 1.7
  104. What is needed to specify Oracle instance
  105. HELP!!! work about oracle 9i
  106. HELP!!! work about oracle 9i
  107. Application locking to support optimisitc locking ?
  108. Certification for AIX 5L
  109. Connect without output
  110. Smart example to call webservice
  111. drop temp tablespace takes forever
  112. Tune the query with join and correlated subquery
  113. Interested in learning about Data warehousing/ Data Mining & Oracle BI?
  114. Return value of whenever sqlerror
  115. find out os from pl/sql
  116. alter database suspend
  117. Scheduled End of life / End of Support for OCI 7.3
  118. php_oci8.dll problem -- Oracle 8 + PHP 5 + (win)Apache
  119. ORA-01013 Fault
  120. ORA-12154 Fault
  121. Configure IE 6.0 for iSQL PLUS
  122. IMU - In-Memory Undo
  123. ORA-16040 error when working in Dataguard Environment
  124. standby redo logs in "Clearing" state
  125. Correlated subquery and join in the query
  126. sql_profile
  127. Index Maintenance: Another Oracle Gem
  128. Problems with numbers in ALL_TAB_COLS.
  129. Truncate command internal behavior
  130. Strange undo behavior
  131. data guard log_archive_dest_2 problem....
  132. -1247467259ORA-12154:TNS:Could not resolved service name
  133. Oracle DBA Security Consultant
  134. Is this SQL transformation possible...?
  135. How to handle varchar(4000) field containing carriage returns in reporting?
  136. error during export on 9iR2
  137. refresh test from prod in wrong way
  138. Proxy Logins and Auditing
  139. Difference: Uniq. Constraint & Index ?
  140. Nested Table Functions
  141. serializable isolation level behavior question
  142. MERGE and WITH ?
  143. oracle as soap, rest or XML-RPC client?
  144. ORA-03134
  145. Oracle string issue
  146. most expeditious way to update a large number of rows
  147. Oracle technical blog
  148. Is this JOIN good ?
  149. Table or MV
  150. Disabling check constraints
  151. Insert large strings per sqlscript in clob field
  152. Client Connection Error (TNS-12518 TNS-12560 TNS-00530)
  153. Bind Variables in Oracle lite
  154. About functionality like pivot-table using SQL
  155. General Question: UNION version multiple INSERTS
  156. v$sql how to distinguish between internal dictionary selects and user selects
  157. 9i Deployment on LAN
  158. newbie 2Ques- SQL procedure calling another proc and Select statement
  159. Reorganise local tablespace
  160. Abort script in SQLPLUS
  161. DDL slow, but DML fast.
  162. Creating new users in XE
  163. easy connect string
  164. htmldb
  165. Oracle10g on LinuxxFedora 2) - SQLPLUS Problem
  166. Oracle 10G RAC install on AIX 5.3 - newbee question on required hardware
  167. Dynamic SQL Method 4 : Avoid Re-parsing?
  168. PARTITIONS and GLOBAL INDEXES
  169. Streams in a RAC environment
  170. Archiver error - internal only until freed - but recovery_area is *not* full.
  171. Possible 10.2.0.2 Bug - Can someone confirm this?
  172. why databses don't support 'boolean' type?
  173. DBA_TAB_PARTITIONS.PCT_INCREASE/NEXT_EXTENT null after a SPLIT PARTITION
  174. Fetch out of sequence error in pro C recursive calls
  175. how to get message of line/col in EXCEPTION?
  176. Calling Batch Scripts Experts
  177. java array insert vs. batch
  178. Tablespace Quota Question
  179. How to find which unix os user has executed the DDL statements
  180. Begin... END; gives odd error:
  181. Can I: audit insert/update/delete on TABLE by USER?
  182. Installing CS applications - Calendar Server Config failing
  183. Oracle 10g Microsoft ODBC for Oracle 2.5
  184. Changing recovery_parallelism parameter for Oracle 8i+
  185. String Equality
  186. Re: IM ASKING FOR DONATIONS FOR HEART SURGERY
  187. SQLLDR Invalid Number on Record 2: Windows to Unix
  188. 10g XE: Couldn't run "Go To Database Home Page"
  189. Starting 2 instances of the same Oracle database on the same machine
  190. Warning: Built in 10g Stats gather is broken
  191. Help Creating trigger
  192. Oracle Shoutdown itself and need to Startup
  193. ORA-04030 on Windows
  194. AIX Vs HP-UX Vs Sun Solaris for Oracle
  195. Problems with executing the DBMS_SNAPSHOT Package
  196. Role not found in ROLE_SYS_PRIVS and ROLE_TAB_PRIVS
  197. Could Mark Townsend please comment on this question re: Standard Edition
  198. AIX Unix box for Oracle.
  199. Can someone clarify something on TAHITI for me? - re MVs
  200. A Real Stinker to Solve - EXPERTS APPLY WITHIN (DB Crashing)
  201. Test
  202. sqlplus - windows - ed editor - set to other than notepad
  203. High CPU usage
  204. Alert log file
  205. last time connect to user
  206. need help in framing a query.
  207. Times do not add up in 10046 trace file
  208. IN Clause or OR conditions..
  209. Oracle 10g Database and JSP Pages
  210. Oracle's UNIX Permission to UTL_FILE
  211. [RMAN] Missing archive
  212. Simple Query Help....
  213. Is the 8i ODBC driver certified for use with 9i database?
  214. Q about LVM/DM-multipath and NetApp SnapClones for Oracle 10gR2
  215. Embedded SQL Question..... Please help......
  216. dbms_stats.gather_schema_stats
  217. an odd phenomenum for pseudocolumn
  218. exporting characters from utf8 database to greek
  219. TABLE Function in a Join
  220. Problem with impdp
  221. NEXT usage in CREATE TABLESPACE statement
  222. Index missing after exp with TRANSPORT_TABLESPACE=Y
  223. degrade database patch
  224. Oracle Apps DBA Position in Dallas, TX (Applications 11.5.10)
  225. getting started with enterprise users
  226. Connecting with C#, trying to use 'RETURNING'
  227. Connection between library cache latches and statistics?
  228. Error on eXP
  229. Not able to export from OMS in oracle9i
  230. Extent inffo does not match table size ?
  231. to avoid errors while dropping not existing objects
  232. Migration from sql server to oracle
  233. Question about triggers
  234. Question a propos des triggers
  235. Oracle 8.1.7.4 under windows config issue
  236. gather_system_stats problem on 10.2
  237. Locally Managed Tablespace
  238. sqlldr package
  239. VIRTUAL PRIVATE DATABASE
  240. Compute Schema Size
  241. VERY URGENT REQURIMENT FOR DATA BASE /TEAM LEAD (today interview)
  242. VERY URGENT REQURIMENT FOR DATA BASE /TEAM LEAD (today interview)
  243. Instance Startup History
  244. Update setting -ve number to 0
  245. sqlplus: Help with Spooling (path and file questions)
  246. Baiscs: Exit WITHOUT Commit/Rollback
  247. Autotrace output format
  248. Oracle Internet Directory: Extended Operation Plugin
  249. user with administrative priviledges
  250. .dml/.ddl script files