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
2answers
46 views

LOB indexes corruption in Oracle

Why is it not possible to rebuild corrupt LOB indexes? So if my LOB index is corrupted, how to recover it?
0
votes
1answer
42 views

what exactly does an RMAN backup do?

I have a database with multiple schemas and data in the tables. I create an rman backup and backup archivelogs. I drop 90% of the tables. I do rman restore and recovery with controfile from ...
0
votes
1answer
41 views

Oracle - ORA-01654: unable to extend index in tablespace

I referred to the below related question, but it was not helpful in my case: ORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace> I ...
0
votes
0answers
11 views

Monitoring external Oracle db, creating changes locally to SQL Server

I have a local mirror database of an external database that our vendor provides us read access to. Occasionally they add columns and/or table to their database. The addition of columns used to play ...
1
vote
1answer
69 views

Is it possible to install oracle 12c without X window system

I am looking at installing Oracle 12c on a new server but the system admins are insisting that all new Linux servers don't have a GUI installed and that any administrative tasks are performed from a ...
0
votes
1answer
16 views

Oracle instant client memory footprint

In the link mentioned here --> http://www.oracle.com/technetwork/database/features/oci/ic-faq-094177.html it says there is increased virtual memory footprint when running my applications in ...
0
votes
0answers
17 views

Error while creating encryption wallet in Oracle

I need to encrypt tablespaces in my Oracle DB. Following the instructions I edited sqlnet.ora file by adding ENCRYPTION_WALLET_LOCATION. Full content of file listed below: NAMES.DIRECTORY_PATH= ...
2
votes
1answer
107 views

Oracle instant client

What is the difference between instant client and the original Oracle client? The Oracle client is almost 800MB and the instant client is not so much. I need to install oracle client, ODBC drivers and ...
2
votes
0answers
48 views

How do I convert a datetime column from SQL Server 2014 to Oracle 11g using ogr2ogr? [closed]

I have a table in SQL Server 2014 with two columns, one called username with data type nvarchar(50) and another datetime column called currenttime. I've got just test data in there - two rows: ...
2
votes
1answer
74 views

Oracle Performance - Varchar2 (x char) x Varchar2 (x byte)

I know the definition diference between Varchar2 (x char) x Varchar2 (x byte). varchar2(20 char) means you can store 20 characters -- whereas varchar2(20) means you can store 20 bytes. What ...
1
vote
0answers
23 views

How to best distinguish between “types” of missing data?

I am working on large tables (> 100 fields each) currently organized in flat-files in csv-format. An Oracle DB is to be created to store all the data and allow for several more or less intricate ...
0
votes
1answer
21 views

Oracle ODBC Driver, Tables and Columns Remarks

I'm using the Oracle ODBC Driver 11.2 to access an 11.2 Oracle Database. It seems that the driver does not return tables nor columns remarks (comments) when calling the SQLTables() or SQLColumns ODBC ...
0
votes
1answer
47 views

What is the best way to take backup for Remote DB Server

I am building a software, which will supports multiple database like MySQL, Oracle and PostgreSQL. These databases are installed on remote machines. i wanted to use java technology in a non-database ...
1
vote
1answer
930 views

SSIS Job “Argument ”ORARA********.xxxxxxx.COM“ for option ”connection“ is not valid. The command line parameters are invalid. The step failed. ” error

My SSIS package is running fine in BIDS but when I tried to schedule the job it's showing: Argument "ORARACOCCUAT1.xxxxxxx.COM" for option "connection" is not valid. The command line parameters ...
0
votes
1answer
30 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
62 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
44 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
403 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
49 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
20 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
96 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
102 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
38 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
68 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
51 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
22 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
30 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
52 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
34 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
24 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
36 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
75 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
60 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
57 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
48 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
28 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
110 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
27 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
61 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
109 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 ...