Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
1answer
29 views

Oracle 11g - drop maxvalue partition, keep data

I have some tables with data like this: CREATE TABLE "PARTTEST4" ("year" number(4,0) NOT NULL ENABLE) PARTITION BY RANGE ("year") (PARTITION "P_OLD" VALUES LESS THAN (2010), PARTITION ...
0
votes
2answers
61 views

generate/analyze trace for error 1461

I am trying to generate a trace file when arise errors with code ORA-01461. I have executed the following statements: alter system set events '1461 trace name context forever, level 4'; from ...
2
votes
1answer
50 views

Oracle table and number of blocks

What is the easiest way of finding out the number of blocks a table (oracle) occupies and the number of extents?
2
votes
1answer
42 views

Tkprof in critical environments [closed]

Why tkprof utility is not adviced to be used in production setups? What concerns does it have?
1
vote
0answers
17 views

Oracle in hyper-convergence system

How does Oracle perform in hyperconvergence systems such as nutanix, simplivity? Oracle doesn't certify the underlying storage which nutanix or simplivity offers (file level storage) but in reality ...
2
votes
2answers
335 views

Oracle 9: Convert date from mm/dd/yyyy hh:mm:ss format to iso8601 formatted datetime [closed]

Note: I only have read access to this database. I need to convert an Oracle 9 date type from d/mm/yyyy hh:mm:ss format to the iso8601 standard. Like the example below: 4/22/2015 12:02:56 AM => ...
0
votes
3answers
45 views

SQL developer licensing [closed]

SQL developer is free or do you require license for oracle database to use the sql or pl/sql developer? Also, Is it secure to connect to the oracle database since it connects to the db over a remote ...
0
votes
1answer
28 views

RMAN catalog database

I'm about to create a RMAN catalog database for my setup, what are the general precautions or major pre-requisites as in DB parameters, compatibility,etc that I should take care while creating the ...
0
votes
1answer
17 views

Missing view privileges in USER_TAB_PRIVS

I can't figure out how to view the grant privileges I've given users on views -- FIRSTUSER@SQL> create view remotetabletest 2 as select * from A_TABLE where PKEY = '123456' 3 / ...
0
votes
1answer
28 views

database not opening

While altering a DB to open getting the below error. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], ...
2
votes
1answer
90 views

why update a table take so long on oracle

I have a table A which has 3800+ rows, another table B with 300+ rows. when I execute a update like this: update A set some_colum = '2' where another_column not in (select id from B) it takes 33 ...
3
votes
1answer
101 views

DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE [closed]

I am having an issue where I need to make 1 parameter have multiple options, almost like a case statement or decode function. Here is a snippit of the query below, We were using 2 parameters so he can ...
0
votes
1answer
37 views

ASM 12c compatibility

Can I use ASM 12c version with database 11g? The following link https://community.oracle.com/thread/3674266?start=0&tstart=0 and MOS Doc ID 337737.1 says I cannot use 12c version of ASM with a ...
1
vote
1answer
61 views

Oracle: Creating Case Insensitive Database with NLS_COMP and NLS_SORT

I try to create an Oracle 12c Database (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) which ist case insensitive. My first try is just a try to test my aims: select ...
0
votes
0answers
50 views

Set session query timeout

When I develop complex queries and I make a mistake (e.g. a wrong join that will make the query run for hours or days) Oracle becomes unusable (you can't even start a local SYS session from SQL*Plus). ...
1
vote
0answers
20 views

Return results of DBMS_SQL.DESCRIBE_COLUMNS in Oracle 11

Database: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 I would like to create a script that will return the results of the DBMS_SQL.DESCRIBE_COLUMNS function to my c# application. Here ...
0
votes
1answer
29 views

Restoring oracle database

I come from SQL Server and I need to restore a oracle .bkp file in my database. Im using RMAN and I have the .bkp file in: F:\Oracle Back Ups\Back.bkp´ The command that I use in RMAN is: RMAN> ...
2
votes
2answers
50 views

Oracle Autotrace vs Explain

My team uses Oracle 11 and SQL Developer. I've been relying heavily on explain plans lately to try and determine the most efficient way to solve various problems. Recently, a coworker pointed out ...
0
votes
3answers
33 views

Where oracle saves lobs?

I am new to oracle, so I don't know how lobs are saved, like in postgresql all lobs are saved in a table ( pg_largeobject) and all tables with lobs column have an id for this "main table". So does ...
0
votes
2answers
41 views

Determine if a resultset exists quickly

I want to determine if a resultset exists very quickly. At the moment, I'm doing a count - this is taking roughly 55ms, which is unfeasable.The table has ~100k records - I don't care if it has 2, 5, ...
0
votes
1answer
42 views

Installing OE (Order Entry) schema in Oracle Express

I'd like to know if it's possible to install OE (Order Entry) schema in Oracle Express. If so, how can I do that?
1
vote
0answers
24 views

Estimating compression ratio for SecureFile LOBs?

We made a migration from Oracle 10 to 11.2. Our lob objects are currently stored in the original LOB storage architecture. But 11g introduced the SecureFile storage architecture and we want to use ...
0
votes
1answer
23 views

Joining Oracle tables with 2 strings to be oa a single row (in a distinct SQL filter)

I have an Oracle Database and if I fire that SQL: SELECT distinct RAP.ID_PL, SES_RAP.AN, RAP.DENUMIRE, A3T2.COD_DESEU, A3T2.TIP_AMB, A3T2.COD_REC, A3T2.COD_VAL FROM chest cht INNER JOIN ...
-1
votes
1answer
34 views

How to resolve parameter file error

I log on to my database but giving me this error message ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ...
0
votes
0answers
63 views

ORA-00911: invalid character error in insert statement

I created a table called TROUBLE in Oracle Database 10g Express Edition by this command create table TROUBLE ( City VARCHAR2(13) NOT NULL, SampleDate DATE NOT NULL, Noon NUMBER(3,1), Midnight ...
0
votes
0answers
16 views

Recreating an artificial Oracle Flashback Archive

I have an databases where changes to data were tracked by adding auditing timestamp columns to the end of each row. I want to migrate to Oracle's Total recall or Flashback archive so I need to trick ...
0
votes
1answer
55 views

SQL Spool FILE SQLPLUS BATCH FILE

*/ SET colsep ';' SET TERMOUT OFF SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 800 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF SET NUMW 20 column timecol new_value timestamp column ...
0
votes
1answer
51 views

How do I prevent an ORA-08102 error

I am getting an ORA error (08102 - Index Key Not Found) with several customers, and I have been unable to reproduce or explain it. They have all been on the same index on the same table. This error ...
0
votes
0answers
54 views

Oracle Performance on 2 servers

I have the same database on two different servers(production and test) with major differences in query time as follows: Query1: SELECT distinct dms_get_FAST_serverpath(d.id) full_name FROM ...
0
votes
1answer
45 views

One time data conversion in Oracle tables with excel data

First of all I have very basic knowledge in back end I need to do an one time data conversion in an Oracle table with a excel sheet data. Excel sheet have data in below format OldData NewData ...
1
vote
1answer
39 views

VMware and Oracle

VMware is supported by Oracle but not certified. That I get, but why does it matter anyway? Because support is the only thing matters and how will Oracle know that I'm on VMware? Either way, they will ...
1
vote
1answer
27 views

ASM and IPv6 Compatibility

In the whitepaper mentioned below, Under 'Limitations' it says ASM and fan based notifications are not supported by IPv6 in Oracle. I'm just curious what ASM has to do with ipv4 or ipv6 or ipv4? ASM ...
1
vote
1answer
108 views

Is it ok to create additional column for helping other column to be a PK?

Let's say a Person can have more than one nickname. He(she) must enter his(her) nicknames alongside with other details: Here is the table columns: User_Id, Nickame, Age Of course, for now there ...
1
vote
0answers
26 views

DBMS_RESOURCE_MANAGER limit IOPS or MBPS

Does DBMS_RESOURCE_MANAGER have limit io bandwidth? I want reporting group to be limited to some mbps. During peak hours our database disks are 100% loaded, because reporting groups are selecting ...
1
vote
1answer
60 views

Oracle DataGuard: Find primary from standby DB

I have SYS access to a data guard standby DB, but i need to find the primary one. I was searching in Oracle Docs but couldn't find anything that could help.
1
vote
1answer
103 views

Oracle 12c Client to 10g Server (OPENQUERY)

Scenario: We currently have a SQL 2008 R2 server (with Oracle 10g Client) using OPENQUERY to return data from an Oracle 10g database. Problem: We would like to upgrade to SQL Server 2014 SP1 (with ...
0
votes
1answer
49 views

How to track changes to a record that spans multipe tables

I have the challenge to design a new database using a RDBMS, Oracle, to be precise. In this database there will be one specific record/document which may span multiple tables. With as little ...
1
vote
1answer
25 views

oracle database filter with full outer join and coalesce intersect

in a Oracle Database if I "shoot" SELECT RAP.IDPL, C41.TIP_COD_DESEU AS CD41,C41.STOC_VAL AS CANT41, C42.TIP_COD_DESEU AS CD42,C42.STOC_VAL AS CANT42, C43.TIP_COD_DESEU AS ...
0
votes
1answer
66 views

Select all from table using procedure oracle

I am trying to execute the select command in a procedure.Initially i retrived all of the columns of the table in the procedure using cursor. The real problem comes when I am trying to access the ...
0
votes
1answer
26 views

Verbose Oracle RDBMS error log output examples?

I'm working on a project and my boss has asked that I find an actual example of the "verbose" output of an Oracle RDBMS query error. We want to see what they actually look like. I know that there are, ...
1
vote
1answer
33 views

Grant execute on specific type in Oracle

I have created a package and defined a type for collections as follows: create or replace package <schema>.<package> as ------------------------------------- type <type> is ...
0
votes
0answers
55 views

Buffer too small for CLOB to CHAR or BLOB to RAW

I am trying to select a clob from database to put it in a jasper report. The query is: <queryString language="SQL"> <![CDATA[ select to_char(PLAN_DESCRIPTION) as PLAN_DESCRIPTION ...
0
votes
0answers
12 views

Oracle: Is it safe to temporarily lock all users not belonging to SYS_GROUP?

I know you can startup an instance in restricted mode, but I need at least one other user account besides SYS and SYSTEM to have remote access to the instance, because I need to connect with that user ...
2
votes
1answer
47 views

Oracle's (+) notation within function

If we use (+) notation we can have outer join. For example: select * from tab_a, tab_b where tab_a.num = tab_b.num(+) Is outer join. If we use function around columns, for example: select * from ...
0
votes
1answer
58 views

joining tables with full outer join and… COALESCE?

I have a few tables in an Oracle database linked by id - fk_id, if I do: select RAP.ID_PCT_LUCRU,SES_RAP.AN, TIS.CANT as c1,'R12' as modc1, TIT.CANT as c2,'D13' as modc2, ...
0
votes
0answers
30 views

Cann't connect from another server to Oracle

I can connect locally like normal : sqlplus sys as sysdba I can also connect sqlplus sys/pass@hostname:1521/servicename as sysdba the service I get from when I do lsrnctl status but when I try ...
0
votes
1answer
79 views

Unable to access OEM 11g grid control after upgrading to Firefox ver 39.0

Previously, I have encountered the similar issue after upgrading Firefox to version 37.0.1. Here's the link of the question posted: Unable to access OEM 11g after upgrading to Firefox ver 37.0.1 I ...
1
vote
3answers
165 views

How can I join two tables of an Oracle database containing all rows (not the intersection)

I have a Oracle database with a table t1 with: cod | text1 ----------- 1 | aaa 2 | bbb 3 | ccc table t2 with: cod | text2 ----------- 2 | abc 4 | mlc 5 | asc how can I optain ...
1
vote
1answer
59 views

Oracle Ref Partitioning: Deadlock due to child table row migration

My ordering application uses Oracle 11g Database. This DB has a primary table ORDERS and multiple child tables like ORDER_DETAILS, PLAN etc. ORDERS table is LIST partitioned on STATUS column and all ...
2
votes
1answer
44 views

Split field values using specific character

Please help me with this. It is possible to split field values using a specific character? Here is my sample table value 10uF 2K 1.0uF 200UF I want it to split by this: value ...