Questions tagged [oracle-12c]

Oracle Database 12c. Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
1
vote
1answer
42 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, ...
2
votes
1answer
4k 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 ...
1
vote
2answers
898 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
69 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
190 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
180 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
3answers
5k 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 ...
1
vote
0answers
53 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
126 views

Oracle Database 12c Standard, Enterprise Manager [closed]

Does the Oracle Database 12c Standard Edition have the Enterprise Manager?
0
votes
0answers
21 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
54 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
4k 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
162 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
2k 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
1answer
832 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
70 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
411 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
900 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
341 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
1answer
2k 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 ...
0
votes
1answer
99 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
420 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
371 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
222 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 ...
2
votes
1answer
80 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
323 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
705 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
44 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
44 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
417 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
28 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 ...
0
votes
0answers
156 views

Transactional replication from Oracle PL/SQL to MS SQL Server broke from the data in a Date column but previous records with same date are ok?

I have a heterogenous transactional replication subscription setup between PL/SQL (12C 12.1.0.1.0) and SQL Server (2008 R2), where the Oracle PL/SQL server is the publisher and the MS SQL server is ...
2
votes
1answer
477 views

Incremental level 1 RMAN not being deleted

I am doing a level 0 (full) incremental backup on Sundays, with the following global script: printing stored global script: weekly_backup { allocate channel DISK1 device type disk format '&...
0
votes
1answer
32 views

What is the largest whole number in Oracle SQL table that can be stored without rounding errors?

I want to "concatenate" numbers to create temporary ids for tuples of objects, but I am worrying about precission loss and rounding errors. Query below suggests that there are no problems with ...
2
votes
1answer
262 views

Non-CDB database vs Single tenant CDB

I am looking at the prospect of upgrading from oracle 11G to 12C, and I am looking at the cdb vs non-cdb models, and I am having a hard time seeing the benefit of using CDB, without multitenant ...
0
votes
1answer
292 views

use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)

this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1....
0
votes
1answer
527 views

don't the users SYS and SYSTEM share the table dba_users?

While being logged in as SYS, I created a new user. I ran select username from dba_users order by username; and I was able to see the user that i just created; Then, I logged as SYSTEM, I ran the ...
0
votes
2answers
3k views

how to stop OracleRemExecServiceV2 from cmd?

I have Oracle 12c running on Windows 7. When I look at the Oracle's specific services (Control Panel\System and Security\Administrative Tools\Services), I have the following 6 services: So far, ...
0
votes
2answers
532 views

Stop long running scheduled job

I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
0
votes
2answers
49 views

does sequence of columns in where condition matters the sequence of composite key? in Oracle Database

here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance. update temp_fd_dtl_svj a set ...
2
votes
1answer
1k views

ORA-48108 / ORA-48140 / ORA-48187 - diagnostic_dest value error(s) - init files / control files

This is all testing / training - none of this is related to a production env Using ORACLE DB 12c + UNIX/LINUX 64-bit on an VM. . Hi Guys! I am running in the below error(s) and seem unable to ...
0
votes
2answers
202 views

Welcome message for oracle schema

I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only
0
votes
1answer
433 views

ORA-14224 Deferred Segment Creation is not supported for this schema

I'm trying to use deferred segment creation and not having any success. My deferred_segment_creation parameter is set to TRUE, but new tables do not defer. I've also tried explicitly stating SEGMENT ...
1
vote
1answer
81 views

Does tables under schema uses multiple tablespaces other than default tablespace

I have schema A in a database and have assigned the default tablespace as myspace. There are 20 tables that reside under this single schema and all the tables are using different tablespaces. My ...
0
votes
1answer
98 views

Consume data from other database motor from stored procedure in Oracle 12c

I have a project in which you must develop services in Oracle OSB which will call a procedure stored in Oracle 12c. The issue is that I also need data from an Informix database to build those services....
0
votes
0answers
108 views

Restrict Oracle database schema to login using Toad/PLSQL [duplicate]

I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
2
votes
2answers
419 views

Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?

Well, I'm the SQL Server DBA here, and we have a Oracle Senior Dba that manages Oracle Databases and users. I'm curious about how he is handling these servers/users. What is the best approach, when ...
0
votes
1answer
35 views

Access tables from multiple schemas

I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible to remove schema names from the queries and oracle to identify the tables based on roles ...
0
votes
0answers
90 views

Get the current upper limit value for nvarchar2 in an Oracle 12c db

Starting from 12c, Oracle Database provides a way to control the max byte-size of a NVARCHAR2 column. To use up to 32767 bytes instead of 4000, one has to set the parameter max_string_size to EXTENDED....
2
votes
1answer
712 views

START WITH and CONNECT BY condition in Oracle SQL

I have a question on the START WITH and CONNECT BY condition (in Oracle 12c): This is my Oracle SQL: SELECT employee_id, lpad(' ', level*2-1,' ') || last_name, manager_id, level, ...

1
3 4
5
6 7
18