PDA

View Full Version : Oracle Database

  1. Forward Declaration in Pkg Body
  2. Re: Help me read my statspack report
  3. Index based database?
  4. Error with OCI8 driver installing sendmail/javamail
  5. imp table ( overright previous data )
  6. which is fast and good output
  7. How to improve query performance with ,,connect by" clause?
  8. Help me read my statspack report
  9. tablespace reorg
  10. query needed very urg.
  11. How to Alter DUAL table to change value
  12. Retrieve list of n largest tables in a db
  13. Is this feasible?
  14. how to use clob
  15. Index on External Table
  16. Client problem
  17. non-AQ messaging question
  18. Oracle Transparent Gateway
  19. Table with object column, errors 22913 and 22912
  20. how to delete duplicate tuples???/
  21. design question
  22. looking for a subject to start in oracle
  23. Oracle RAC installation "shared raw logical volume"
  24. all of oracle references in one site ready for download
  25. [ora10] Yet another cloning question
  26. access to v$ and dba tables for user
  27. PMON Problem : server process without user process
  28. is index better option here
  29. Differentiating results of SELECT query
  30. Where are the XE security patches?
  31. Help on query
  32. Join selectivity is 0 causing bad cardinality estimates.
  33. Oracle Chaining
  34. Select into problem
  35. modelling IPv6 as a number
  36. Installing only SQL*Plus on XP
  37. RAC VIP related question
  38. Autoincrement without a sequence
  39. Oracle Unit Testing
  40. INSERT with WHERE???
  41. Theory Questions concerning MVD and Functional Dependency.....
  42. hello everybody
  43. [ora10] Cloning database, Unknown command 'DATAFILE'
  44. Version Control for Oracle Developer
  45. Union query
  46. Create directory as '.......'
  47. change database character set
  48. current users enquiry
  49. national character set and database set
  50. exp direct=y
  51. exp direct=y
  52. Oracle and Linux
  53. cannot delete
  54. Help reading my report.txt
  55. oracle and disk sub-system
  56. understanding stack trace
  57. C/C++ interface
  58. v$sqlarea.bind_data
  59. #prompt('p_division','string')#
  60. Password Management and Database Security
  61. sqlplus "command not found" connecting with ssh
  62. isql viewer
  63. How to sum up values into a 419(!!) columns wide Table
  64. opiino: Attach failed! error=-1 ifvp=00000000
  65. Interview questions for Oracle database administrator
  66. Is this group still alive?
  67. Need help
  68. oracle stored procedure progress
  69. Introducing pitchbuster.com - Bust those sales pitches against Oracle
  70. Help Migrating: Solaris 8.0 supporting a Oracle 8.17
  71. Wallet Security Issue
  72. timestamp and date format
  73. Help: How should I live with 'literal' application
  74. Re: Delete of child-entry locks father-table
  75. count(*) - sample block
  76. What is expected behavior in v$session_longops for simple update
  77. Limit to MaxEngine in Oracle 10g
  78. Checkpoint Not Complete
  79. MetaLink article on GLOBAL_NAMES
  80. locally managed tablespaces and free space
  81. A question on Distributed transactions in oracle 8i
  82. database link name
  83. SQL to list a user's packages and its procedures
  84. Are occi statement objects persistent?
  85. MERGE statement not working with use of hints
  86. compress while exporting file on Window using winzip
  87. Size of files. Can you estimate?
  88. statspack comment is needed
  89. Newline in raise_application_error()
  90. Flashback query and ORA-01555, rollback segs
  91. Help with query
  92. Recovery performance of standby databases
  93. SQL - Time Specific Daily Query
  94. Agent 10g RAC installation confusion
  95. wildcard search and full tablescans
  96. Help with constraints
  97. user names are not matching to users in database
  98. What went wrong with this Function First?
  99. Temporary tablespace growth
  100. Installing ASM...
  101. Converting a 'select' into dynamic SQL
  102. Load Java classes
  103. Oracle 8
  104. How to drop/delete/remove histograms? (CBO Column stats)
  105. the script to start listener in /etc/rc3.d/ failed...
  106. Tables using triggers/procedures
  107. CASE expression
  108. a database has very high accumulated CPU time for CKPT
  109. Deadlock detected when doing "ALTER USER"
  110. Import flat files to Access using PL/Sql
  111. who deleted applied archived log in standby database?
  112. Oracle AQ can't propagate messages
  113. Recycling the listener
  114. Updating oracle net files
  115. Updating oracle net files
  116. dllhost.exe
  117. Different connect strings needed for RMAN and sqlplus?
  118. ORA-04021: timeout occurred while waiting to lock object start1.st
  119. Java classes
  120. Media for Oracle 8.1.7.2 on RedHat Linux
  121. hi alll......How can i connect to oracle9i db and fetch the data from specific tables using shell script
  122. Figures to monitor
  123. RAC, ASM, and SQL-BackTrack.....
  124. (.NET) retrieving BLOB from Oracle via proc
  125. OCI prefetching does not work for scrollable cursors
  126. Commented-out lines in Production
  127. Where can i find a list of uncommitted transactions or sql statements run?
  128. "start with" non using index
  129. Querying environment variables
  130. 10.2.0.3
  131. Web service and types
  132. Delete of child-entry locks father-table
  133. sql server transparent gateway
  134. sysdate
  135. Deferrable Constraints
  136. group functions
  137. Joins
  138. MATERIALIZED VIEW
  139. Trigger on create user
  140. Find out the name of Oracle DB on a solaris server?
  141. HASH ANTI-JOIN, FTS and sequential reads
  142. importing a split oracle dump into windows environment
  143. Character mode report in 9iAS
  144. Drop a table via synonym
  145. recovery without restoring backup
  146. Create object in other schemas?
  147. A query to return row counts of all tables in cat
  148. Help Dumping a Block
  149. RMAN Backup. restore to other machine
  150. Return limited rows from a table
  151. Procedure hang, session still there
  152. Privs of RESOURCE role not showing up
  153. SQL - Oracle Error
  154. V$SESSION_LONGOPS sofar/totalwork *always* = 1 in 10g ?
  155. Performance Issue
  156. inserting null in XMLType
  157. Standby database for standard edition 10GR2 on windows
  158. Function to remove spaces/carriage returns from text
  159. how bad are these vulnerabilities?
  160. Distributing TNS with NIS
  161. Multi Master Detail form in Oracle Applications
  162. Transfer XML schema to XML document in PL/SQL
  163. Using REF cursor in method 4 of dynamic SQL
  164. Exception in In-Line Function
  165. changing service name
  166. PGA & Open_Cursors
  167. upgrade from solaris 8 to solaris 10 with Oracle 9i database
  168. How to assign values to a table of Record Type
  169. tuning NFS for large backups
  170. query run successfully in sql*plus but return 0 records affected in vb6
  171. Oracle Listener failure
  172. ASM -- Is it Mirrored Stripes or Striped Mirrors
  173. Yet Another Partitioned Table Question ... Example Included
  174. Partitioned Tables and Storage Clause Question
  175. MI5 Persecution: Lander on C4
  176. MI5 Persecution: Observer article
  177. MI5 Persecution: .net magazine article
  178. MI5 Persecution: Financial Times
  179. sql statements missing in continued tracefile
  180. MI5 Persecution: Bizarre magazine
  181. MI5 Persecution: BBC h2g2 online
  182. Conversion from 8i Manual Undo Management to 10g Automatic Undo Management
  183. adding column to table
  184. OracleXE is garbage
  185. Oracle Careers in Scotland
  186. MI5 Persecution: harassment at work
  187. MI5 Persecution: their methods and tactics
  188. MI5 Persecution: their methods and tactics
  189. MI5 Persecution: my response to the harassment
  190. MI5 Persecution: abuse in set-up situations and in public
  191. MI5 Persecution: Bernard Levin expresses his views
  192. MI5 Persecution: Bernard Levin expresses his views
  193. MI5 Persecution: who knows about it?
  194. MI5 Persecution: how and why did it start?
  195. Sessionns blocked by library cache lock
  196. MI5 Persecution: cost of the operation
  197. MI5 Persecution: Capital Radio - Chris Tarrant
  198. MI5 Persecution: bugging and counter-surveillance
  199. MI5 Persecution: the BBC, television and radio
  200. PL/SQL timing problem
  201. Materialized View FAST refreshing
  202. Error in xml functions
  203. How to connect with a Java JMS server from Oracle ?
  204. oracle 8i communicate with oracle 9i
  205. are wombats good?
  206. where are wombats?
  207. Advice on Date Range Partitioned Table
  208. interested in wombats
  209. Export/Import oracle 10g db to another machine
  210. sql question - distinct
  211. Grid Control email notification peculiarities
  212. insufficient privileges
  213. Recruiting Consultants - Allied Solutions Group Inc
  214. 8i hash update parallel query
  215. Any ideas if oracle development is reading and following up on Mr. Lewis's new book
  216. problem export in oracle 10g
  217. How to Run this PLSQL Block.
  218. Risky enable star transformations and trusted Query Rewrites?
  219. Tuning case studies
  220. Do 'sort key too long' error depends on values supplied to query?
  221. Looking for Teradata Professionals
  222. =?big5?B?UENDVyBTb2x1dGlvbniku7zTIC0gTGF3cmVuY2UgQ 2hhbiAownGkSCk=?=
  223. Checkpoint duration
  224. how to install 9i rac on fedora core 4
  225. sipping lightly or drinking deeply from the ASM koolaid?
  226. Yabba dabba dooo!
  227. Block Header Size Confusion
  228. how to loop table every 1 second for no more than 4 seconds
  229. Oracle 10g on Linux
  230. what's wrong with the result of the query on v$sql
  231. What's the alternative of "MERGE w/ INSERT ALL"?
  232. Problem with Unicode
  233. oracle installation on linux laptop with < 256MB RAM
  234. oracle installation on laptop with 232MB RAM
  235. Help!! Even stranger query...
  236. Drop constraints CASCADE not working on 10g Express
  237. How can I prevent ORA-01779 Error:cannot modify a column which maps to a non-key-preserved table
  238. conditional cursor that will start fetching data from where it stopped in last execution
  239. Very high 'log file sync' wait time with no 'log file parallel write' wait time
  240. How can I delete one of two instances?
  241. select data from different database
  242. Problems with imp
  243. extracting minutes from interval in user_jobs
  244. The 5-minute interval in sys.smon_scn_time table
  245. Triggers
  246. How to import a text file
  247. RMAN Restore
  248. Use Inserted Script Values
  249. Use Inserted Script Values
  250. Securing a Shrink Wrapped application using Oracle XE