Question : Well, here’s the database structure I’ve created for a quiz. DROP TABLE “E20079852” cascade constraints; DROP TABLE “E20079852_DEPARTMENT” […]
Tag: oracle-12c
Group by NAME and YEAR, categorize NAME [duplicate]
Question : This question already has answers here: Pivot, categorize and group by (3 answers) Closed 5 years ago. I […]
ORA-01017 when connecting remotely as sysdba
Question : Good morning, While installing a database for Oracle Entreprise Manager Cloud Control (OEMCC) I can’t login as sysdba, […]
Unable to open/connect to Oracle 12c Enterprise Manager Express [duplicate]
Question : This question already has answers here: Oracle 12c Express Enterprise Manager webpage does not load (5 answers) Closed […]
How to install olaptrain sample schema on oracle 12c?
Question : I need to install the sample schema available from the Oracle website: http://download.oracle.com/otndocs/products/warehouse/olap/olaptrain_install.zip I am trying to run […]
SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)
Question : How could I use “Linked Server” from SSMS IDE to connect the Oracle server database with “SYSDBA”? I’ve […]
Moving Oracle / Oracle datafiles to different file system on Linux
Question : We have Oracle installed on /root, which is now running out of space due to increasing data in […]
Determine Oracle package body memory size
Question : We have recently added a lot of new packages to our system, and trying to determine incremental memory […]
“Credential retrieval failed” during recovery of an Oracle database
Question : When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: […]
Oracle 12c client installer error
Question : I’m trying to install Oracle client 12.1.0.2.0 (32-bit) on a completely clean copy of windows Server 2012, and […]