I'm looking for an Oracle database management tool like sql server management studio. I've searched the internet and found a lot of tools on the following link: http://www.freedownloadscenter.com/Search/oracle.html. But I don't know which one is better. I need a stable and easy-to-use GUI tool for working on windows. ...
It looks like to processed, Oracle.exe and pmdtm.exe are locking tables and preventing loads from running. What are these apps and aside from rebooting the machine, what can be done to clear the lock? select * from dba_dml_locks@sdwt where session_id in ( select session_id from GV$LOCKED_OBJECT@sdwt ) SESSION_ID OWNER NAM...
Someone knows how to get a user's roles in a Oracle SOA 11g BPMN application from a backing bean in a TaskFlow?? I need to know the role of the user in order to activate some fields, my idea is to get it from the backing bean and do something. is there a better way to do this? ...
I have two databases, one is production and second is a test. I want to export from production database and import into test database. My production db contains many users/schema out of which only few (<10) schemas contain actual objects. First time, i did a successful full export and full import into my test system without any problem....
Do you have some hint, a reference, an example of how to integrate Oracle SOA Suite 11g (BPMN or BPEL) security with the ADF TaskFlow's security of the human tasks??? ...
I've got a synonym pointing to a table: -- Create the synonym create or replace synonym my_schema.COLORS_ALL for OTHER_SCHEMA.MV_CAR_COLORS; problem is that I can query this synonym fine: select * from my_schema.COLORS_ALL; however, when I try to use this synonym in a Stored Proc I get an error that table or view does not exist....
Hi, I have taken a sql dump as script from Jdeveloper and trying to create database at other place by running the oracle sql script through command line. When executing, at some place in the script, it is prompting for values like "Enter value for time:" and "Enter Value for p:" what could be the reason and how to prevent this when...
I have an ASP.NET webapplication with an Oracle11g backend using DevArt's Oracle data provider. The application works fine however when producing Crystal Reports, the web Crystal Report viewer renders only the FIRST page and none of the toolbar buttons function (ie: next page, zoom, export, search ...) The Group-tree and Prameters v...
I have a query like this: SELECT X.Y( 'p1', 'p2', 'p3', 'p4', '100') from dual I know what dual is but this part X.Y( 'p1', 'p2', 'p3', 'p4', '100') really makes me wonder. What does this syntaxis mean? Are X and Y tables or what? ...
Hello, After rebooting the server the oracle connection from the Tomcat server times out every night. Prior to the reboot, the connection didn't timeout. Now, in the morning the application throws a JDBC connection error accessing the DB. Restarting Tomcat corrects the issue. I'm assuming that's due to the connections being re-establish...
I'm trying to open a REF CURSOR using a select statement like.... OPEN myREF FOR SELECT * FROM MYTABLE WHERE MYID IN (:Values) USING myPassedInValList; But this only work when myPassedInValList has only a single ID in it. I'm trying to use a list like '1','2','5', etc... Can someone tell me why this doesn't work. I tried to Google...
I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code? ...
Hi I am java professional since last one year, now I like to move with Oracle and preparing for OCA exam. I like to know the combination of oracle and Java in IT market. Being a DBA will my Java knowledge be helpful. Thanks ...
I have already changed the priority of all the processes of oracle to high. It helped to improve the performance ; however, now I/O of my system is bottle neck for my database operation. So, Is it possible to change the I/O priority of oracle process from Normal to high? ...
hi how to do this: select top 1 Fname from MyTbl in oracle 11g ? thank's in advance ...
I've been asked to document an Oracle database. I don't need EER diagrams or anything fancy: a simple printable document with a description of tables and columns will do. However, I'd prefer not to type the column names for all the 79 tables. Is there any tool to extract this information from the database server, possibly with some basic...
Is it possible to know when a stored procedure was last executed? I'm using Oracle 11g. I've got an old app that has many years of procedures in it. The goal is to quickly identify candidates for retirement. Thanks, Mike ...
A lot of the queries in our application involve joins between a large (+ frequently updated) tables with small (+ constant tables). By large I mean > 1 million rows and by small table I mean < 5000 rows. I am looking for ways to utilize some feature/optimization technique in Oracle (not at application layer) so that these joins can be m...
This is a two part question: I would like to know where does Oracle ADF 11g stands as a framework to develop / deploy Web / Java EE Applications as compared to other frameworks. How much is Oracle ADF being used as a framework to Develop Web Applications. I am asking from a perspective that weather there are good job opportunities as ...
What are the advantages and disadvantages of having a single instance compared to multiple instances when multiple databases are intended to be created? ...