The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...

learn more… | top users | synonyms

1
vote
0answers
15 views

Oracle Data Pump Import with running advanced replication

In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the ...
0
votes
0answers
3 views

issue granting privileges in a hierarchical user configuration

as SYS: grant execute on sys.dbms_reputil to system with grant option; grant select any dictionary to system; grant dba to system; -> ok. Then, as SYSTEM: GRANT EXECUTE ON sys.dbms_reputil TO ...
0
votes
0answers
9 views

Connecting SSIS to Oracle using Attunity Drivers

I am trying to recreate the steps I took to allow me to connect to 64bit Oracle installation from SSIS using the Microsoft Connectors 3.0 for Oracle and Teradata (Attunity driver). MY issue is I ...
1
vote
1answer
36 views

Check if an index exists by comparing columns

We are currently using ALL_IND_COLUMNS to check if an index exists by its name or the columns it is using. The problem is that we can only check if the index exists with columns in a specific order. ...
-1
votes
0answers
14 views

What means Buffer Pool/Hit Ratio(%) in Oracle Counter?

I found the buffer pool hit ratio percentage at Oracle database metrics / Oracle Counter. I want to know about this buffer pool detail. Kindly answer to me.
2
votes
1answer
28 views

Possible RMAN orphan files in backup directory

I am trying to scrape together some space in my Oracle 11g backup directory in AIX. I have deleted obsolete files using RMAN's "DELETE OBSOLETE" command, but I see many (just under 200) files dated ...
1
vote
2answers
44 views

Can install a test machine with Oracle 11G R2, not express edition, on a VirtualBox?

Im starting like a Oracle DBA, and I want play with the database and your administration task in a test enviroment. I have a macbook pro i5, and had thought install on it oracle under virtual box ...
0
votes
1answer
19 views

XMLDB - Nodes to Rows

I have an application that stores XML as XMLType in a table. This is the first time I'm using XMLDB and XMLType features, and was wondering if I could use the results from an XQuery FLWOR expression ...
0
votes
1answer
20 views

11gR2 didn't ask me to set username or any password

I have installed Oracle 11gR2 (latest version 11.2.0.1.0) on my system. During the installation it didn't ask me to set username or any password. I'm unable to start sql plus because i don't have the ...
0
votes
0answers
26 views

ORA-12578: TNS:wallet open failed

I am calling an oracle wallet through "autosys" job. When i am calling through clicking on my myreport.bat file its working fine and connecting to DataBase but when i am calling that myreport.bat ...
-3
votes
1answer
35 views

Database fragmentation

How can we find the list of fragmented objects in the database. And how much space we can reclaim by defragmenting those objects.
0
votes
0answers
12 views

Oracle 11G DataGuard: infrequent change of Log Archive Destination Role

currently we have the weired behavior of our DataGuard-Setup, in which the primary database somtetimes changes the role of "log_archive_dest_1" from "valid_for=(ALL_LOGFILES,ALL_ROLES)" to ...
1
vote
0answers
17 views

Where to put standby control file in Physical standby database?

I am creating a physical standby database for which I am creating a standby control file using command = ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl'; but It creates only one ...
0
votes
0answers
17 views

Increase in temporary tablespace while import

When i am importing some tables in my database, the temporary tablespace is getting full. This never happened earlier for other tables. Please help me know why this is happening and any solution for ...
0
votes
1answer
59 views

Oracle Database Client 11g R2 Installation Types, which components?

I need to know which component is under each installation type! Instant Client Administrator Runtime Custom (No need as it shows all the components) ALSO? does it includes ODP.NET? is it the ...
0
votes
0answers
33 views

intermittent TNS-12533: TNS:illegal ADDRESS parameters

I am running a windows XP (SP3) VM in virtualbox, on which I host Oracle XE. It has been running fine like this for a couple of years, but recently I am seeing some strange problems. My client ...
0
votes
2answers
65 views

Slow import for users .DMP files in Oracle 11G

After upgrading my DBMS Oracle 10g to 11g, when it will import user files, they are slower than the old version. A .DMP file in Oracle 10g with the size of 20GB takes almost 1 hour to import, but ...
1
vote
3answers
59 views

Oracle static lookup table

What is the best approach (or what options am I not aware of) to creating a static table or view where the data rarely, if ever, changes? An example use-case is a list of US states, where my ...
0
votes
0answers
21 views

ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)

I made a query using Oracle DB, and the error contains the error code, followed by several thousand ^@ symbols. This would look like: Error at query 298 ORA-00942: table or view does not exist ...
0
votes
0answers
34 views

Oracle SQL Loader - BULK UPDATES

Can SQL loader be used to do bulk updates? I have a table that holds customer information. The table has a primary key and it has 5 columns pertaining to the customer. Now we created three more new ...
0
votes
1answer
44 views

Problem with procedure performance

I'm having problem in Oracle, where I have two procedures that are executed one after the other. Where the first procedure, I have a cursor that does insert into a table. This insert has about 30 ...
1
vote
2answers
66 views

Using transactions in sqlplus

I'm coming to oracle from postgresql. In postgresql, I can use the command-line tool, psql, to execute a delete or update in a transaction: dbpool.production=> begin; BEGIN ...
1
vote
0answers
28 views

Replacement for Pragma Restrict references

Up to Oracle 11.1 you could mark a package as only reading from the database by adding PRAGMA RESTRICT_REFERENCES( DEFAULT, WNDS); This has now been deprecated. I would like to enforce read only on ...
1
vote
2answers
47 views

Unit of COST in an Oracle execution plan

Is there a unit for cost in an Oracle execution plan? I mean if the cost of an operation is 50 then can I map this number to CPU cycles or utilisation percentage? What does this number stand for? Is ...
0
votes
1answer
67 views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
0
votes
1answer
49 views

Results of SAMPLE clause using a DBlink between 2 Oracle databases not randomised

I'm using the SAMPLE clause to retrieve random rows from a table. It works fine except when the table is from another database. I'm using a database link between 2 Oracle 11g databases (11.2). This ...
0
votes
0answers
52 views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
1
vote
2answers
82 views

Permissions needed to call DBMS_DATAPUMP from within package

I am attempting to write a procedure (within a package) that calls DBMS_DATAPUMP to copy an existing schema into a different schema. The code works when executed from an anonymous block, but from a ...
0
votes
2answers
51 views

Oracle: How to split records across days

I have data with two timestamp columns startdate and enddate. The data is produced continuously everyday and some records are such that the startdate is one day and the enddate is the nextday as it ...
0
votes
1answer
47 views

Oracle 11g r2: Cannot create partition on timestamp field

I have data with a timestamp field of the form '2014-01-01 00:00:00.99' in one of the columns. I want to create a new partition for the table every month. For this I did something like this. CREATE ...
1
vote
0answers
37 views

reduce the cost of maintaining a materialized view? [closed]

how to reduce the cost of maintenance a materialized views? and when I selected between maintaining by recompiling and maintaining by refresh?
0
votes
1answer
509 views

ORA-01034: ORACLE not available in oracle 11g

I installed oracle 11g on ubuntu 14.04 and i started lister and the message is as below. LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-OCT-2014 14:20:02 Copyright (c) 1991, 2011, Oracle. ...
0
votes
0answers
32 views

Did another application use an Oracle block?

One of our production Oracle databases got hit with a corrupt block. Looking at the hex dump, the first part of the block seems to contain Microsoft Windows Event Log and Windows Registry information. ...
0
votes
1answer
28 views

Oracle 11g user created with Create session but able to update the table?

I created a readonly user with only permission granted was create session and read only privilege, using the link: http://stackoverflow.com/questions/7502438/oracle-how-to-create-a-readonly-user Now ...
1
vote
1answer
22 views

Does trigger “see” all changes done in the transaction it was fired from?

Let me elaborate on the title. Suppose we have two tables, t1 and t2. t2 has a trigger t2_trgon it. Same transaction inserts/updates data in t1, then does insert/update in t2. t2_trg is fired and ...
3
votes
1answer
37 views

What is the use of Archivelogs?

Hi I am new to Oracle Database . Using Oracle 11g R2 I want to know the purpose of archive logs created at archive log destination, how they are helpful in database backup. Suppose I am having ...
1
vote
1answer
31 views

How do you capture the output message from a successful MERGE statement when using it in a procedure?

Sorry if this sounds like a rather simple question.. When using the console, normally the statement outputs something similar to X records merged How do I capture this output into an out variable ...
0
votes
0answers
28 views

Oracle Support Identifiers?

Right now i am not working in any company.How to get oracle Support Identifiers?
0
votes
0answers
279 views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at the time of switchover using data guard broker

I have a oracle data guard setup with nodes - one as primary and other as physical standby. I also, have configured the data guard broker on it. The problem is when I tried to switch over , I just ...
0
votes
0answers
52 views

how to make oracle db instance and em dbconsole running manually/?

I installed oracle11gr2 (x64) on vmware oracle linux (x64). When I finished installing, I'm sure that I executed the init scripts as root: /app/oraInventory/orainstRoot.sh ...
0
votes
1answer
63 views

ORA-12541: TNS: No listener after adding new IPs to machine

We are receiving the ORA-12541 error since we added 2 new IP addresses to the machine. This may or may not be related to the problem at hand, but this is the latest severe change that was made, before ...
1
vote
1answer
1k views

Connected to an idle instance; trouble creating DB

I tried to connect to my database and got Connected to an idle instance: C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 22 19:07:34 2014 Copyright (c) 1982, 2010, ...
0
votes
2answers
55 views

composite index vs normal index

I need to index some tables and for that i found that there are different kinds of indexing. I am kind of clueless on their proper place of usage. Should i create index on all the fields that want ...
1
vote
0answers
47 views

Adding custom meta data to a table in oracle

I'd like to know if there's a possibility to add some custom metadata to a oracle database table. The problem at hand is the following: I'm importing a table from another DB. It might happen that I ...
0
votes
1answer
180 views

how can I insert a long string into a blob using an insert statement?

ORA-06502: PL/SQL: numeric or value error: raw variable length too long ORA-06512: at "SYS.UTL_RAW", line 224 the datatype is BLOB here's my insert statement insert into system_value (type, ...
1
vote
1answer
33 views

Run stored procedures from specific package/with specific tag at lower priority

I have this requirement to run "Maintainance Jobs" for a web application. These jobs will just call a stored procedure from a set of specific packages. Running these jobs can consume quite a bit of ...
2
votes
3answers
160 views

Storing file into oracle db

I'm developing a java web-app for the acquisition of contracts, and that have to receive some file from an external system. For each new contract i recieve some information about the new customer and ...
0
votes
0answers
50 views

Selectively load data using Oracle 11g r2 External Table Preprocessor

I am using the Preprocessor feature in Oracle 11g r2 to load several data files in a table. However, the raw files seem to have certain rows that shouldn't be imported with the rest. For example: ...
0
votes
0answers
51 views

How to import data into Oracle 11g r2 daily

I need to batch load several log data files (comma delimited but they don't have a .csv extension in the file name) once each day into an Oracle database. I'm sure this is a very common use case, but ...
0
votes
1answer
68 views

How to know the timestamp of when the query was executed?

1)How to find when a query was executed.I ran a query couple of days ago,im not sure about the exact time, I want to know at what date and time the query was executed. Is it possible to get that ...