Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
694
questions
-1
votes
2answers
25 views
Getting the Max date/end date in Oracle query
HI all, I am new to Oracle. My table structure is as follows. I need to find the end date/effective to date for each line. If no new records are there then end date should be SYSDATE. What will be the ...
0
votes
0answers
11 views
Couldn't login to sql developer on oracle 12c
I am trying to login to SQL developer on Oracle 12c but couldn't do so. It shows following error.
Here is output of lsnrctl status
Here is my listener.ora
# listener.ora Network Configuration File: ...
0
votes
0answers
5 views
Loading data from CSV file to oracle table using sql loader
i want to load the data from CSV file to oracle table with this below condition.
if the table is empty then only the data should be loaded into table otherwise data should not be loaded.
is this ...
-1
votes
2answers
37 views
How to check sql query execution time in sql developer
I need to check any sql Statment exact execution time (how much time it will take to complete that sql Statment without running this query) in Oracle sql developer tools without running that sql ...
1
vote
0answers
23 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 ...
2
votes
1answer
21 views
What prerequisites package is needed for Oracle 11g + 12c on the same OL7 server?
I need to install 3 Oracle homes on the same Oracle Linux 7 server, but it's not clear to me what prerequisites I need to install before proceeding.
What I'm planning to set up, is a two-standalone-...
0
votes
0answers
14 views
Not able to use existing Windows user account while setting Oracle 12c db
I am trying to setup Oracle 12c (12.2.0.1.0) on Windows 10 Enterprise. (1809 update). I have a Windows user account created from the Edit Local Users and Groups window. As recommended, the user is not ...
0
votes
0answers
27 views
Across schema views
I have a main schema where all important tables and views are present.
There is upcoming project for audits and I need to create a new schema and have to create 3 views (select * from tablename) and ...
0
votes
1answer
40 views
Failed to install Oracle JDeveloper 12c
I want to install Oracle JDeveloper on my Ubuntu 18.04, and I have downloaded the installer file from here, there I download the file1 and file2 to Linux.
Here is the file name for file1, and the ...
0
votes
2answers
26 views
missing initSID.ora
I learning to use Oracle database, and I just installed Oracle Database 12c Release 2 on my Ubuntu 18.04.
I login as sysdba with this following command:
sqlplus / as sysdba
So far all thing working ...
0
votes
1answer
42 views
Oracle Database Client Installation 12c minimal install - Centos / Red Hat 7
I'm looking at reducing the Linux package prerequisites when installing the Oracle Database Client 12c on the below headless application server / stack:
Install file: V839967-01.zip
Application ...
0
votes
1answer
47 views
Oracle 12c default sys password
I'm new to database and Oracle, but I need to learn it.
I just following this tutorial to install Oracle 12c, I almost on at the end of the steps.
I have finishing install the database with GUI ...
0
votes
0answers
18 views
missing the OracleOraDB12Home2TNSListener service
I have just completed the installation of the Oracle 12c database, following this tutorial. My OS is Windows 10. The installation has completed successfully, only green ticks.
The problem is that, ...
0
votes
1answer
50 views
How can I recover a dropped table? [duplicate]
I am using Oracle 12c Standard Edition.
I accidentally drop the table and try to recover it, but the table does not appear in Recyclebin.
I think the tablespace is due to SYSTEM.
Create table test(
...
0
votes
0answers
14 views
Restore dmp file over the network to oracle
I have a huge database and it is 1.13 TB size, what I wanted to do is to restore this database in the server but the location is from other server. Is this possible?
1
vote
1answer
18 views
Oracle database creation - recording response file option not available
I try to create database with dbca assistant (v 12c) and I would like to firstly use the graphical guide in order to save the response file for later.
I checked the advanced mode during the step 2, ...
-1
votes
0answers
14 views
Connect to Oracle DB on Windows Server 2012, running on VMWare, remotely [migrated]
I'm currently running Windows Server 2012 and Oracle Database 12c Enterprise in VMWare Player.
I need to connect to the aforementioned database externally, for example using my host OS to run scripts ...
0
votes
1answer
31 views
How to increase size of temp tablespace in Oracle 12C RAC with ASM?
I have an Oracle 12c RAC consisting of two nodes (OL6) and ASM. I use it for learning. For some reason I want to increase its temporary tablespace size. It's about 50M now. I've considered it using ...
0
votes
2answers
98 views
In Oracle 12c trying to create table with columns greater than 4000 [closed]
New to Oracle and SQL.
I have already followed normal procedure to allow for this size:
startup upgrade
alter system set MAX_STRING_SIZE ='EXTENDED' scope=spfile;
@%ORACLE_HOME%\RDBMS\ADMIN\utl32k....
0
votes
1answer
64 views
Oracle related to count(*) syntax alternate options [closed]
i am using a Stored Procedure which are using multiple count(*) in oracle which makes slowness of the server the same i have used in db2 using if exists() which works fine in db2 but the same syntax ...
2
votes
0answers
50 views
Incremental Schema Stats (With partitioned/Subpartition table) gathering is taking too much time in oracle version 12.2.0.1
When I am gathering schema stats with below options, it is taking too much time:
EXEC dbms_stats.gather_schema_stats (
ownname => 'SCHEMA',
granularity => 'AUTO',
CASCADE=> true,
...
1
vote
1answer
31 views
Data redaction with regex in Oracle
I would like to redact data with regex in oracle database. I know the procedure but I get unpredictable results.
I use the following script to apply redaction to a certain column with card numbers.
...
2
votes
1answer
59 views
configure new linked server from SQL Server 2016 to Oracle 12c
I'm having difficulty creating a Linked Server in SQL Server 2016 to talk to a remote Oracle database.
I have installed Oracle Database Client 12c. First I installed InstantClient and then later ...
0
votes
0answers
26 views
Unable to add columns in a particular table
I am trying to add 4 columns on a table using the below command
alter table table_name
add
(column_1 number(4),
column_2 varchar2(10),
column_4 number(4),
column_5 varchar2(10));
The table ...
-2
votes
1answer
34 views
Oracle Database 12c Standard, Enterprise Manager [closed]
Does the Oracle Database 12c Standard Edition have the Enterprise Manager?
0
votes
0answers
18 views
ORA-00600 When running ALTER modify PARTITION BY RANGE
I am running this on the table with 2 million records (2012378),
I get the below error.
when i do the same for less no.of rows (41000) there are no errors.
Error starting at line : 51 in command -
...
0
votes
0answers
18 views
How can I filter first then show values in BI?
As my title, I'm in this trouble. When I create a BI publisher report, it's show all of value, I just can filter after that.
Can someone tell me know how can I filter values before show it in BI ...
0
votes
2answers
36 views
creating view on “oracle view”
I am using oracle 12c. We have an oracle view ALL_SCHEUDLER_JOBS. As we will loosing the access to this table, I create a view on it as below :
the below function is placed inside a package called ...
0
votes
1answer
54 views
ORA-01017 when connecting remotely as sysdba
Good morning,
While installing a database for Oracle Entreprise Manager Cloud Control (OEMCC) I can't login as sysdba, neither localy using sqlplus SYS@MYSID as sysdba nor remotely using the OEMCC ...
0
votes
0answers
37 views
Cannot connect securely to enterprise manager
I'm working on my classwork and had a problem with connecting to the enterprise manager. After running the DBCA the address given to me was https://10.0.2.15:5500/em, pulling it up on IE I get cannot ...
1
vote
2answers
39 views
How to determine if it is necessary to increase the sga and the pga in Oracle database
How to determine if it is necessary to increase the sga and the pga in a database oracle 12c, is there any procedure, any specific view where can I be guided that indicates to me that it is necessary ...
0
votes
0answers
73 views
ora-49204: recursive dde invocation at phase i - after switchover to standby
I am currently testing a data guard environment. After a switchover, which is performed successfully, I can see the following error in the alert.log of the new stand:
ora-49204: recursive dde ...
1
vote
0answers
25 views
Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408
I am currently testing a data guard environment.
In the alert.log of the broker I always see the following message after a switchover:
2019-05-23 08:08:54.716 7fffffff 0 Operation ...
0
votes
1answer
32 views
How to determine/set the Java classpath for an Oracle DB?
l am trying to make use of some proprietary Oracle Java classes/methods using an Oracle provided virtual machine (E-Business Suite Vision, Oracle 12.2.28)
On my test server I define a function:
[...
0
votes
1answer
88 views
How to alter an existing partitioned table to add sub-partitions to it?
This forum has helped me earlier on many occasions and now I need someone to help me with this.
I am looking to convert a pre-existing partitioned (range) table - to sub-partitioned (composite range-...
2
votes
1answer
66 views
Missing right parenthesis after (or before) default 0, Oracle
I am trying to create a table with Oracle SQL where two columns of the table should have a default value and should not be NULL.
I am getting the error you can see below, but i am not able to ...
0
votes
0answers
33 views
ORA-01502 during insert
So I have a table with an index on a RAW datatype column. And then I have a procedure which disables all indexes on that table, truncates it, and then inserts data into it. After that it enables all ...
1
vote
0answers
75 views
ODBC Error for Oracle Client 12.2.0.1
I installed Oracle Client 12.2.0.1 (x32) on a Win7 x64 machine. When I tried to create an ODBC by invoking "C:\Windows\SysWOW64\odbcad32.exe" and picking the "Oracle Client" from the list and clicked ...
1
vote
1answer
21 views
PDB state in Oracle 12c RAC
Installed two node Oracle RAC. On node 1 opened pdb1 and shows open mode as read and write but on node 2 it's still in mounted state?.
On Node1
rlwrap sqlplus / as sysdba
SQL*Plus: ...
3
votes
0answers
126 views
Import Oracle unicode data with OLE DB Source and destination in SSIS 2015
My issue is identical to this post on mssqltips.com, however my issue is importing from Oracle, not Excel.
I get all the way to the bottom where I need to map the output columns from my data ...
0
votes
1answer
65 views
Oracle XE 12c won't configure - getting the “port 5,500 in use” error message
I have the infamous "port 5,500 in use" error message while trying to start/configure Oracle XE 12c.
I have searched for this problem and every solution I have found has been the same - make sure the ...
1
vote
1answer
74 views
Which Oracle datafiles grow in size?
I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to move datafiles that can grow to a separate mount point (setup as a vmdk on a HDD. more ...
1
vote
1answer
57 views
How to point tablespace in Oracle's pre-built Developer Day VM to another mount point
I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to load some data for development purposes. I am planning to create a new user and load ...
0
votes
1answer
38 views
data_precision and data_scale Missing from Oracle's all_tab_columns
I need to know the data_precision and data_scale values for the fields in a view in Oracle 12c. I am not the owner of the view and I do not have access to the underlying tables.
When I query ...
0
votes
1answer
68 views
How to rearrange columns in Oracle SQL Developer script output
maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet.
So I have created a table in Oracle and when running the SELECT ...
0
votes
0answers
14 views
How to find full siblings? I have been able to find the parents, but can't figure out how to join siblings based on having same parents
I have two tables (table/column names not my choice):
| Person | | Parent |
------------------------------ -----------------------
| ...
0
votes
0answers
32 views
mysql run out of memory during mview refresh
I want to create mview from mysql to Oracle using DBLink via odbc driver with Linux 64 bit os. but due to large number of Records around 2.5 cr records it raise the error
ERROR at line 1:
ORA-28500: ...
1
vote
0answers
14 views
Oracle Secure Backup (OSB) issue - “failed to read configuration data - Network is unreachable”
I am using Oracle 12.2.0.1 on Linux 6.8. I am using OSB to take a backup to tape.
After an unknown host name error in the backup log, I edited the /etc/hosts file and restarted the server.
After ...
0
votes
2answers
57 views
Fix Oracle Database chained rows
A Oracle 12c Database has a table with Chained rows:
select
owner c1,
table_name c2,
pct_free c3,
pct_used c4,
avg_row_len c5,
...
0
votes
0answers
27 views
Does “Inheritance” Make Sense with This Requirement?
I'm using Oracle 12c. Given an existing table (we call it TBL_M), and based on the criteria below, I was wondering if using inheritance makes sense to lay out the entities:
Information for one group ...
