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

3
votes
1answer
718 views

How to separate out individual sql statements from Oracle SQL script for execution from java code

I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code. I am reading this sql script from a .sql file and the script contains statements such as create table, ...
0
votes
0answers
26 views

SQL Loader data load in multiple tables

I have a question regarding SQL*Loader : We are loading 40 tables from external files using sqlloader; if data load fails and only 30 tables are loaded, is it possible to start load from 31st table ...
1
vote
0answers
34 views

Database recommendation for load of 100M rows [closed]

I am currently using mysql databases for storing and processing 20M rows, now I want to move from processing volume of 20M to 100M rows. I am thinking of going for Oracle database, Please let me know ...
1
vote
1answer
188 views

Mistake during Oracle 11g PITR

I tried using set time until.. and mis-typed the date. Can anyone help me understand how to get my backups into a manageable state? After the accidental recover, most of my backupset disappeared. I ...
2
votes
2answers
706 views

Can't drop UNDO TABLESPACE

We have oracle 11gr1 rac two instances on two different servers, new undo tablespace UNDOTBS20140508 created 30G, I want to remove the old one UNDOTBSX02, I did the following: CREATE UNDO TABLESPACE ...
2
votes
2answers
1k views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
2
votes
2answers
466 views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
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
44 views

How do the Oracle DB instance and the local listener communicate?

It seems this my other question needs some background: Basically, on Windows, how do the Oracle DB instance process and the listener process communicate? Do they use TCP? Is the configuration of this ...
5
votes
1answer
25k views

Oracle 11g listener fails with ORA-12514 and ORA-12505 errors

I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus: c:\>sqlplus ace SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
7
votes
2answers
4k views

How to extract Procedure, Function, etc. Source Code from an Oracle Export

I have generated an EXPDAT.DMP file of an Oracle database with the command: exp userid=usr/pass@db owner=own rows=n compress=n I then ran the following command to generate a file containing the ...
3
votes
2answers
544 views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
0
votes
1answer
350 views

Copying a table in SQL Server database to Oracle database

I am new to database management. I need to copy a particular table "Attendance" in SQL Server database to Oracle database. There is no connection between the two databases. Also, "Attendance" is ...
0
votes
1answer
51 views

unique constraint violated

I have code create table CREATE TABLE OFPHONE ( PHONEID INTEGER NOT NULL, HOTLINE VARCHAR2(20 CHAR), EXT VARCHAR2(20 CHAR), PHONE VARCHAR2(30 ...
2
votes
2answers
7k views

insufficient privileges while executing oracle stored procedure?

Im getting insufficient privileges error while executing the following oracle stored procedure. Im using Oracle Database 10g Express Edition. CREATE OR REPLACE PROCEDURE sp_update_acounts( ...
2
votes
3answers
2k views

How to automate Oracle DB installation (like a 'hands-free' install)?

I installed the Oracle 11g2 'standard' edition using the following zip-files: linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip I used the installation guide by Oracle which I ...
1
vote
1answer
652 views

Connect Apache Http server with Oracle

I have problem with connect ApacheHttpServer with Oracle. All work on OpenSuse 12.3 At first I install Oracle instal client 11.2. Set environment variables: ...
1
vote
2answers
431 views

Repopulating Oracle tables using data from Excel/CSV file

I'm developing a Java EE application that utilizes Hibernate/JPA. Some of the data I want to use comes from another Business unit's spreadsheet that I need to periodically (re)load into 5 Oracle ...
2
votes
1answer
96 views

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database ...
0
votes
0answers
35 views

Update on table deletes the record

I'm having a problem in my oracle database, I have a table PAYMENTS which has an ID (PK) and when I want to update a record: UPDATE PAYMENTS SET AMOUNT = 2000 WHERE ID = '1'; The record with ID = ...
0
votes
2answers
25 views

Oracle 11.2 Configuring authentication

Can the following be setup in Oracle11.2 for password authentication? A new, non temp password should be atleast 24 hours old before it can be changed. System admin and authorized help desk ...
0
votes
1answer
118 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
2
votes
1answer
503 views

ORA-16000 when trying to perform select on read only Oracle database

My application's SQL encounters an ORA-16000 error when trying to access a read only Oracle database. ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: ...
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 ...
1
vote
1answer
461 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
1
vote
1answer
11k views

ORACLE restore - how to restore specific .bkp file?

I just started working with oracle and I have some issue. My database is NONARCHIVELOG mode. I made two backups: they are at locations: ...
0
votes
0answers
29 views

How to make sqlplus output appear in one line when running using shell script?

For example i have an output as below : exec dbms_stats.gather_table_stats(ownname =>'ABC',tabname=>'XYZ', no_invalidate=> FALSE, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt=> 'FOR ALL ...
-3
votes
1answer
45 views

Char in select why [closed]

In sqlplus query eg: select a.phonumber from customers a where User = 'mark' Why using the character a -- what is benefit? Thanks
0
votes
2answers
49 views

ORA-01410 Error

I am getting ORA-01410 and ORA-06512 for the following block of code in a trigger im firing for deletion of a record in my table. Are the calls correct ? getlong ('xxx', 'YYY', :OLD.ROWID), getlong ...
2
votes
2answers
8k views

User Password Expiry date

Is it possible to find my password expiry date without asking the DBA? My user does not have privileges to view the DBA_USERS table. Also, I tried select * from USER_USERS table, but expiry_date is ...
0
votes
1answer
237 views

Queries hang when accessing Oracle via ODBC and Python

I have Python scripts running on a Windows 2003 server that access an Oracle 11g database in the US via VPN. I am in the UK. We have recently moved offices and upgraded our broadband speed. Some of ...
0
votes
2answers
50 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 ...
5
votes
1answer
306 views

Find active values of SQLNET.ORA parameters on server

How can I find the active values of SQLNET.ORA parameters on the server? I know how to find the SQLNET.ORA file but there's no guarantee the values in that file are actively used. Parameter changes ...
0
votes
2answers
72 views

Oracle Standby Database - Archivelog GAP

Good Afternoon! I've done some research around fixing archivelog gap between Primary and Standby databases, and a few links provide tips on the querying V$archived_log, v$archive_gap and ...
0
votes
1answer
171 views

FAST REFRESH ON COMMIT on Materialized view

I am trying to implement a materialized view which would Fast refresh on commit. I have created materialized view logs on base table as well but i am faced with the following error. ORA-12052: cannot ...
0
votes
1answer
65 views

Update table from different table

UPDATE RBI.RBI_OV_F_DETAIL A SET (BRANCH_ID, BRANCH_NUMBER) = ( SELECT PRICE_BRANCH_ID, PRICE_BRANCH FROM RSE.RSE_SO_F_ORDERS B WHERE A.SOURCE_ID = ...
1
vote
1answer
197 views

One Materialized Views in Two Refresh Groups

I have five materialized views that I want to refresh in two occasions, every Sunday and at the 1st of every month. I created a Refresh Group for the weekly and that works fine. But when I tried to ...
0
votes
1answer
47 views

How can I determine the edition an Oracle session is using?

We are using the Edition Based Redefinition feature in some software and as a DBA, I want to be able to determine which edition each given connection is using. This way, we can be sure all ...
0
votes
2answers
87 views

Unable to mount database: error reading control file

I have an installation of an Oracle XE on Windows 7 (Home Premium). The database worked fine until yesterday when the database could not be started. It reports ORA-01033: oracle initialization or ...
1
vote
2answers
1k views

ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”

I faced an error while logging to database with regular user (non SYS/DBA): C:\Users\user>sqlplus tester@orcl ORA-01033 ORACLE initialization or shutdown in progress However I can connect via ...
0
votes
1answer
957 views

How to create Oracle RAC database using dbca silent mode with different db_name and db_unique_name

I have a requirement to use dbca (version 11.2.0.3) silent mode to create a RAC database on a 2-node RAC and the db_name and db_unique_name must be different, I tried following dbca command ...
1
vote
1answer
79 views

Escape characters in Oracle dump

I'm new to oracle and I have this problem. When I take a dump of particular table which has CLOB data type, the resulting dump doesnt handle escaping special characters. So I get ' un escaped, so ...
0
votes
1answer
170 views

Unable to create Central Inventory

I am Traying to install Oracle 11g on my Linux a have alrady config the varible and X-host but can,t able to Create Central Inventory my Central Inventory location is : /u01/app/u0 ** and ...
7
votes
1answer
339 views

Designing Simple Schema for Disaggregation of Demand Forecast

I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case: I have a parent-child hierarchy of products (example, Raw ...
0
votes
1answer
116 views

Error exp oracle XE on centos

i have a problem when i try to export ... Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR ...
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
1answer
33 views

ORA-27100: shared memory realm already exists oracle

I'm trying to start our db after performing a shutdown abort on a oracle 10g server, but atm i'm getting the following message: ORA-27100: shared memory realm already exists Linux Error: 17: ...
0
votes
3answers
79 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
1
vote
3answers
99 views

500 databases or 1 database with 500 tables or just 1 table with all the records? [closed]

I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support ...
0
votes
1answer
42 views

The most important oracle database performance metrics [closed]

Team, I need to collect the top most 10 important Oracle database related metrics from Oracle OEM. Can somebody help me define them? I could not find document that list the metrics for oracle ...