Questions tagged [oracle-18c]
Oracle Database 18c. Please also tag oracle for search purposes.
24
questions
1
vote
1answer
32 views
Create a view with distributed Lobs
I have two Oracle 18c instances (instance 1 with schema DB1 and instance 2 with schema DB2) and I know that there ist a support for distributed lobs since 12.2. So i did the following:
CREATE TABLE ...
2
votes
1answer
112 views
Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?
I have 40 views in an Oracle 18c GIS database that are used in a map in a workorder management system (WMS).
The views are served up to the WMS map via a web service.
There are an average of 10,...
0
votes
0answers
28 views
How to import db-sample-schemas into Oracle's DB?
I need to import some sample dump file for educational and testing purposes. I've found the next dump file and tried to import it using:
imp testuser/oracle file=/home/oracle/PurchaseOrders.dmp
...
0
votes
1answer
579 views
Unable to install Oracle XE 18c on Centos 8
I am trying to install Oracle 18 on Centos 8 64 Bit.
I have been able to install the prerequiste component, that in itself requires pre-requisites, but the Oracle install itself fails.
Any ...
0
votes
1answer
26 views
Unable to connect to oracle user
I have hit a rather frustrating snag in that after installing Oracle 18c.
I have been unable to successfully create a user and then connect to it.
More precisely I can create the user but the ...
0
votes
1answer
49 views
Automatically purge dropped tables in Oracle
I am using an Oracle 18c database in a build system.
One of my builds is for a JPA/Hibernate project, which is configured as "create-drop". This means it will create all tables during startup and ...
0
votes
1answer
34 views
Oracle JSON ADT in Collection
Why is the table() operator not working?
create or replace type tmp_011040_t2 as
table of (JSON_OBJECT_T) NOT PERSISTABLE;
declare
l_objects tmp_011040_t2;
begin
l_objects := tmp_011040_t2();
...
0
votes
1answer
22 views
How to make Swingbench 2.6 and Oracle 18c work together?
Swingbench 2.6 supports Oracle 12c and I have been using it for 12c successfully. But I want to use it with Oracle 18c for testing purposes.
In case of using different wizards from swingbench\winbin ...
0
votes
0answers
195 views
exceeds the maximum allowed database size when export database oracle 18c
I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues
ORA-12954: The request exceeds the maximum allowed database size ...
1
vote
1answer
112 views
APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created
I am trying to install APEX 19.1 on ORACLE XE 18c but the problem is that APEX_LISTENER and APEX_REST_PUBLIC_USER are not being created. While I execute apex_rest_config.sql script via sqlplus, an ...
1
vote
0answers
54 views
Oracle procedure takes forever to compile if I use public synonym
I have a procedure that queries a table through a DB link. If my procedure uses a public synonym through the DB link, it takes forever to compile.
I'm creating the procedure in Oracle 12c. The DB ...
1
vote
1answer
478 views
Issues setting up Oracle 18c XE on Windows Server 2012 r2
I've been running into some problems getting my Oracle installation up and running on Windows Server 2012 r2 at work. Initially, I had installed Oracle on my Win10 laptop for test purposes - I ...
1
vote
2answers
482 views
Issue Moving data from 11g to 18c
I have an rman database backup from Oracle 11g XE which i am trying to import into oracle 18c XE database using below commands
rman target /
shutdown abort;
startup nomount;
SET DBID ...
1
vote
0answers
271 views
Oracle 18 on Windows with long hostnames doesn't talk to the local listener?
Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
1
vote
1answer
156 views
Falied to load resource files of Oracle APEX plugin
I've installed a plugin in APEX, but when I've tried to use it on a page, I've got some nasty errors and page not working properly.
The files are present in the plugin settings:
But, as you can see ...
0
votes
0answers
151 views
Connect to Oracle database as apex_version user
I'm talking about schemas like APEX_040200, APEX_050100, APEX_180300, APEX_190100 etc.
I'm trying to install an APEX Plug-in that is being installed from a script, where developper commented Assumes ...
0
votes
0answers
108 views
Reference apex_workspace_apex_users or wwv_flow_fnd_user in a foreign key constraint
What I'm trying to do is to extend authorisation upon APEX basic users to use it as conditions of pages rendering. I would like to create additional tables to store some workspace specific info about ...
1
vote
1answer
431 views
Error while configuring REST for Oracle APEX on Windows
I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide.
But when I'm trying to run @apex_rest_config.sql I get this ...
0
votes
1answer
769 views
Cannot create an additional database in Oracle 18c XE
Creating a new database in Oracle 18c XE throws this error, does this mean that I can only use the database created by the installation?
ORA-00442: Oracle Database Express Edition (XE) single ...
1
vote
1answer
2k views
Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”
I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using
connect / ...
0
votes
0answers
677 views
Change Encryption Wallet type from PASSWORD to AUTOLOGIN
I am currently working on an Oracle 18.3 DB and I have a script which allows me to create an encrypted seed PDB. As part of this script, we encrypt the system tablespaces (like SYSTEM, SYSAUX, and ...
1
vote
1answer
77 views
How to disable Oracle OCI client transparent reconnect
I have an application I wrote that uses OCI to connect to an Oracle database. The database has recently been upgraded to Oracle 18, and since then database searches in the application randomly stop ...
1
vote
1answer
6k views
Oracle 11g XE to 18c XE - What is the difference? Is 18c can be used like 11g XE?
I have worked on Oracle 11g XE about two months ago. After that I de installed them about a week ago. Now, I am curious to learn a little bit more about databases and I tried to installed Oracle 11g ...
2
votes
2answers
6k views
Oracle database 18c – ORA-12541: TNS:no listener
I have installed Oracle 18c in my local machine and i have created a user names as
USER_NAME := c##scott
Passkey : oracle
When i used to connect to that user using cmd. The following error is ...
