Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

Filter by
Sorted by
Tagged with
4
votes
3answers
3k views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...
2
votes
3answers
27k views

insufficient privileges while executing oracle stored procedure?

I'm getting an insufficient privileges error while executing the following oracle stored procedure. I'm using Oracle Database 10g Express Edition. CREATE OR REPLACE PROCEDURE sp_update_acounts( ...
0
votes
1answer
91 views

Insert value into table without knowin column name

I'm trying to update values in table using column name from another table, why it is not working? You can see that I have in table TableOfDocuments, in column WORD1, the name DANA. Now I need to go ...
0
votes
1answer
109 views

How to cast in oracle -Spatial Database?

Im trying to get data inside the table which is below. CREATE TABLE Eshot ( eshotNumber NUMBER, eshot_geo_location SDO_GEOMETRY); Using this query returns unsupported data type; Select e....
1
vote
1answer
831 views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
6
votes
1answer
23k views

Oracle error 12154 while importing DMP file

My Setup I'm running Windows 7 64-bit, using Oracle DB 11g R2 for Windows 64-bit. I have Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the ...
0
votes
0answers
46 views

Database export taking 12 hours and still running

I'm running an export for a company I haven't worked with before. Started export last night at 7:00pm and it's still running 12 hours later. It's an agile 9.3.3 database, oracle 12c. So far the dmp ...
0
votes
1answer
16 views

Oracle restore to a differnet drive

I have the following script for rman to backup the main database and archive logs: connect target sysdba/password@localhost/db run { allocate channel d1 type disk; crosscheck archivelog all; delete ...
0
votes
0answers
21 views

A dbms_scheduler job is not running

I need help with debugging why a certain job is not running in Oracle with the dbms_scheduler. I have many other jobs running under the same user/schema and they work. So, how do I start finding the ...
-1
votes
0answers
18 views

Generate Unique_ID based on few records [closed]

I have rows like below 99 --row1 1 HOST 02 0 14 19 IBN STDLN 6X17AA N --row 2 3 9605944 OTWA1G148Y 0 10 613 SCA Y Y 0 --row 3 99 --row 4 1 HOST 02 1 00 11 IBN STDLN 6X17AA N --row 5 2 9572311 ...
0
votes
1answer
110 views

listagg in order and including a sequence of separator when missing any row of a sequence

Sorry for the long title but it's a little bit difficult to explain. We have a table | N rows | Atrib1 | Atrib2 | Atrib3 | Atrib4 | Final row | --------------------------------------------------...
0
votes
0answers
18 views

Oracle: Select values and join result from multiple rows in one with seperat cells

I have to create a select Statement, which bring me a multiple row result in one. For better understanding here my table Id | Name | Typ | Date --------------------------------- 1 | John | ...
0
votes
1answer
50 views

Script to install Oracle client 12c2 on Redhat linux 7.5

Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
0
votes
1answer
25 views

What is the default quota on a tablespace for a given user in oracle if you don't set one?

My environment I'm using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Explanation of the situation I was creating a user with the following command create user ...
0
votes
0answers
28 views

Oracle - partition table by 3 columns

I have, in Oracle database, fact table based upon which reports are generated. Table contains sales data - large volume. Users generating reports are usually using grouping by (sale_day, customer, ...)...
2
votes
2answers
5k views

How to find number of user connections to an Oracle database between a specific time period?

I want to find how many users established connections to the oracle 11g database in a 10 minute time interval. Please help
1
vote
2answers
184 views

Whether Cold backup method can be used to “migrate oracle DB”?

I have to migrate one database. I have exact server replica. Same directory structure on target as well as source database. Previously I have performed DB migration using export/import datapump as ...
-1
votes
0answers
18 views

Rollback date specific changes for user [closed]

I have updated a few changes some time ago using the commit statement. I now need to roll back the changes. These changes were done using my Oracle user account.
0
votes
1answer
34 views

What could possibly cause a numeric overflow when enqueuing an Oracle AQ message?

We create and enqueue messages with various properties, like this: message := sys.aq$_jms_message.construct(0); message.set_string_property('a', v_a)); ...
1
vote
1answer
284 views

How do I run a database heavy query over jdbc without timing out (Oracle)?

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows ...
-2
votes
1answer
42 views

ORA-01427: single-row subquery returns more than one row [closed]

Below query is throwing this issue but when i add the condition rownum <=1 it is updating single row , but i want to update the entire table not the single row UPDATE footnote p SET p.tac_id = ...
0
votes
1answer
108 views

Can't connect through sqldeveloper because locale not recognized even though my language/regional settings are English/US

On a certain machine I consistently cannot connect to an oracle db due to the locale not being recognized: Other people have noted the locale or language settings may not be compatible with the ...
0
votes
1answer
20 views

Can Oracle SE2 RAC works with only a single instance? Is it recommended?

I've got a client with an Oracle DB 12 SE2 RAC with two instances. One of the instances is giving too much problems. He wants just to remove it, and therefore leaving Oracle RAC running in only with ...
0
votes
1answer
135 views

How to ban a specific oracle user from accessing to specific listener?

I have two listeners L1 AND L2, L1 is listening on port 1521 while L2 is listening on port 1522.The oracle instance will register the database to L1 and L2 after startup. Let say I have two users, U1 ...
0
votes
1answer
19 views

RMAN - 01009 Error in Oracle 11gR2 [closed]

When I want to copy-paste this script: RUN { SET NEWNAME FOR DATAFILE 1 TO '/u05/NEWDB/app/oracle/oradata/FBDB/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/u05/NEWDB/app/oracle/oradata/FBDB/...
0
votes
1answer
226 views

Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM [closed]

if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
1
vote
1answer
23 views

Where does Oracle store message properties for AQ messages?

We create messages with various properties, like this: message := sys.aq$_jms_message.construct(0); message.set_string_property('a', v_a)); message....
-1
votes
1answer
144 views

cascade constraints in Oracle

Can we use the cascade constraints instead of specifying FK in our code I mean can we Use this execute immediate 'ALTER TABLE @PCWSCHEMA@pcwscannermaster DROP CASCADE CONSTRAINTS'; instead of the ...
0
votes
1answer
174 views

Database deployment using QSR (Quest Script Runner) is slow

As part of the automatic deployment of a project, we deploy various Oracle scripts (packages, tables, data, etc...) using qsr - Quest Script Runner that is part of Toad. The script executes multiple ...
1
vote
2answers
46 views

Index on a partitioned key

we have a list partitioned table. Let partitioned column be c1. We have an index on that column(c1). We are planning to drop the index. Our doubt is that if we drop the index, does it affect the ...
0
votes
1answer
365 views

SQLplus run without admin account

I have a weird problem. I login to a pc using non admin user. Then I installed sqlclient 64 bit for oracle 11.2. Installation went fine, no errors. Then i tried to login using sqlplus from command ...
-2
votes
1answer
19 views

SUM inside a CASE, retrieving “NOT A UNIQUE GROUP FUNCTION ERROR” error [closed]

I got this query that works but when I put the SUM i get a "Unique group function error": SELECT A.qty, A.order, B.order, CASE WHEN SUM(A.qty) = 0 THEN 0 ...
-2
votes
1answer
69 views

Creating new table with multiple values in a column [closed]

I have created a table with only one column Create Table RLID_MARK ( RLID Int ) I want to Add multiple values in Column RLID using insert into RLID_MARK (RLID) values( '43230335' , '20936450' , ...
-1
votes
0answers
43 views

Automating SQL queries in Oracle

I want to automate a SQL query, this query would run weekly and one field needs to change per run. So, for example, the query would be a total count for cars in stock but changing the country each ...
0
votes
0answers
43 views

How to run SQL statement on all databases using OEM?

I have access to Oracle Enterprise Manager Cloud Control 13c and I would like to know how much Memory (RAM) does each instance have allocated. This is achievable by running this simple SQL : SELECT ...
1
vote
1answer
125 views

ORA-24155 - Why am I getting this error when creating a chain rule

When trying to create a new chain rule, I receive ORA-24155 stating that the the rule I'm trying to create is not in the ruleset which doesn't make sense. I stop and drop all jobs/chains and then ...
0
votes
0answers
30 views

Range vs List partitioning for YYYYMM year month field Oracle 12c

I have a table which holds monthly data differentiated by a column year month (YYYYMM, eg 201911). We have been planning to partition the table by month however we are unable to decide between Range ...
1
vote
2answers
1k views

Select unique records from multiple records based on max date

I have table like below +----+----------+-----+-------------+--------+ | ID | ADDR | IND | update_Date | Sq_NBR | +----+----------+-----+-------------+--------+ | 1 | PHYSICAL | Y | 11-Oct ...
0
votes
1answer
944 views

ORA-16706: Data Guard broker worker process not available [closed]

Database version is 12.1.0.1. We have one primary database and two physical standby database and dataguard also configured. Dataguard sync is fine working between primary and physical standby.(No lag)...
0
votes
0answers
53 views

Creating new table from a query results [migrated]

I want to create a table of output from this query,Table is giving USR_ID Kindly help I'm novice to SQL select USR_ID from USR,company@,employee where SK_USR_ID=USR_ID and Assignedto=employeeID and ...
0
votes
1answer
157 views

RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover [closed]

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba I an mot a DBA, but a UNIX/Linux System Administrator ...
2
votes
2answers
214 views

Deadlocks With Trigger Based Replication

A table ORIGINAL exists with the following structure: ID VARCHAR Length 10 (key) VALUE VARCHAR Length 10 (non-key) A table REPLICATION exists with the following structure: ID ...
0
votes
1answer
40 views

Oracle Can a Dropped View Be Recovered?

I dropped a view 20 minutes ago. Can I recover it? If yes, how?
1
vote
1answer
20 views

Setting NLS_LENGTH_SEMANTICS for session via trigger

I have the following problem with my Oracle 12c database. I have to install a third party application, which needs an Oracle database instance. The supplier demands to set the NLS_LENGTH_SEMANTICS ...
0
votes
2answers
3k views

Oracle full expdp/impdp but skip data in some tables

I'm trying to export a schema and then import it, but there are some huge tables that I must skip all the data from (that is, I need the tables and all stuff related to them, just not the rows). So I ...
0
votes
1answer
154 views

Oracle RAC and DataGuard configuration

We have deployed an Oracle RAC cluster which consists of three Oracle instances. As we are considering the HA issue, and as far as I know, the only way of Oracle HA is DataGuard. So is it possible ...
-2
votes
0answers
30 views

Joining Multiple Tables causes Duplication and total price is not calculated properly [closed]

These are the created tables: CREATE TABLE hosins ( insurance_company_insurance_id NUMBER(4) NOT NULL, hospital_hospital_id NUMBER(4) NOT NULL, disscount_rate NUMBER(5,...
3
votes
2answers
64k views

How to format sql-plus-spool-file to *.csv with all columns in one line and row-content with linebreaks as one field?

I am not a professional, sorry. But perhaps you can help me anyway ... I have a table with 27 columns and within the rows data with linebreaks. When I try to export selected rows with sql-plus spool,...
0
votes
2answers
363 views

Total time execution of a query

I`m trying to obtain the total time of a query execution I have this query but not allways get the output that I hope, For example for the same parallel 4 execution of a query sometimes I obtain 5 ...
0
votes
1answer
29 views

select subquery condition in where statement

I am getting this error: ORA-06550: line 43, column 16: ORA-00904: "STOCK_BALANCE": invalid identifier ...for the following query: select PARTY_ID, PARTY_NAME, IT_ID, IT_ID ||...