Forum |
Messages |
Topics |
Last message |
SQL & PL/SQL - Oracle database SQL and PL/SQL Forums.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
SQL & PL/SQL Oracle SQL and PL/SQL topics including queries, DML and DDL statements, stored procedures, functions, packages and triggers. |
280584 |
50834 |
Wed, 04 September 2024 By: Duane ![Re: Query CLOB column with values in a Set List Re: Query CLOB column with values in a Set List](/forum/theme/orafaq/images/goto.gif) |
RDBMS Server - Oracle RDBMS Database Server.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Server Administration Managing and Administering the Oracle RDBMS. |
62128 |
16165 |
Wed, 07 August 2024 By: Olexandr Siroklyn ![How to fix XDB How to fix XDB](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Backup & Recovery Oracle Backup and Recovery - RMAN, User Managed Backups, Oracle Secure Backup (OSB), OSB Express, etc. |
19597 |
3668 |
Thu, 20 July 2023 By: John Watson ![Re: PITR with RMAN not working Re: PITR with RMAN not working](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Performance Tuning Measuring and improving database server performance: forecasting, capacity planning, workload modeling, tuning, scalability, etc. |
29241 |
4732 |
Wed, 03 April 2024 By: John Watson ![Re: Table Statistics Keep Getting Stale Re: Table Statistics Keep Getting Stale](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Security User and Password management, Roles and Privileges, Auditing, Audit Vault, Virtual Private Database, Vulnerabilities, Sarbanes-Oxley compliance activities, etc. |
6706 |
1373 |
Fri, 26 April 2024 By: Michel Cadot ![Re: Unlocking Oracle 9i SYS user Re: Unlocking Oracle 9i SYS user](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Networking and Gateways SQL*Net, Listener, OID/LDAP, Oracle Names, Connection Manager, Network Manager, Database Links, Oracle Gateways, etc. |
9507 |
2327 |
Fri, 29 September 2023 By: Michel Cadot ![Re: TNS-03505: Failed to resolve name from 12c client to 19c DB Re: TNS-03505: Failed to resolve name from 12c client to 19c DB](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Enterprise Manager Oracle Enterprise Manager (OEM) and Management Cloud (OMC); DB and Grid Control; Management Server (OMS) and Agent (DBSNMP). |
6354 |
1756 |
Tue, 21 November 2023 By: wtolentino ![Preferred Credential How to Use Preferred Credential How to Use](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Server Utilities Datapump, Import, Export, SQL*Loader, TKPROF, asmcmd, nid, orapwd, etc. |
24137 |
5638 |
Mon, 19 August 2024 By: Olexandr Siroklyn ![Re: How to import a higher TZ dump file into a lower TZ database Re: How to import a higher TZ dump file into a lower TZ database](/forum/theme/orafaq/images/goto.gif) |
Server Options - Oracle Database Server Options.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
RAC & Failsafe Oracle RAC/OPS (Real Application Clusters/ Oracle Parallel Server) and Failsafe questions. |
4530 |
1140 |
Tue, 09 January 2024 By: trantuananh24hg ![Re: No X11 DISPLAY variable was set Re: No X11 DISPLAY variable was set](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Data Guard Oracle Data Guard/ Active Data Guard - physical (redo apply) and logical (SQL apply) standby databases. |
4132 |
941 |
Fri, 29 September 2023 By: LIPEKA ![Re: RMAN-00554 RMAN-04006 Re: RMAN-00554 RMAN-04006](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Replication Materialized View (snapshots), GoldenGate, Sharding, Advanced Replication issues and solutions. |
2811 |
972 |
Wed, 19 July 2023 By: trantuananh24hg ![I would like to find out replicated objects in existing Golden Gate environment I would like to find out replicated objects in existing Golden Gate environment](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Streams & AQ Oracle Streams (Capture, Stage, Apply) and Advanced Queuing. |
1259 |
431 |
Wed, 03 June 2020 By: siva_faq ![Re: Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance Re: Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Spatial Oracle Spatial (SDO) and Locator - geographic and location data. |
538 |
189 |
Wed, 25 August 2021 By: _jum ![Re: ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object (split from "ORA-0939: too many arguments for function") Re: ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object (split from "ORA-0939: too many arguments for function")](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Text & interMedia Oracle Text/ Context/ interMedia and Ultra Search questions. |
2067 |
542 |
Tue, 10 October 2023 By: leon@ubeeo.nl ![delete from ctxsys.dr$delete - statement not using bind variables: how to contain of limit? delete from ctxsys.dr$delete - statement not using bind variables: how to contain of limit?](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Multitenant Oracle Multitenant - Container (CDB) and Pluggable Databases (PDB). |
101 |
21 |
Wed, 26 July 2023 By: SaschaG ![RAM of Services goes up after swap to Multitenant RAM of Services goes up after swap to Multitenant](/forum/theme/orafaq/images/goto.gif) |
Developer & Programmer - Oracle Internet Developer Suite and Programmer.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Application Express, ORDS & MOD_PLSQL Oracle Application Express (APEX - previously called HTMLDB), REST Data Services and MOD PL/SQL Questions. |
4150 |
1023 |
Thu, 16 November 2023 By: John Watson ![Re: Parse CSV file from shared folder Re: Parse CSV file from shared folder](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Forms Oracle Forms and Forms Builder (former Developer/2000 Forms). |
75382 |
17411 |
Fri, 30 August 2024 By: hassan08 ![Calling api from oracle forms12c Calling api from oracle forms12c](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Reports & Discoverer Oracle Reports and Oracle Discoverer issues. |
18607 |
5960 |
Fri, 02 August 2024 By: Littlefoot ![Re: count student Re: count student](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Designer Oracle Designer and General Database Design Issues (including CASE, ER-Modeling, UML, etc). |
1073 |
450 |
Tue, 28 September 2021 By: Liuc ![Database design asylum attendant commission secretariat - I need your opinion Database design asylum attendant commission secretariat - I need your opinion](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
JDeveloper, Java & XML Oracle JDevloper, including general Java and XML questions. |
6882 |
2272 |
Tue, 13 February 2024 By: NevemTeve ![Jdbc: extract java.time.LocalDate from java.sql.Struct Jdbc: extract java.time.LocalDate from java.sql.Struct](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Data Integration Oracle Data Integrator (ODI), Oracle Warehouse Builder, Data Mart Suite, Express, and general Warehousing questions. |
1891 |
872 |
Thu, 28 September 2023 By: bmccollum ![Conditional Execution of Steps in ODI Load Plan Conditional Execution of Steps in ODI Load Plan](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Precompilers, OCI & OCCI Oracle Precompilers (Pro*C, Pro*COBOL, etc), Call Interfaces (OCI) and C++ Call Interface (OCCI). |
3410 |
1196 |
Thu, 04 May 2023 By: Michel Cadot ![Re: Error ORA-01480: trailing null missing from STR bind value Re: Error ORA-01480: trailing null missing from STR bind value](/forum/theme/orafaq/images/goto.gif) |
Fusion Middleware & Colab Suite - App Server and Collaboration Suite.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Weblogic & Application Server Weblogic Server, Oracle Internet Application Server (iAS) and other web server technologies. |
4215 |
1786 |
Thu, 11 July 2024 By: sathivkr ![oracle 12c reports oracle 12c reports](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Business Intelligence Oracle BI Suite (OBIEE), BI Publisher, BI Beans, Mapviewer, etc. |
1082 |
453 |
Sun, 06 August 2023 By: srinivas.k2005 ![Re: 30 data files handling in Oracle Re: 30 data files handling in Oracle](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
WebCenter Suite & Portal Oracle Portal (old WebDB), Portal to Go and WebCenter Suite Questions. |
558 |
324 |
Thu, 09 April 2015 By: hcdba ![Re: ORA-12560 : TNS: protocol adapter error Re: ORA-12560 : TNS: protocol adapter error](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Collaboration & Content Management Enterprise Content Management (ECM), Oracle Beehive and Oracle Collaboration Suite (E-mail, Voice Mail, Calendar, Internet Filesystem and Search). |
91 |
54 |
Thu, 27 October 2011 By: donato ![Re: UCM Services - ¿how to configure? Re: UCM Services - ¿how to configure?](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
SOA Suite, BPEL and OWSM Business Process Execution Lanaguage (BPEL), Service Oriented Architecture (SOA)
and Web Services manager (OWSM). |
124 |
70 |
Thu, 27 February 2020 By: pnima ![Re: soa12c Jdev12.2.1.1.0 integration with spring java 1.8 - Need Help Re: soa12c Jdev12.2.1.1.0 integration with spring java 1.8 - Need Help](/forum/theme/orafaq/images/goto.gif) |
Applications - Oracle Fusion Apps and Third Party Application Suites.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Oracle Fusion Apps & E-Business Suite ERP and CRM Applications (Financials, Manufacturing, General Ledger, Human Resources, etc). |
16417 |
6357 |
Tue, 02 April 2024 By: Swale ![Re: Delete Mass Additions - Posted Status Re: Delete Mass Additions - Posted Status](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
PeopleSoft, JD Edwards & Siebel PeopleSoft, J.D. Edwards and Siebel Application Suites. |
258 |
147 |
Fri, 06 December 2019 By: hazrimiomar ![Siebel Server CRM 17.0 installation : Unable to browse to server Siebel Server CRM 17.0 installation : Unable to browse to server](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Primavera Primavera Professional Project Management (PPM), Primavera Enterprise Project Portfolio Management (EPPM), Primavera P6 Analytics. |
35 |
11 |
Mon, 18 December 2023 By: midev ![P6 Primavera (SQL Server) -> RDS (AWS) P6 Primavera (SQL Server) -> RDS (AWS)](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Other Application Suites Other 3rd Party Application Suites like SAP R/3, Baan, etc. |
220 |
97 |
Thu, 25 March 2021 By: LPowell911 ![When to Work Integration When to Work Integration](/forum/theme/orafaq/images/goto.gif) |
Infrastructure - Hardware and operating systems for running Oracle products.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Cloud and Hosting Oracle Infrastructure (IaaS), Platform (PaaS), and Software (SaaS) as a Service. Including Cloud@Oracle, Cloud@Customer, Amazon Services, etc. |
50 |
18 |
Fri, 24 November 2023 By: John Watson ![firewalld and DB System nodes firewalld and DB System nodes](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Hardware Exadata, Exalogic, Database Appliance (ODA), Big Data Appliance, and other (mainly SUN) hardware and storage solutions. |
69 |
24 |
Sun, 19 November 2023 By: cygent ![Looking for Firmware for Oracle Dual 40 Gb Ethernet Adapter Looking for Firmware for Oracle Dual 40 Gb Ethernet Adapter](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Linux Oracle Installation, Configuration, Troubleshooting and Scripting on Linux Platforms (Oracle Enterprise Linux, RedHat, SuSE, Ubuntu, Mandriva, etc.) |
5605 |
1290 |
Tue, 16 July 2024 By: jpngoi ![Oracle Patch Oracle Patch](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Unix Oracle Installation, Configuration, Troubleshooting and Scripting on Unix platforms (Solaris, HP-UX, AIX, etc.) |
6713 |
1895 |
Tue, 04 May 2021 By: Michel Cadot ![Re: View creation script is copying data to log file (merged) Re: View creation script is copying data to log file (merged)](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Windows Oracle on Microsoft Windows - Installation, Configuration and Troubleshooting (including ODP.NET, VB, ASP, DAC, ODBC, OO4O and OLE DB issues). |
7743 |
2090 |
Thu, 11 July 2024 By: ThomasG !["Performance Poll" Oracle -> SQL Server Analysis Services "Performance Poll" Oracle -> SQL Server Analysis Services](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Other Operating Systems Oracle on Operating Systems like IBM Mainframes (z/Linux, OS/390, MVS), AS/400, VMS, Apple Macintosh, Novell Netware, FreeBSD, etc. |
1031 |
413 |
Tue, 14 May 2019 By: trantuananh24hg ![Re: Oracle database on OpenStack Re: Oracle database on OpenStack](/forum/theme/orafaq/images/goto.gif) |
Open Source - Oracle open source products.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Programming Interfaces Database programming for Open Source languages like PHP, Perl DBI, Python, Ruby, ODBC, JDBC and SQLJ. |
1158 |
295 |
Thu, 06 April 2023 By: Barbara Boehmer ![Re: sql query Re: sql query](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
MySQL MySQL discussions: InnoDB, MySQL Cluster (ndb), etc. |
494 |
128 |
Fri, 15 November 2019 By: John Watson ![Re: Insert data from Oracle 11g to MYSQL Re: Insert data from Oracle 11g to MYSQL](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
NoSQL NoSQL (Not Only SQL) discussions, including Oracle NoSQL, Hadoop and other Big Data databases. |
15 |
5 |
Wed, 29 July 2020 By: rohit_shinez ![Latest month Partition in hive Latest month Partition in hive](/forum/theme/orafaq/images/goto.gif) |
Other - Non-product related Oracle Discussions.
|
|
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
General General Oracle discussions that don't belong in any other forum. |
8712 |
2303 |
Thu, 13 June 2024 By: John Watson ![Re: MOS Re: MOS](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Training & Certification Education and Certification (OCA, OCP and OCM), Exams and Training opportunities. |
8766 |
2107 |
Fri, 01 September 2023 By: moizmohammed ![Re: which is the best institute for oracle apps scm in hyderabad Re: which is the best institute for oracle apps scm in hyderabad](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Client Tools Tools for executing SQL and PL/SQL commands: SQL*Plus, iSQL*Plus, SQL Developer and SQL Worksheet. Including 3rd party tools like TOAD, DB Artisan, SQL Navigator, PL/SQL Developer, etc. |
9933 |
1675 |
Sat, 23 March 2024 By: John Watson ![Re: Generating lots of concurrent sessions Re: Generating lots of concurrent sessions](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Marketplace Career advice, job vacancies, resumes, product adverts, announcements, etc. |
6306 |
3024 |
Wed, 21 February 2024 By: Viktoriian ![Don't Miss the Newly Updated dbForge Studio for Oracle v4.6! Don't Miss the Newly Updated dbForge Studio for Oracle v4.6!](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Community Hangout Forum where people can ask who is going to an Oracle event, announce a birth, post some vacation pictures or tell a computer joke. The conversation is sort of like what you might hear while gathered around the water cooler at work or having lunch with coworkers. |
3363 |
380 |
Tue, 21 May 2024 By: Littlefoot ![Re: MICROWAVE WOES Re: MICROWAVE WOES](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
News & Blogs News and Blog posts - please migrate blog posts from the home page to his forum. This forum will eventually become the home page. |
5 |
2 |
Fri, 22 March 2024 By: Frank Naude ![We are back on-line! We are back on-line!](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Suggestions & Feedback Post your feedback and suggestions for this site (OraFAQ) here. All suggestions, feedback, comments, ideas, etc are more than welcome. |
3731 |
458 |
Fri, 05 July 2024 By: Michel Cadot ![Re: Site statistics Re: Site statistics](/forum/theme/orafaq/images/goto.gif) |
|
![Only registered forum members can track read & unread messages Only registered forum members can track read & unread messages](/forum/theme/orafaq/images/existing_content.png) |
Test Use this forum to post practice / experimental messages before posting to the other forums. |
1221 |
395 |
Tue, 16 July 2024 By: Michel Cadot ![Re: Oracle Patch Re: Oracle Patch](/forum/theme/orafaq/images/goto.gif) |
Non-English Forums - International Oracle Support Forums.
|
|
|
|
Available Forums:
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish |