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
69 views

Generic or better yet custom message of the day in Oracle sql plus

I'm trying to create a message of the day type notification when users login to sqlplus. Currently I use the login.sql to add a dbms_application_info and set a module and action for the message. ...
0
votes
1answer
162 views

What is the meaning of “sga_max_size= # internally adjusted”

I used following command to get backup of my spfile. CREATE PFILE='c:/test_init.ora' FROM MEMORY; it has following lines related to memory. memory_max_target=12G memory_target=8G ...
4
votes
3answers
619 views

Do roles have an owner in oracle?

Suppose that I have logged in to oracle database using user X, then user X creates some roles using create role command. I want to know that is user X the owner of the roles? Can I select all roles ...
0
votes
2answers
61 views

SELECT first value from 3 tables that is not null

Having 3 tables with name(varcahr) value(varchar) pairs how do I select the value for a given name from one of the table with respect to the following conditions select value from tab_1 if it exists ...
0
votes
1answer
114 views

Best practices in securing Oracle Standard edition one [closed]

I have a database server with Oracle Standard Edition One. I'm interested what are the best practices to secure Oracle? I have Java web application installed in the same server. The Java application ...
-1
votes
1answer
59 views

Shutdown immediate displays an error

During my shutdown for the database, there is ora error message return and it won't let me shutdown my database. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ...
0
votes
2answers
37 views

Get values that match any of pattern

Given two tables values(value varchar(100)) and patterns(pattern varchar(100)) How to select all rows from values that match any of pattern found in pattern table's rows
1
vote
0answers
35 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. There are ...
1
vote
1answer
86 views

table or view does not exist

am trying execute this lines in procedure : FOR I IN (SELECT * FROM TBL_MT_MOATA WHERE MT_RECEIVED_TIME between TO_CHAR(TRUNC(SYSDATE,'Month' )) AND LAST_DAY(TRUNC(SYSDATE, 'Month'))) LOOP ...
1
vote
1answer
88 views

How to use the dbms_sql to get the analyze for insert into statement

declare v_cursor number; stmt varchar2(2000); s varchar2(40); cursor cc1 is select voc.SQL_ID from v$open_cursor voc left join v$sql vs on voc.SQL_ID=vs.SQL_ID where voc.SID in(select sid from ...
1
vote
1answer
49 views

Create Standby database using SE

We are on 11.2.0.1.I have been trying to create a Manual Standby database using Standard Edition. Although at this point its more like an incomplete recovery. This is wat i did Create Standby ...
0
votes
2answers
84 views

Is it possible to know how many times a user connected to an Oracle database?

Is it possible to know how many times a user connected to an Oracle database? If possible where we can find this information?
1
vote
2answers
326 views

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it ...
0
votes
1answer
42 views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

Hi I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane. While procedure get executed successfully. What I am doing wrong. ...
0
votes
2answers
166 views

Cannot connect to database remotely (not even locally when using ip address)

I can login using this command: sqlplus test/test@127.0.0.1:1521/local But not this one: (where 192.168.0.240) is my IP sqlplus test/test@192.168.0.240:1521/local I am absolutely sure that my ip ...
0
votes
2answers
42 views

Where .dmp file is restored after import in oracle?

I am new to oracle and I have abc.dmp file at c:\abc.dmp location. I want to import this abc.dmp file. I am using the following command. c:\>imp system/mypassword file=c:\abc.dmp full=y I am ...
1
vote
1answer
57 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
1answer
214 views

Oracle intermittent performance problem

I have some complex queries that are usually fast (< 1 sec), but occasionally slow (> 10 sec, even minutes). How do I track this down or identify what condition is causing it? One theory was ...
3
votes
0answers
48 views

Why would function based indices I’ve created lower the cost but now show up in the explain plan breakdown?

Sorry for the terrible column/table names but since this is for a work project I wanted to insure it was ok to ask. I was just hoping to at least learn why I'm not seeing my functional indices being ...
2
votes
1answer
88 views

How to verify an oracle database license

We have bought an oracle 11g database license the supplier gave us a paper with oracle logo and said that is the license, we were expecting our company name to appear on it, but it doesn't. My ...
0
votes
1answer
52 views

“Invalid option” while creating a tablespace

Can someone tell me what is wrong with this syntax: CREATE TABLESPACE ACME_DATA DATAFILE '/oracle/d02/acme/ACME_DATA_01.dbf' SIZE 40M EXTENT MANAGEMENT LOCAL AUTOEXTEND ON NEXT 2M MAXSIZE 100M ...
0
votes
0answers
43 views

Execution time is different between normal query and query inside a stored procedure

I have following simplified query WITH Report1 AS ( SELECT SUM(t.X), SUM(t.Y) FROM Table1 t WHERE t.Date1 > :dateStart and t.Date1 < :dateFinish ) SELECT * FROM Report1 This query ...
0
votes
0answers
38 views

Enterprise Manager goes pink, legend color for other

To whom it may respond to, While monitoring our databases, we have seen that one of EM screens has gone pink, the color stands for OTHER at the legend. We have checked alert log and trc files, ...
3
votes
1answer
193 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
1
vote
1answer
270 views

Oracle 10g: Optimizing an update query that uses a subquery

I have the following query within a stored procedure, and I've been trying to improve its performance to no avail. UPDATE TBL_REPORTING REP SET (REP.ISSUER_ID, REP.ISSUER_NAME ) = ( ...
0
votes
1answer
51 views

Reoganize Objects in OEM - Host Credentials do not have enough privileges

When I try to re-organize objects from OEM (11g) and enter my host credentials (not "oracle"), I get the message: "An error occurred verifying the host credentials. Make sure the credentials are ...
1
vote
2answers
49 views

How can i fix the Oracle Enerprise Manager error - Agent is blocked?

I have installed OEM 12c and after restarting my oms the agents got the following error: Heartbeat Status : Agent is blocked Blocked Reason : Plugin mismatch found between agent and repository. I ...
3
votes
1answer
282 views

How to separate out individual sql statements from Oracle SQL script for execution from java code

I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code. I am reading this sql script from a .sql file and the script contains statements such as create table, ...
2
votes
3answers
80 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
2
votes
0answers
59 views

How to distribute a given database between multiple DBMS on a LAN? [closed]

Given a Database D, i need to distribute it over different DBMS in a LAN. D will be split into tables, and each DBMS will store a given table. Here is a sketch of what i need to do : I also need to ...
1
vote
0answers
66 views

How to display '0' where no data found in PL/SQL Oracle Reports

I have an Oracle Report (11g) in which I have selected a number field containing amount and have mentioned the format mask as 999,999,999,999. The data is displayed as follows. Data1 ...
1
vote
1answer
51 views

Oracle temporary table usage with XA

I'm confused about the compatibility of Oracle XA with global temporary tables. I've read several places on the internet and in the oracle documentation that say "Distributed transactions are not ...
0
votes
1answer
126 views

Efficient way to perform approximated search?

I have to perform a join between table_a and table_b, using three fields as key being one of them the date of the event, say, both tables have id1, id2 and evnt_time for eache record. As it happens ...
4
votes
1answer
337 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
1
vote
0answers
80 views

automating oracle database installation on windows

I'm trying to install oracle 12c database on windows using the silent install with a response file as: setup.exe -silent -responseFile file.res where I generate the response file using the gui and ...
0
votes
1answer
72 views

Different time in different sessions

I am connecting to same db from 2 different machines using SQL Developer and querying a table which stores timestamp. But to my surpise the time value returned by query has a gap of one hour on ...
0
votes
1answer
634 views

How to recreate or restore Corrupted Data Files in Oracle 11g

Few days back ago my power cable went down and I was working in Oracle. So after power cable restoration when I tried to login to SQL PLus: It did not let me to login and I got error "Oracle ...
0
votes
0answers
51 views

Oracle apps DBA

ORACLE APPS R12: Could you help me any one on this issue: i am able to open all the forms except order management:sales order form(version: apps R12). Here you go below are error description and ...
4
votes
2answers
5k views

Oracle - Automate Export/Unload of Data

Oracle SQL Developer has an option to export the contents of a query result to various formats (CSV/fixed width/Excel/XML). Is there any way to automate it? If not, what free tools are available ...
1
vote
1answer
463 views

Fixing wildcard expansion resulting in too many terms error (DRG-51030)

How can I resolve the wildcard_maxterm problem in Oracle 10g? My index creation syntax is: begin ctx_ddl.drop_preference('SUBSTRING_PREF'); end; / begin ...
0
votes
1answer
126 views

Oracle strong ref cursor with dynamic sql

I'm using Oracle 10g. I have a query in a stored procedure that selects entire rows from a table. Currently it returns a strongly typed ref cursor (tablename%rowtype). Now I have to add some dynamic ...
0
votes
3answers
46 views

How to mirror the privileges of an user to another in Oracle Database? [duplicate]

I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB'). Is there such an Oracle command (11.2.0.3.0)?
0
votes
2answers
758 views

Oracle query is slower the second time

I have a general question about something I'm seeing in performance tuning in Oracle. I have a query that I'm testing. It's too big and complex for me to provide a simple example, sorry! (I tried ...
0
votes
3answers
39 views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
0
votes
1answer
156 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
0
votes
2answers
194 views

How to print the information of all tables using Oracle?

I'm studying DDBB and we are using Oracle. Using too much tables can be really difficult for me because I have to remember table1.content2, table3.content1, etc. So because of that, I would like to ...
0
votes
0answers
42 views

export query results to file

I am facing the following issue. I want to execute a query and export all the results in a file. My query is saved as in varchar2 type and i can execute immediate on it and give me all the results. ...
0
votes
0answers
92 views

index usages on table with recursive relationship

we are working on a project that uses jpa and oracle. In this project we have a table with a recursive relation: Create table alarm ( id varchar2(200), ... alarmcode varchar2(50), parent_id ...
1
vote
1answer
34 views

Move Complete ORACLE from one system to another [duplicate]

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. [Oralce 11G Enterprise Edition] Entire ORACLE HOME ( bin , control files, data files ...
0
votes
1answer
88 views

query to search a particular word/string in toad/oracle

I trying to find out a word/string named 'audapro_ind' in oracle database in toad. This word can be present anywhere in column of table, function, procedure etc. in oracle database I tried few ...