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

3
votes
1answer
75 views

In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable:

In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable: define my_schema_name = 'schema_1'; CREATE OR REPLACE PROCEDURE ...
0
votes
1answer
24 views

What is the path of oratab on solaris?

What is the path of oratab on solaris? This is actually a question I google a lot and switching from environment to another, I tend to mix them up and forget. Today I googled it again and I wanted ...
2
votes
1answer
72 views

fastest way to generate permutations of a table with n columns and put in a new table added one more question to same how to remove duplicate rows

As i am from mathematics background and require to do some huge permutations to start in my work kind help. If i have a table by name sample1 with n columns what is fastest way to get all the ...
2
votes
1answer
42 views

I need to update a Oracle procedure via a .sql script

I need to update a Oracle procedure via a .sql script. I know the procedure works because it is currently running on our server, but I need to update the procedure on a client's box. I need to be ...
1
vote
1answer
68 views

Tracing failed login attempts in Oracle

I have some users who are logging in with a wrong password and their accounts get locked. Now I need to find the source of the failed login attempt. The machine, username etc. Is it possible to find ...
1
vote
3answers
59 views

DB cloning on daily basis

I have a requirement from one of my teams which is database copy (cloning) from production to my test server on daily basis at a particular time. I know this is a very simple process which every DBA ...
2
votes
1answer
35 views

help in correcting the syntax error of the below create table with as with multiple select

Please help to correct the syntax of the below. I am from a math background trying to use Oracle. The command helps me permute the columns and put them in one table. create table newsample AS ( ...
0
votes
0answers
31 views

Oracle 11g databse control with Enterprise manager on Windows 7 64 bit error

I am trying to install Oracle 11g on Windows 7 64 bit. I get Successful installation until when I get to connect to the database I got a message error.I login as a Username "Sys" with password and ...
0
votes
0answers
9 views

How to load a .dmp into PostgreSQL using pgadminIII [duplicate]

I have a dump file from oracle that I wish to load into pgSQL database. I can use psycopg2 or pgAdminIII to accomplish this. Any tutorials or references would be much appreciated as I cant seem to ...
3
votes
2answers
52 views

Oracle import dmp file: ora exceptions

I'm trying to import a .dmp file to my oracle RAC database using the following command: C:\app\ptmp>impdp [user]/[password]@'DEVRAC-SCAN:1521/DB' DUMPFILE=UPG_E_7d291ff.dmp ...
0
votes
0answers
9 views

Oracle Workspace Manager: Accessing specific workspace in different schema

There are specific methods to grant permissions on versioned tables (dbms_wm.GrantWorkspacePriv()), so GRANTs can be given on workspace level. Unless I misunderstood the concept, a workspace is part ...
2
votes
0answers
22 views

Oracle Workspace Manager: How is DDL applied to versioned tables?

We're considering the use of Oracle Workspaces for development/test environments. While its benefits are pretty clear concerning DML and data in general, my Google-Fu obviously wasn't sufficient ...
5
votes
1answer
35 views

Are there any potential problems with running distinct Oracle rman archivelog backups of the same database at the same time?

The scenario is that RMAN archivelog backups are scheduled to tape (TSM) every 2 hours. The scheduling ensures that such backups are run in a mutually exclusive fashion. A separate crontab based ...
3
votes
2answers
69 views

Database not able to startup showing control file is inconsistent with another

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error. SQL> startup ORA-01081: cannot start already-running ORACLE - shut ...
2
votes
0answers
47 views

Is PostgreSQL text really that much faster than Oracle CLOB? [closed]

I have an oracle 10g table with 1 clob column. The clobs aren't very large mostly around 2-8 kb. However reading many rows takes an excruciating amount of time. Even with storage in row enabled. I ...
3
votes
1answer
117 views

I want to change oracle “homedir” how to do?

A good link as answer is ok. I want to change "homedir" or "basedir" of oracle db from /oracle to /var/oracle. How to do? I have set the oracle unix variables($ORACLE_HOME,$ORACLE_BASE) with the new ...
3
votes
0answers
81 views

Oracle index on column with length > maximum varchar2 length

Description: We have a table on PostgreSQL 9.3 and we migrate it (data & structure) to Oracle 11.0.2.4. Here is our table: create table cstb_temp_log ( id NUMBER PRIMARY KEY, log_info ...
0
votes
0answers
27 views

Does RECO always resolve in-doubt transactions ? (Oracle)

I am working on an application which uses a Oracle 11gR2 database in order to fetch and store data. The application is written in C/C++ and some Pro*C, which takes care of everything related to the ...
3
votes
2answers
62 views

How to get return value from pl sql procedure and assign it to variable?

Code: execute x.procedurename(row.accc_no, row.bill_no, 0, null, row.total_balance, 'A',assgn_scen_site_cv, :assgn_scen_site_cv); Its my procedure. How to get return value from this proc and ...
0
votes
1answer
33 views

trimming leading characters

I'm in oracle and I have a table 'parts' in which have a field 'Description', which contains description for a part. my query is: SELECT DESCRIPTION FROM PART WHERE PAR_ID=123 AND DESCRIPTION ...
0
votes
1answer
27 views

Restoring ORACLE 11gR2 database with Flash Recovery Area Only

I was succeded in making backup using RMAN in Archivelog mode in my host server and this is the screenshot when i list the backup, and the next step, i copy content from Flash Recovery Area folder ...
0
votes
0answers
32 views

GoldenGate: How to encode Oracle RAW columns as hex strings?

I am using GoldenGate to extract an Oracle table that contains RAW data. The destination is a flat CSV file. How can I encode the RAW columns to hex strings so that they can be written to the CSV ...
0
votes
0answers
66 views

Find all possible pairwise 2 rows such that there intersection is only one element I have also a general question help on the same

Kind help to find the intersection of all pairs of rows of table and display only those pairs whose intersection is only at one element. Here I have a table say with 4 varchar elements for a sample ...
3
votes
1answer
50 views

Disable Oracle auditing for a particular user?

I have one application user in my Oracle 11g DB which does logins/logouts very often. Since this user is not a human, but an application I would like to exclude the login and logout actions of this ...
0
votes
0answers
61 views

Oracle Error ORA-15042 when trying to mount a diskgroup

everybody. I am having some troubles mounting my DATA diskgroup. I am getting this error: Mounting Disk Group DATA failed with the following message: ORA-15032: not all alterations performed ...
0
votes
1answer
64 views

Top Activity in OEM reports that dbms_scheduler jobs run as the job_creator user?

The top activity graph in Oracle Enterprise Manager was reporting that certain activity was being performed by certain users at odd hours of the night. Upon researching, this activity was because the ...
0
votes
1answer
42 views

Cannot connect using tnsnames.ora but can connect by substituting its details

I'm setting up a minimal Oracle Instant Client on a non-Oracle Linux host from zip files (as per https://docs.oracle.com/database/121/SQPUG/apd.htm#SQPUG157) and have installed ...
2
votes
0answers
229 views

Install Oracle 10.2.0.4 on Windows Server 2012 R2

I have problem with installing Oracle 10.2.0.4 on Windows Server 2012 R2. We are running old 10.2.0.4 instance on Windows Server 2008 R2. Now I have to migrate it to the Windows Server 2012 R2. ...
-1
votes
2answers
38 views

How can we connect and execute oracle database objects from Sybase database objects [closed]

Could you please anybody let me know how to connect to oracle database and execute the stored procedure/function from Sybase database objects?
0
votes
1answer
16 views

Problems to connect to an Oracle Database with SQLPLUS and URL-Variable, can somebody explain what I have to do?

I would like to connect to a ORACLE database via SQLplus. If I do it this way: sqlplus "user/pw@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = ...
0
votes
1answer
61 views

Invalid number error

Hi I'm doing a dimensional modeling exercise in college and I'm trying to convert the total_price entry in two of the database tables to euro so they will be in the dimensional table as euro. The two ...
0
votes
0answers
33 views

Oracle Enterprise Manager 11g - restricting tablespace access

This may be a complete newbie question but I need help nonetheless. I have an administrator assigned to a default tablespace with his quota set to zero on all other tablespaces yet find that when ...
1
vote
0answers
36 views

Oracle's DRCP not turning to ACTIVE even after dbms_connection_pool.start_pool() [closed]

Recently we received a report from DBA warning us about the amount of connections from one of our applications written in PHP using ZendFramework 1. Looking for the solution, we came up testing in a ...
0
votes
1answer
90 views

memory usage oracle query

We see Direct path read temp frequently in the database. It started with one query and later followed up to all the queries running in database at that moment. I understand that data is read from ...
1
vote
1answer
112 views

SqlDeveloper: ora-12505 TNS listener does not currently know of SID given in connect descriptor

Info connection name: ziv username:sys password: xxxxxxx connection type: basic role: sysdba host name : localhost.localdomain port: 1522 sid: ziv The QUAST is to connect to the database ...
3
votes
1answer
58 views

Running / Accumulative Sum with Reset - Oracle

I am trying to accumulate a sum, but the sum accumulated cannot be positive. So far i got the following: Select t.caccserno,t.Reportingmonthyear,t.Amount,t.cycleage from temp_UnpaidInterest t ...
0
votes
0answers
33 views

Are all Oracle DB Control features available in Enterprise Manager Express or Cloud Control?

I'm having a hard time figuring out if the new replacements for DB Control (Express and Cloud Control) support all of the features that were available in DB Control. I know Express is very limited, so ...
0
votes
1answer
36 views

Movement of Standby database from one location to another location

Looking for help on below mentioned process We are planning to move the standby database from Location A to Location B. I need your help to move this database using lift and drop method, by ...
1
vote
1answer
48 views

Oracle: using “as of” clause with table aliases?

I can run this flashback query with no problem: select x from a as of timestamp sysdate; But if I use a table alias I get an error. select foo.x from a foo as of timestamp sysdate; ORA-00933: SQL ...
0
votes
1answer
40 views

How can I use Oracle Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database?

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
0
votes
1answer
77 views

Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express

So I'm a DBA newbie and I've got an Oracle Enterprise server running in production with the following information under All Reports -> Data Dictionary Reports -> Version Banner, under ...
0
votes
1answer
32 views

How do I iterate over 1000 records in a particular order

I am writing a procedure to migrate two tables into different tables. This procedure will have two cursors. One to fetch the parent records and then second cursor to fetch the details for each parent ...
0
votes
0answers
48 views

Error executing SSIS package using SSMS in SQL Server 2012

I am new to SQL server and SSIS packages. I have a simple SSIS package that loads data from Oracle table into SQL table using linked server. But when I execute it using SSMS as scheduled job I am ...
1
vote
1answer
39 views

Restoring an Oracle database from files

I am running into a problem now, i have an oracle database that is stored inside a server and now because of the sudden blackout the c drive is messed up. The drive is partitioned, windows on c and ...
0
votes
1answer
41 views

List certain user ids and drop them in Oracle

How do I list certain user ids and drop them? For instance, I want to list user ids directly connected to database, in Oracle, and not any functional id. I need to write a script for the automation ...
0
votes
0answers
23 views

script to drop savepoints older than 3 days

I want to automate dropping savepoint older than 3 days. How do i write script to drop save points older than 3 days, in oracle. Please let me know on this.
1
vote
1answer
34 views

Chance of duplicate on single select max into statement

Against my will, I am told to use the following method to generate a new pk value. INSERT INTO SERVER_MONITERING(SM_SEQ, CPU_USE, MEMORY_BASE, MEMORY_USE, DISK_BASE, DISK_USE, ...
1
vote
2answers
37 views

Split varchar2 variable based on vertical line delimiter

I have following plsql code DECLARE v_personal_info VARCHAR2(100); v_name VARCHAR2(100); v_signature VARCHAR2(100); CURSOR c_personal_info IS select personal_info from users where ...
0
votes
1answer
33 views

How to get current time in Oracle, and use in interval partition?

I'm trying to create an interval partitioned table in Oracle where the first partition is bounded to a week from now, but I just can't seem to figure out the syntax. Here's what I have so far.. ...
1
vote
0answers
47 views

A call to a package procedure fails after upgrade to PSU24

We have just upgraded an Oracle Database 11.1.0.7 from PSU6 to PSU24. We have set a AFTER SERVER ERROR trigger to track application errors a while ago and checked its history table. Summary We see ...