Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.

learn more… | top users | synonyms

0
votes
0answers
12 views

column values combnation

I have chains of nodes like A -> B -> C -> F D -> E and store them in an Oracle table pair with 2 columns left_node and right_node left_node right_node A B B C ...
0
votes
1answer
7 views

Do I need to create tablepspace and also add all datafiles before import schema using datapump

Do I need to create tablespace and also add all data files before import schema using data pump or impdp add all data files itself first and then unload data into it..?
1
vote
0answers
7 views

Oracle Application Server Integration With APEX

This might not be directly related to DBA, if so kindly advise. I need to integrated some reports created via Oracle Reports Builder with APEX. Reports are in RDF format. Which version of Oracle ...
1
vote
0answers
11 views

Script to find unused indexes over a period of time doesn't work in Oracle 11g

The statspack_unused_indexes.sql script described in this page would be incredibly useful to me, but it has been coded for an earlier version of Oracle. When I try to run it on 11g, I get the ...
0
votes
0answers
17 views

Recover Oracle database with damaged system datafile

I'm working with Oracle version 11. My system01.dbf is corrupted and there is no backup. The database was in archive log mode and logs exists. Is there any way to recover data and import to a new ...
0
votes
1answer
15 views

How can I get a single row on a inner join not to double my sum

I have two tables (DEP_DEZ & CAR_EXP): ID FK_ID_CHESTIONAR TOTAL_E TOTAL_F TOTAL_STOC 261 644 87 152 48 ID MASA_TOTALA FK_ID_CHESTIONAR 405 20 644 406 45 ...
0
votes
1answer
40 views

Oracle DB: Can one db file be shared between table space

Can one db file be shared between table space? I am deleting temp table space as below, Get all the files in table space: SELECT FILE_NAME FROM DBA_TEMP_FILES WHERE TABLESPACE_NAME = ...
0
votes
2answers
36 views

Database link from Local Oracle 11g to Oracle Database Cloud Service 11g

We are using Oracle database from Oracle Database Cloud Service, now we are not able to connect Cloud db from Local oracle db. Somehow we created link using below commnd, CREATE DATABASE LINK link_1 ...
0
votes
1answer
14 views

Oracle 11g PGA advice view is empty when it shouldn't

I have the following situation in an Oracle 11g server (it's part of a RAC). PGA_AGGREGATE_TARGET is set, STATISTICS_LEVEL is TYPICAL, and yet V$PGA_TARGET_ADVICE shows up empty. Why does this happen? ...
0
votes
1answer
29 views

Moving data from one DB to another where the table/column structure is identical

Question about the import / export process. I know is SQL Developer I can export all the columns from a table and import into the same table on another server. My question is - what happens with the ...
0
votes
1answer
24 views

How to get a list of stored procedure along with their execution count in oracle 12c?

Hi I am new to Oracle 12c, though I was working on SQL Server for a long time. Is there a way to get a list of stored procedures with their execution count in oracle 12c. We can get it using DMV in ...
1
vote
3answers
60 views

Getting results without using IN

Oracle has a limit on the arguments in the IN statement of 1000, I believe, is there a way around this? If I had a statement similar to this (with 1000 ids or more): SELECT COUNT(*) FROM "VERSION" ...
0
votes
0answers
23 views

Case statement in a where clause in Oracle

I am writing a report for a customer using SQL. The end result of this report is to show a group of people with an expired certification or expiring certification. The report has a ...
1
vote
2answers
31 views

Tables Visible to a Specific User?

Is there a way to get a list of tables and views that a specific user can see, without logging in as that user? Initially, I tried something like select distinct p.table_name as value from ...
1
vote
0answers
39 views

Oracle tuning strategy for columns with long tails

We have an Oracle 11g database, where the two biggest tables are Customer and Order. The order profile of our customers has a long tail: we have millions of customers, with most only having a small ...
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 ...
0
votes
0answers
9 views

ALTER SESSION from a Control File

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by ...
0
votes
0answers
27 views

Connecting to oracle 11g through maestro gives initialization error

I'm very new to oracle DB. When trying to connect to oracle through maestro, this error comes up: Initialization error SQL*Net not properly installed OracleHomeKey OracleHomeDir Dont have any ...
1
vote
2answers
188 views

Is index performance on a TIMESTAMP(6) column impacted when converting it to a number

If I have an index on a TIMESTAMP(6) column, am I forced to use this column as a TIMESTAMP(6) to get the benefits of the index? Can I convert this column to a number with second precision ...
1
vote
1answer
117 views

How to create an Oracle Database Link when the password has special characters

I'm trying to create a DBLink. SQL Developer is the client I'm using. The password to my remote user has *'s in it. I'm having trouble figuring this out. This syntax isn't working: CREATE DATABASE ...
-2
votes
1answer
53 views

Moving from Oracle 11.2.0.1 to 11.2.0.3

We are going to upgrade our database soon from Oracle 11.2.0.1 to 11.2.0.3 We have our customer relation application that runs on the Oracle background. Both Oracle and the company that designed the ...
1
vote
1answer
39 views

Can we reuse a .dmp file(expdp) to perform import using data pump utility

I'm an accidental DBA. We use Oracle 11g database. I had to do a database refresh in the test environment. I created a .dmp file using expdp command and performed an import using impdp command a week ...
1
vote
1answer
22 views

Union of data from all tables with name containing a substring

I have 500+ tables all containing a column called COLUMNDATA. The table names are like: TABLE_FIRST, TABLE_SECOND, ... ,TABLE_FIVE_HUNDREDTH. What I am trying to get is a column containing all the ...
0
votes
0answers
23 views

SQL Server Replication: Central Subscriber : Loading data in the same table

I have configured a Transactional Replication from Oracle (11g) to SQL Server 2014. I have many clients with the same database and we want to have a Multi-Publisher and only one Subscriber. The ...
0
votes
1answer
47 views

Duration of adding versus dropping a column

I have a table containing more than 50 million rows. When I add a column: ALTER TABLE my_table ADD my_column NUMBER; It's very fast. Just after adding the column, I drop it. ALTER TABLE my_table ...
1
vote
1answer
24 views

Matching a column from a table to another table

I have 2 tables in a Oracle database and if I do: SELECT ID,ID_EXTERN_FOR_JOB FROM SOL_PUBLIC.SOL_SUBSOL_CHESTIONARE@RACDB WHERE ID=1207; I get: ID ID_EXTERN_FOR_JOB 1207 -1 On the other ...
0
votes
1answer
64 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
1
vote
1answer
59 views

Oracle: Recover source code/table structures from “utterly wiped out” development database

Given an Oracle 11.1 database used for development, running in NOARCHIVELOG mode, where all datafiles (including undo) have been wiped out; and only SYSTEM and SYSAUX datafiles and control file remain ...
0
votes
0answers
114 views

Use of temporary table variable inside a stored procedure

I am new to oracle, I was trying to create a procedure which consist of temporary table inside. I have tried this code below and getting an error in the declaration of temporary variable. DECLARE ...
0
votes
1answer
84 views

ORA-01461 in a msaccess linked table

In an Oracle 11 database I have a table that all fields are varchar2. This table is linked in an access database, and when I try to do an insert from a data aggregate query, it throws the error ‘can ...
2
votes
2answers
46 views

what is the most simple and easiest way to backup and restore on oracle 11g?

Im new on oracle 11g i come from SQL Server administration and the process to back up and restore its very easy and intuitive. I was searching how to make backup and restore on oracle 11g in many ...
0
votes
0answers
31 views

I want to pivot a table and aggregate a column into strings [duplicate]

I have a select statement producing the following: +---------+---------+------+ | Patient | Pattern | Rank | +---------+---------+------+ | a | 0 | 1 | | a | 1 | 2 | | a ...
0
votes
0answers
45 views

connecting to database on ec2 Virtual Machine from sql developer

I am using Oracle SQL Developer 4 to connect to databases . We are running an Oracle 11g on Amazon EC2 Virtual Machine (not RDS) and I can’t connect remotely. inside the Virtual Machine as local ...
1
vote
2answers
41 views

How to check if restored database is the same as original

Is there a way to check if restored backup of Oracle database is the same as the original database? Is there a simple way to check it if I have the original database?
1
vote
1answer
155 views

cluster_database TRUE/FALSE what does it mean in Oracle RAC?

I have 3 databases on an Oracle RAC (two nodes) one database which is running with CLUSTER_DATABASE=TRUE on both nodes, the other two runs on each node with CLUSTER_DATABASE=FALSE what does it mean ...
0
votes
2answers
69 views

Oracle query optimization

We have a query that runs on a view and its execution time is about 6 min. SELECT COUNT(*) FROM someschema.item_total_violations WHERE channel_id = 122507833 AND item_date >= ...
0
votes
2answers
110 views

Oracle DB license for only non-production environments [closed]

My company is a software vendor. We develop software that is later deployed on the customer's environment, on their own machines. Our software uses various DBMS, depending on what the customer has. We ...
0
votes
2answers
101 views

Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?

Oracle has a favorite numerical class called NUMBER. It is a 22 byte value that just seems ludicrous in an index. I have some values that would easily fit in a 6 byte integer and would therefore fit ...
1
vote
0answers
120 views

Oracle listener configuration

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
0
votes
1answer
115 views

Oracle: Create a hidden user for RMAN backups only

It's been a long time since I worked with Oracle and I can't remember whether the following is possible: I'm trying to create a hidden DBA user [ alternatively do this process as root user ] to ...
0
votes
0answers
30 views

SQL Server to Oracle migration

Converted model resulted into incomplete script generation as all stored procedures, triggers and views were missing, only table structures were generated and i did not get any error messages for it. ...
0
votes
1answer
45 views

How do i prevent executing os command in oracle 11g

I have Oracle 11g installed on a linux serveur and i'm looking for a way to prevent sysdba from executing system command through oracle(Using java for example).
0
votes
2answers
2k views

Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

I installed Sql*PLUS on a cloud Oracle Linux Environment in order to access an remote database. I used the installation instructions provided as an answer here: ...
0
votes
1answer
40 views

Oracle grant select on a table

I want to grant select permission on a specific table to a remote ip address I had done it before in Mysql with this: grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd'; ...
2
votes
1answer
90 views

With Clause vs View of the same name

In my database, there is a view named VAL_DATES_V which is used in many other views in the same schema. For example, the SQL code in the view SECTOR_V uses VAL_DATES_V. CREATE OR REPLACE VIEW ...
0
votes
0answers
98 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer)

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...
0
votes
1answer
76 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
0
votes
0answers
29 views

How to identify which oracle 11g process using more memory

Oracle 11g 32bit Window server 2008 I have installed oracle 11g on window server2008. Total Memory Size =2504 Maximum Memory Size=2600 Normally it is using memory nearly 1750Mb, but from last month ...
1
vote
1answer
54 views

What to do when archive logs are lost/corrupted that are not backed up

All recently generated archive logs were corrupted but datafiles are fine.What if recently generated archives corrupted and the archives backup is not available, so what would be the strategy to ...
1
vote
1answer
43 views

Is there a way to get disc space remaining using an SQL query on an Oracle database?

We experienced a problem recently where the disc space ran low and some queries started giving unpredictable results. The root cause was that we'd take too many restore points and filled up the disc. ...