oracle

  1. How to list Oracle objects that have not been used in the last month?

  2. ORA-02270: no matching unique or primary key for this column-list

  3. How to find object name given in a problematic query
  4. Unable to connect to pluggable database using TNS but EZCONNECT is OK

  5. Import all csv files into a table oracle
  6. Simulate pipelined order by in oracle 11g

  7. Check Oracle Service is Started from Batch Command

  8. Oracle high Paging Faults
  9. Linked server to Oracle doesn't use filters. Are there any performance changes in different versions of SQL Server?
  10. oracle regexp_replace to remove duplicate duplicate strings and double separators

  11. How do I delete a file that has been locked by UTL_FILE?
  12. How to erase in sqlplus with backspace?

  13. ORA-01196: file 1 is inconsistent due to a failed media recovery session
  14. RMAN corrupts passwordfile

  15. Validation query

  16. Connect to oracle 11 on a corporate network via oracle developer 17
  17. sqlplus works specifying the parameters but fails when using tnsnames.ora

  18. How to make tables unavailable for users during certain times in Oracle?
  19. How to join multiple columns from different tables

  20. Is (and if how) it possible in Oracle to "insert into <table> values <rowtype-variable>" if <table> has virtual columns
  21. Achieve log transfer to standby (Data Guard)

  22. Will use of Oracle pluggable database lead to cost reduction and why?

  23. Oracle 11g installation on RHEL 7 using Tigervnc
  24. Restore Oracle Database excluding some tablespaces

  25. How to create a trigger that will insert values into another table twice?

  26. Does Oracle do a native conversion to numbers for varchar2 that are aggregated?

  27. adcfgclone.pl dbconfig fails when trying to configure the database to use logical host names

  28. How to handle 10k parallel queries on an Oracle 12?
  29. Installing oracle 9i in RHEL5 ... error during the process

  30. UTL_TCP how to monitor number of connections?
  31. Is it possible to connect to Oracle Database through OCI using a reverse proxy?
  32. Toad Oracle Home
  33. When field is null, get value from another row
  34. How to avoid hardcoding a database link name in a package body

  35. Cannot fix ERROR:ORA-01031: insufficient privileges
  36. Oracle 12 Grid installaton falsly detecting pre-existing ASM installation
  37. Oracle shrinking / reclaiming free tablespace space

  38. Create User, Tablespace Replication in Oracle GoldenGate
  39. One user for all database applications
  40. How to convert Bytes to GB using sql query

  41. What are the considerations when using SERLIALIZABLE over READ COMMITTED isolation level in Oracle?

  42. Oracle 10gR2 - fix for SSL version following Poodle attack

  43. Oracle: Replace corrupted first datafile

  44. Restore/import tables from unsuccessful database dump file

  45. How to change the path of temp file,redo log file when restore an rman backup on another machine?
  46. create additional oracle 11g database in linux
  47. Oracle Ref Partitioning: Deadlock due to child table row migration

  48. How to uninstall Oracle 11G software that are installed in Windows 8?

  49. Running Oracle Export Utility within a Shell script

  50. Gap resolution of Logical Standby Database via Archive Log Backups

  51. How can I prevent UNPIVOT from being transformed into UNION ALL?
  52. sqlplus is not starting

  53. What is the best way to insert a XML input to an oracle table in stored procedure?
  54. what is oracle universal installer in oracle database products
  55. How to delete tablespace and table after delete datafiles?
  56. Oracle "new or old reference not allowed in table level trigger"

  57. Configure Oracle EM to Send Emails

  58. FileWatcher Troubleshooting Options

  59. ORA-20013: DBMS_QOPATCH ran mostly in non install area

  60. Oracle Rac With Scan Error

  61. How to capture all user's query on Oracle database
  62. What are the real life cases for using Oracle advanced queuing?
  63. SQL set allowed values for a column

  64. Oracle sqldeveloper Database Diff - not seeing indexes/sequences

  65. Interpolate dates along a line

  66. SSRS 2012 Report with Oracle database as datasource never finishes

  67. LAST_DDL_TIME Not Changing after compilation of package body

  68. Query on SCAN in RAC
  69. How do I kill Oracle DataPump expdp job stuck in DEFINING state?

  70. SYSDBA password in Oracle DB
  71. SGA size vs SWAP space in Oracle RAC
  72. Change Oracle user home directory at OS level after Oracle Databse/Client Software Installation
  73. Why is Oracle scanning table multiple times on PK creation?

  74. Oracle DB Point In Time Recovery faulted

  75. Does Oracle Streams replicate unused columns?
  76. Oracle Active Sessions Wait for Scheduler

  77. How to display '0' where no data found in PL/SQL Oracle Reports

  78. Strange error in trace file for NSAn standby process

  79. Multiply and divide dates

  80. sqlldr running slow after indexes created

  81. Oracle 12c: Password File Questions
  82. Problem when inserting Chinese characters in Oracle database

  83. SELECT from Function that return CURSOR
  84. Select without From SQL Server

  85. How to switch Quiescing to Normal Mode in Oracle?
  86. Why is my biggest segment resulting in an empty table?
  87. How to update scheduler job credentials in oracle enterprise manager?
  88. What privileges are required to execute CTX_DOC.SNIPPET from a different user?
  89. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux
  90. frm-92100:your connection to the server was interrupted

  91. Oracle 12c database cannot log in as a local user

  92. Oracle schema import is not importing all the tables present in the schema dump file

  93. Long running statement not monitored by Oracle

  94. OCIEnvCreate failed to create environment handle after installing oracle_fdw
  95. Why cannot I execute dbms_space_admin.drop_empty_segments despite granted?
  96. Root cause for Invalid arguments in call (ORA-17068)

  97. PL/SQL recursive lookup with cursor

  98. Oracle full expdp/impdp but skip data in some tables
  99. Stored procedure with ROW instead of a list of parameters

  100. Oracle XE TNS Listener fails to start