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) ...
0
votes
1answer
7 views
trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing:
Connection conn = //create connection
//open connection. No errors/warnings are ...
1
vote
0answers
28 views
Unable to recover database
How to resolve this issue, I am getting this error, when I'm trying to open my Oracle Database
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: ...
0
votes
2answers
33 views
How to set Proxy Settings when installing Oracle 11g on Windows 7 Ultimate Edition?
I have downloaded the file - "win32_11gR2_database_1of2.zip" from oracle site.
While installing Oracle 11g, I find this window in the first place:
What to do?
What values should I put on the ...
1
vote
1answer
68 views
Find who and when changed a specific value in the database
We recent found some record in a table of an oracle database has been updated to another value.and it has been cause very important mistake.
we want to find out who and when has done this?
could ...
1
vote
1answer
53 views
Is it possible in Oracle to trace SQL statements that result in errors?
We have Oracle 11g in production. Application system is still under active development. It will be very handy to get SQL statements which cause any error.
Does Oracle provide a standard function to ...
1
vote
2answers
69 views
Oracle SQL, how to filter on a set by a rank?
I am struggling with the following SQL query right now:
http://sqlfiddle.com/#!4/736a7/12
select uc.*
from usercredential uc
inner join users u on u.userid = uc.userid
inner join credential c on ...
0
votes
1answer
71 views
How to permanently delete a row in oracle forever [duplicate]
I want to delete a record from a table and no one should ever be able to recover the deleted data.
I have done delete operation but the record is still in the undo segments. And one can do flashback ...
0
votes
0answers
23 views
Exporting and importing a database
I have setup an Oracle 11g Database and have a question about exporting and importing a database.
I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...
1
vote
0answers
49 views
How do I execute an Oracle SQL script without sqlplus hanging on me?
For an automated task I would very much like to run some SQL scripts and make sure that sqlplus does not hang under any circumstancees, i.e.:
If the script contains any named substitution variable ...
-1
votes
0answers
36 views
Oracle grant role to another role problem
I have created a role named parent_role and granted select privilege to a table named tbl for example.
Then i created another role named child_role and granted parent_role to it:
grant ...
1
vote
1answer
20 views
How to disable oracle's MAX_ENABLED_ROLES limit
How to disable oracle's MAX_ENABLED_ROLES limit or expand the value of limitation. [oracle 10g (win32)]
0
votes
4answers
82 views
How can I convert an Oracle dump file into SQL Server?
I want to ask about converting Oracle dump files (.dmp) into SQL Server files (.bak) where during conversion I don't have to be connected to any database server.
I've searched for related ...
1
vote
0answers
33 views
impdp failing with ORA-01031: insufficient privileges
I'm trying to import a dmp file provided by our dba to my dev database. I've been able to export the contents to a SQLFILE and the contents look ok. I tried importing the schema and it kept on failing ...
1
vote
2answers
42 views
How to check if Oracle DB process is running in Unix and where Oracle DB is installed
I am new to Unix and trying to find out a command that checks if Oracle DB is installed in my Unix box. I came across commands ps -ef|grep smon and ps -ef|grep pmon in net. But which is the correct ...
1
vote
1answer
78 views
Multiple like conditions for same column?
How do I write a query for a Oracle database when I have several "like" values for the same column (in my example data "name")?
My example data for table "address":
name like "John"
name like ...
