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. |
280545 |
50828 |
Wed, 05 June 2024 By: suji6281 ![Left Outer Join Error (merged) (duplicate deleted by bb) Left Outer Join Error (merged) (duplicate deleted by bb)](/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. |
62123 |
16163 |
Fri, 24 May 2024 By: Michel Cadot ![Re: How to know if my oracle DB is on premise or cloud Re: How to know if my oracle DB is on premise or cloud](/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. |
24112 |
5636 |
Tue, 16 April 2024 By: Michel Cadot ![Re: impd data only on the same database from one table to another table Re: impd data only on the same database from one table to another table](/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). |
75364 |
17404 |
Sat, 18 May 2024 By: murad060 ![How to create menu using database table (2 topics merged, duplicate deleted, moved to Forms by bb) How to create menu using database table (2 topics merged, duplicate deleted, moved to Forms by bb)](/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. |
18603 |
5959 |
Sat, 18 May 2024 By: narang79 ![Re: frm-41214: unable to run report Re: frm-41214: unable to run report](/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. |
4214 |
1785 |
Tue, 16 January 2024 By: calacausi ![Oracle Reports server 12c. "showjobsid" page does not close Oracle Reports server 12c. "showjobsid" page does not close](/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.) |
5604 |
1289 |
Tue, 02 January 2024 By: Michel Cadot ![Re: Subdomain in BIND9 Re: Subdomain in BIND9](/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 |
1894 |
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). |
7742 |
2089 |
Wed, 15 November 2023 By: Michel Cadot ![Re: Oracle.DataAccess.Client.OracleConnection issues Re: Oracle.DataAccess.Client.OracleConnection issues](/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. |
3730 |
458 |
Thu, 04 April 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. |
1217 |
394 |
Tue, 19 March 2024 By: gazzag ![Re: New laptop test Re: New laptop test](/forum/theme/orafaq/images/goto.gif) |
Non-English Forums - International Oracle Support Forums.
|
|
|
|
Available Forums:
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish |