Tagged Questions

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

0
votes
1answer
20 views

Connection through listener stops working after VPN client is active on DB machine

I have an Oracle 11g2 64bit database instance running on my Win7 developer machine. Normally everything works fine, I can connect to the DB with or without listener. (Normally all connections are ...
0
votes
0answers
16 views

ORA 00933 SQL command not properly ended, WHERE function

I've made a query that works perfect but when i add the sentence below it gives the error ORA 00933 SQL command not properly ended Could anybody tells me why following addition to script gives ...
0
votes
1answer
31 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 ...
0
votes
0answers
5 views

Customizing OEM notification title and body

I am writing a reporting tool that accepts email notifications for incedents , alerts and events coming from the OEM. The tool parses the email title and body to extract information from it. I was ...
0
votes
0answers
30 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
0answers
20 views

Is Moving data from Greenplum to Oracle for reporting is advisable? [on hold]

We are working for one of the leading telecommunication industry for data warehouse and business intelligence reporting , The volume of data is very huge in size(CDR data) and frequency of getting the ...
0
votes
0answers
12 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 ...
0
votes
0answers
13 views

Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?

What is the simplest way to log in as user X and see all tables,... of schema Y as if they belonged to X? With an Oracle 11g database, I would like to log into the database using user X but all the ...
0
votes
0answers
10 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
36 views

Char in select why [on hold]

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

Oracle 10gR2 - fix for SSL version following Poodle attack

We use Oracle utl_http to send https requests from within our database (10gR2). As SSLv3.0 is now considered insecure (POODLE) we need to upgrade to TLS. How can we ensure TLS usage when sending ...
0
votes
0answers
22 views

Expdp with metadata_only gives way too large dump. Why?

There is an oracle 11g schema with amount of data about 700 Gb. There are tables/indexes only in that schema, no procedures/packages. Doing expdp on that schema expdp schemas=TheSchema directory=dir ...
0
votes
2answers
36 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 ...
0
votes
1answer
28 views

Installing Oracle 10g on Oracle Enterprise Linux 4 [on hold]

I'm installing Oracle 10g manually on OEL4. I have installed Oracle 10G software only. Then I was trying to go to the $ORACLE_HOME/dbs location to set parameter file parameters. I have done something ...
0
votes
0answers
29 views

Using Cloud Oracle server in .Net application (ASP.Net web site) [on hold]

I need to be able to use a cloud Oracle server from my .Net application. Does ODP.Net support cloud Oracle server? Is there a quick "Hello world" example that includes connecting to a cloud Oracle ...
0
votes
1answer
37 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
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 ...
1
vote
3answers
86 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
37 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 ...
0
votes
0answers
31 views

One to many size and performance

Is it worth to create a inverted relationship in order to have faster searches? My entity has 10 possible values on the Many side of the mapping, most of the time the 10 will be selected. Let's call ...
1
vote
1answer
42 views

Stop on error in PL/SQL developer or Oracle SQL Developer

At this time I am using TOAD to apply SQL*Plus scripts and there is an option to stop on the first error. After it I can fix the script and apply the remaining part. Due to license issues we can't ...
0
votes
0answers
15 views

I cannot add oracle listener with windows server 2008 r2 [closed]

how to fix It failed in the execution of "Srvctl.bat". Details of error
1
vote
1answer
46 views

Oracle PLSQL code recovery

I cannot connect to my database as admin, even using connect descriptor neither via RMAN. I am getting TNS-12514 error. I consider to install new instance. Questions: 1) Can I restore/recover PLSQL ...
0
votes
1answer
40 views

Problem with procedure performance

I'm having problem in Oracle, where I have two procedures that are executed one after the other. Where the first procedure, I have a cursor that does insert into a table. This insert has about 30 ...
0
votes
0answers
51 views

CLOB data type is not working as expected [closed]

I have this Oracle 12c procedure CREATE OR REPLACE PROCEDURE LOGINCHECK(SQLQRY IN CLOB) AS C INTEGER; N INTEGER; RC SYS_REFCURSOR; stmt clob:= To_Clob('begin ' || sqlqry || '; end;'); ...
0
votes
2answers
46 views

Is there anyway to search PL/SQL reserved words with contains function?

Is there anyway to search PL/SQL reserved words with the contains function in the Oracle? We would like to search keywords such as "test for" or "test do" with the contains or catsearch functions ...
1
vote
0answers
21 views

Replacement for Pragma Restrict references

Up to Oracle 11.1 you could mark a package as only reading from the database by adding PRAGMA RESTRICT_REFERENCES( DEFAULT, WNDS); This has now been deprecated. I would like to enforce read only on ...
1
vote
2answers
42 views

Configuring sqlnet.ora and tnsnames.ora on the client side

I have an application server talking to an Oracle database, using the Oracle instant client. We are troubleshooting a specific bug, and it was asked if I could add the following flags to to my ...
0
votes
2answers
41 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
31 views

grant permissions in oracle from one database to another

I have two databases, employeedb and contractordb. The employeedb has a user called employeeuser and contractordb has a user called contractoruser. (These are the users I log in with in Oracle SQL ...
0
votes
0answers
39 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
20 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: ...
2
votes
2answers
54 views

Oracle: Helping hand writing this query. Do I need a sub query here?

I have the below query that returns the number of orders created on a particular customer number per month for the past 2 years. SQL SELECT TO_CHAR(o.entry_date, 'MM'), SUM(CASE ...
1
vote
1answer
26 views

group records according to column

hi how can make this result query: to this: I have this code and i know it's still farfetched: select max(case subcod when 'DISABILITY' then A end) as disability, max(case ...
0
votes
1answer
35 views

How to list objects that are using another object?

I have to move certain objects from a schema to another. The database is rather large and I want to make sure we test properly all affected objects. On TOAD there is a Tab called "Used By" that show ...
-2
votes
1answer
35 views

Oracle Concurrent Insertion

We have simple case like Create table t1 (c1 number primary); session1: insert into t1 values (1); //session1 do not commit transaction session2: insert into t1 values (2); Will Session2 ...
0
votes
0answers
50 views

Oracle 11 express vs Oracle 11 enterprise performance

We have a very long select query which is executed via our java application through hibernate. This takes 2 seconds to execute on our local Oracle 11 express db server and takes around 22 seconds on ...
0
votes
2answers
41 views

How to detect in which schema a procedure is called?

I'm struggling with a problem in Oracle 12.1 regarding to procedures. We are using a data isolation approach based on schemas. We use one schema as PUBLIC and each project has exactly the same ...
0
votes
1answer
41 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
0answers
33 views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
1
vote
2answers
46 views

Permissions needed to call DBMS_DATAPUMP from within package

I am attempting to write a procedure (within a package) that calls DBMS_DATAPUMP to copy an existing schema into a different schema. The code works when executed from an anonymous block, but from a ...
0
votes
2answers
18 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
29 views

What do these pstart and pstop values mean?

I'm attempting to tune a query and I want to be able to tell if partition pruning is happening. On one part of the query, the I'm getting a Pstart and Pstop value = "KEY": | Id | Operation ...
0
votes
2answers
21 views

Create a test enviroment in Oracle 10g

I have a production enviroment in a Oracle 10g database which I would like to authomatically duplicate in a test enviroment. My production enviroment is just a number of tables in which I have usually ...
0
votes
2answers
45 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 ...
0
votes
1answer
28 views

Oracle 11g r2: Cannot create partition on timestamp field

I have data with a timestamp field of the form '2014-01-01 00:00:00.99' in one of the columns. I want to create a new partition for the table every month. For this I did something like this. CREATE ...
1
vote
1answer
26 views

What are the considerations when using SERLIALIZABLE over READ COMMITTED isolation level in Oracle?

What are the considerations when using SERIALIZABLE isolation level over the default READ COMMITTED in an Oracle database? Given the concurrency system used within Oracle (using transaction logs to ...
0
votes
1answer
23 views

Using database control in Oracle 12c

When I want to use Oracle 12c GUI, I receive an error as written below: Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in ...
1
vote
0answers
33 views

reduce the cost of maintaining a materialized view? [closed]

how to reduce the cost of maintenance a materialized views? and when I selected between maintaining by recompiling and maintaining by refresh?
0
votes
1answer
22 views

Call to Function in Oracle says it's not declared

When I call the next stored-function in oracle: CREATE OR REPLACE FUNCTION SOLICITAR_DISPONIBILIDAD (parqueo IN NUMBER, semestre IN NUMBER, año IN NUMBER, jornada IN NUMBER) RETURN INTEGER IS ...