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

1
vote
0answers
25 views

Select query with views crashes with ORA-03113: end-of-file on communication channel

I've installed an application developed on 11g XE in a 11g Enterprise Edition server (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production) and main SELECT query triggers this: ...
2
votes
1answer
52 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
votes
0answers
13 views

SQLException: Missing IN or OUT parameter at index:: 1 and can't safely reply call [on hold]

I have one doubt for below error SQLException: Missing IN or OUT parameter at index:: 1 why this error came and what is the scenario we get the above error. Anyone explain for the above error and ...
1
vote
0answers
29 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 ...
1
vote
1answer
32 views

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

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 ...
-3
votes
0answers
14 views

calling sql table from pl/sql block [on hold]

I have created one table as shown below:- SQL> select * from students; SID SNAME SADD ---------- -------------------- -------------------- 101 pavan ...
-3
votes
0answers
29 views

What is the optimized query to get max id from a table? [on hold]

I have this query: select max(id) from myTable As myTable has one million rows, sometimes the query throws this error Transaction TransactionImple < ac, BasicAction: 0:ffff0acb10a4:126a:...
-1
votes
0answers
22 views

Oracle 12c Installation in Windows10 error INS-30131

I have a problem while installing Oracle 12c on Windows10 as i got the following error: INS-30131 ... with the following details: Cause - Failed to access the temporary location. Action - ...
-1
votes
0answers
49 views

Comparing between databases

I'm using SQLplus, and am currently working in two different databases/tables (or so I think), and in short, I need to find the names of occurrences that contain a specific name and unit in ...
0
votes
3answers
68 views

After successfully installation, Is it possible create database without DBCA?

Sorry for I am not familiar with the Oracle. Please help me grow up. :) As the title said . Could someone please tell me the steps how to create a database manually through SQL without using DBCA? ...
-3
votes
1answer
26 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
3answers
64 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 ...
0
votes
2answers
36 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 ...
0
votes
1answer
39 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 (...
0
votes
1answer
22 views

Messed up output

Whenever I run sql statements like (select * from employees;) to display long outputs, the output is always unaligned, scattered and very difficult for me to read. I just signed up here and I hope ...
0
votes
1answer
29 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 ...
0
votes
0answers
53 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
31 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 ...
1
vote
1answer
27 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
0answers
101 views

How to provide referential integrity in databases? [closed]

Previously I've used MS Access, so such databases as MySQL and Oracle is confusing for me. I want to know how to provide referential integrity, in Access it was easy (there you should bind tables by ...
-1
votes
0answers
42 views

Friendly tool for interpreting Oracle query stats [closed]

DBMS: Oracle (recently migrating to 12c. In 11g compatibility mode at the moment). I work in a team that creates reports for customer needs. We do this by writing custom SQL queries wrapped in a ...
-5
votes
1answer
56 views

What is the purpose of sequence? [closed]

Is it good practice to use the object "sequence" for GENERETING unique primary key values. What is the purpose of sequence in both Oracle Sql and Sql Server?
0
votes
1answer
31 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
votes
1answer
40 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
21 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 ...
1
vote
1answer
30 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
41 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')) >= ...
0
votes
1answer
25 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 ?
0
votes
1answer
45 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.
0
votes
1answer
37 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
45 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 ...
1
vote
1answer
60 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
39 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
38 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 ...
0
votes
1answer
35 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
0answers
49 views

Getting Error/Exception In GoldenGate Replication

I am planning to configure a simple GoldenGate configuration and want to implement an exception table that will store all the exceptions. I followed two links, neither of which work for me: ...
1
vote
0answers
82 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
0answers
56 views

Can't run procedure on Oracle SQL Developer [closed]

Since yesterday, I have not been unable to run procedure on Oracle SQL Developer. When I click on Run button, progress bar with "Launching" text appears on the right bottom corner of the SQL Developer,...
1
vote
1answer
40 views

How to select all attributes of object type

I am running select query with a function in it. That function returns an object type with 4 attributes and I'd like to select all those attributes. When I try it int this way. It returns just the ...
1
vote
2answers
75 views

How to create database/tablespace/schema and users for quickstart developers on Oracle 12?

Background I need to create a contained development space for a new application. This requires a user account to connect with all permissions, such as create/drop tables and stored procedures. ...
0
votes
0answers
28 views

Install Oracle Instant Client components from Custom option

Installing the Oracle DataBase Instant Client 12c, 4 options are displayed: Instant Client - This installation type installs only the shared libraries required by Oracle Call Interface applications ...
0
votes
2answers
32 views

CASE statement multiple conditions

I've got a simple table below, Select * from message_log where Message = 'BUILD' order by 1; +------------+-------------+ | **Message | Log** | +------------+-------------+ | Build | ...
0
votes
0answers
43 views

Oracle Instance Shutting Down randomly :- ORA-01034 Oracle not Available ORA-27101 Shared Memory Realm does not exist

We are facing a peculiar issue in our development enviornment. Oracle Starts properly and then again gets down due to issue and not able to connect to the Oracle Instance. Here is a Trace from alert ...
0
votes
2answers
71 views

Where is my ORACLE_HOME Windows directory?

I'm trying to find my listener.ora file to edit it, but the docs say it's in the ORACLE_HOME directory, but where is that? I'm running 12.1.0 on Windows Server 2008
1
vote
0answers
50 views

Conditional flow in sqlplus

I have script for SQL plus, which I use to create user and get arguments for username and password. I want the script to do more things when it runs on oracle 12c, but I'm trying to avoid writing ...
1
vote
1answer
45 views

Oracle - execute DML query as different user

I would like to be able to run DML queries (INSERT,UPDATE,DELETE) by executing a procedure on a given schema. Those queries need to change data on different schemas on the same instance. So, basically,...