All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

0
votes
1answer
200 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
2answers
179 views

Unable to start Oracle database

We have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
0
votes
1answer
258 views

Check Oracle Service is Started from Batch Command

Uses: Oracle9i Standard Ed; I have a schedule which performs a Dump Import and afterwards the System Reboots itself, which is happening without any problem. After the System had rebooted, I have ...
0
votes
2answers
306 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 ...
1
vote
1answer
339 views

One Materialized View 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 ...
3
votes
2answers
1k 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
896 views

Running Oracle Export Utility within a Shell script

I have wasted a lot of time on this. Any ideas of what I am doing wrong here? Script in bash #!/usr/bin/bash . . . /export/home/app/oracle/product/10.2.0/bin/exp $uname/$passw \ FILE="$...
0
votes
1answer
284 views

BI-DIRECTIONAL Oracle Golden Gate for Oracle 12c and SQL Server 2014

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want to implement data synchronization between them with Oracle Golden Gate ...
-3
votes
1answer
32 views

Oracle takes more time to export csv

Oracle takes more time to export csv,i have tried with UTL_FILE & spool both takes more time,if there are any other way in coding for fastest export?
0
votes
2answers
936 views

RMAN 11g/12c Client compatibility

I'm having a Recovery catalog database 12c version. While I'm trying to register the target database (11g) with the catalog I get the following error: Recovery Manager: Release 12.1.0.2.0 - ...
2
votes
1answer
187 views

ORA-01017: invalid username/password;logon denied

There were other similar questions asked, but none that were able to tell me why I can't connect using a C# .NET web site I've stood up. While I know this forum is more for DBAs connecting to ...
1
vote
2answers
1k views

Specify NLS-Settings during Oracle installation under Windows

Is there an easy way to specify NLS parameters for the database during the installation? We want to install a new database (environment: Windows). For testing purpose we need NLS settings for ...
2
votes
1answer
817 views

How do I delete a file that has been locked by UTL_FILE?

I wrote a flakey PL/SQL script that crashed out and forgot to close the file handle (type UTL_FILE.file_type). Now I can't delete the file. Short of restarting the instance or rebooting the box, is ...
0
votes
0answers
64 views

What are PDE files and how can I use them?

I've got a legacy DB which was given to me as a collection of PDE files. I've googled around and didn't come up with any useful information. Saw this question: Import .pde file on PL/SQL Developer .....
1
vote
1answer
38 views

Test connection for linked server fails on desktop but not on server [closed]

On SQL Server 2012 I have a linked server to Oracle 12c. On the server a test connection succeeds. Security is set to be made using this security content with an Oracle user and no local logins are ...
0
votes
0answers
33 views

Query Adjustment Issue - going Haywire

I am having difficulty with a query and after a day or researching, etc, I have decided to seek some advice here. My current query runs and looks like the table below: Type Resource Code ...
4
votes
1answer
387 views

How can I prevent having inconsistent data under isolation level serializable in Oracle SQL?

I have the following table: InStores +--------+---------+-----+ | ProdID | StoreID | qty | +--------+---------+-----+ | p1 | s1 | 25 | | p1 | s2 | 70 | +--------+---------+-----+ ...
1
vote
2answers
45 views

Block size is for Database or Tablespace?

Forgive me I am just a newbie in the Oracle. I saw there is a db_block_size parameter which can be specified the block size for a database so that the whole database will be read and written data with ...
1
vote
3answers
69 views

Which one is created first? Database or Instance?

Forgive me I just learned Oracle. There exist so many terminologies in the Oracle world. Regarding the concept of database and instance. I already know some differences between them. The Oracle ...
11
votes
6answers
43k views

How to get rid of ORA-28002 message the password will expire within 6 days?

I have a user getting an ORA-28002 indicating that the password will expire within six days. I ran the following: ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; But when I try to log ...
0
votes
1answer
115 views

Oracle database migration or copy

I need to do migrate or copy the oracle 10g database from sun solaris to another sun solaris server (oracle 11g). I was tried with SQL Developer tool. But It is not able copy all the objects in the ...
1
vote
1answer
40 views

Why all users excep sys and system can connect to oracle db after database deletion on multi database environment?

I have 2 database on one server. I can connect to the database with normal users but cannot connect with sys and system users and invalid username/password occurs. before that I dropped one of the ...
0
votes
1answer
46 views

Unable to view partition table in a schema

I am using oracle 11g enterprise edition, I have created a schema as "TESTSCHEMA" and in it i have created a partition table as "sales_test". The query for the table, create table sales_test (...
12
votes
2answers
58k views

How do I declare and use variables in Oracle?

My main skills are with SQL Server, but I have been asked to do some tuning of an Oracle query. I have written the following SQL: declare @startDate int select @startDate = 20110501 And I get this ...
1
vote
1answer
31 views

Setting parameters like PCTUSED when creating new tables in ORACLE 12 C

When creating new tables in ORACLE 12 C, do we need to explicitly set parameters like PCTUSED, PCTFREE, INITRANS, MAXTRANS, STORAGE etc. (as shown in example below)? Or will ORACLE automatically set ...
1
vote
2answers
188 views

ORA-00257: archiver error

I ran into this error earlier today and requested that the extra logs be purged from the server. It was done but it still claims that there isn't any room. Is there a way to notify the server that it ...
1
vote
1answer
30 views

Accept use in sqlplus

I want to ask in SQL script for a start and finish date with accept but I get an error. accept v_FechaInicio date format 'DD/MM/YYYY-HH24:MI:SS' prompt 'Fecha de inicio ('DD/MM/YYYY-HH24:MI:SS'): ' ...
0
votes
2answers
227 views

Can I do an impdp with a file on my local computer

I was given a dump file which is currently on my local computer. I want to import this to our Oracle 11G DB which is hosted on a server. Do I need to move this file to the server to do the impdp or ...
4
votes
3answers
8k views

How to set Proxy Settings when installing Oracle 11g on Windows 7 Ultimate Edition?

I have downloaded the file - "win32_11gR2_database_1of2.zip" from oracle site. While installing Oracle 11g, I find this window in the first place: What to do? What values should I put on the ...
1
vote
2answers
10k views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ------------------------------------------------------------------...
-1
votes
1answer
46 views

Golden Gate Privilege Missing for using Encryption

dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1 ERROR: Unable to connect to database using user ...
0
votes
1answer
34 views

Abstracting away filtering behavior from Oracle SQL Function

I have a Oracle SQL function, which returns a bunch of records through various sub-queries. However, there are countless filters that can be applied to these result records. In an application ...
1
vote
2answers
81 views

Why does Oracle change my date fields?

I have an Oracle 11g XE set up in Moscow, Russia, and therefore on MSK time zone. When a client in the same timezone stores a DATE variable from Java with, say time set to 12:00, the time is changed ...
0
votes
1answer
46 views

Argument out of range error

I have this query: WITH I1 AS ( SELECT * FROM XYZ A WHERE UPPER(A.DES) LIKE '%%' ESCAPE '\' --' AND NVL(A.END_DATE, TO_DATE('9999-12-31', 'YYYY-MM-DD')) >= ...
1
vote
3answers
6k views

How do you correct a corrupted index in Oracle?

I have this ORA error in our logs: Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: '/data/app/oracle/oradata/MYSRVR/...
0
votes
1answer
26 views

SQL Error: Must be GROUPed or used in aggregate function

I have just created a SQL statement in Crystal Reports using the command feature, but I am having issues with displaying the data. The error reads: Attribute FUND_ACCT_REG_VIEW.FUND._ACCT_NO must ...
0
votes
1answer
40 views

exporting some table table from oracle DB to Mysql DB

I need to export some of the tables from Oracle DB to Mysql DB..i dont have any previous experience of export and Import. Could some please tell me how to do that ?
1
vote
1answer
37 views

How can I use an array variable inside the IN operator for Oracle SQL?

I declare a type TYPE arr_type is TABLE of VARCHAR2(11 BYTE); and then I initialize it: MY_array arr_type := arr_type();. I insert some varchars into it, and then attempt to use it with an IN ...
0
votes
1answer
54 views

connect to sqlplus without writing as sysdba [closed]

I want to connect sqlplus sys/test without writing as sysdba. I'm wondering if there is a way to avoid that.
1
vote
0answers
89 views

Unique constraint violated even though the table is empty

The item_type table is empty, yet on this: INSERT INTO item_type (id, name) VALUES (1, 'PHYSICAL') I get error: Error: ORA-00001: unique constraint (MYDB.SYS_C0013475) violated SQLState: ...
1
vote
1answer
200 views

ORA-01406 while building a Sphinx index

We are getting ORA-01406 error while trying to build an index over Oracle DB using Sphinx: root@bdt:~# ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ NLS_LANG=AMERICAN_AMERICA.UTF8 indexer bsrpIndex -...
0
votes
1answer
50 views

Oracle sqlldr convert date field with different NLS_DATE_FORMAT

I want to load data file which contains date fields in this format: 10-AUG-16 but, my oracle NLS_LANG is "Simplified Chinese_China.ZH16GBK", if I specify date format in control file like this: dd-...
0
votes
1answer
47 views

Oracle return the first row, not returning the first row

I have this query : select (quarter_1 + quarter_2 + quarter_3 + quarter_4) as total from budget where as_of_dt < to_date('2016-06-28', 'yyyy-MM-dd') order by as_of_dt desc; Which returns bunch ...
0
votes
1answer
48 views

How do i connect to remote oracle isql server using ODBC?

I have access to a public oracle iSQL*Plus Release 9.2.0.1.0 server (ex url : 1xx.1xx.1x.200/isqlplus). I need to set up an ODBC Data Source using this isql server. Please help me to setup an ODBC ...
1
vote
1answer
53 views

SP2-0584: EXIT variable was non-numeric error

I'm using following PLSQL loop to delete a large number of records from my table. However it is giving me an error that loop exit condition is not correct. FOR i IN 1..100 LOOP DELETE FROM ...
1
vote
1answer
62 views

How do I get multiple rows output in one line?

The data is like Jane has items pen pencil eraser. If I write the statement 'select * from item' the output is: Jane pen Jane pencil Jane eraser Jack box Jack wiper I want the output to be like: ...
1
vote
1answer
908 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 ...
3
votes
2answers
180 views

Copy Oracle database 10g to 12c

I need to copy an Oracle 10g (10.2.0.4.0) database (150GB) to an Oracle 12c (12.1.0.2.0) database. Both are Standard Editions. What method should I use? Target is on a different server - empty ...
1
vote
1answer
50 views

impdp expects wrong file path

Summary: I'm using expdp / impdp to export a database from a test / demo database (Oracle 11.2) and import it into an instance of Oracle Express (11g) on my own machine. The import fails because ...
9
votes
4answers
2k views

Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?

I am working on the transfer a big pl/sql web-based application to the dedicated server. This application is located in one schema with 70 packages of programm code. This application was made ...