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
2answers
4k views

Finding all sql id, sql text, number of executions,execution time between two AWR snap ids in oracle

AWR report provide the SQL information for top 10-20 SQLs, is it possible to get information on SQLs that do not make it to the top list. How do we find all sql id, sql text, number of ...
0
votes
1answer
574 views

Installing Oracle Database 12c in Windows 7, INS-08109 error [closed]

I'd like to learn PL/SQL so I'm trying to install Oracle. I downloaded the 2 zip files and extracted to the same directory. I run the "setup.exe" file and the install GUI starts: In step 1 I enter ...
1
vote
4answers
98 views

What does SQLCODE = -00942 signify?

I am very sorry if I am asking a very basic question, but I googled for this and found no useful info.. Please help me under what sql code -00942 stands for.. thanks in advance.
0
votes
2answers
81 views

How to make a trigger work after a certain UPDATE

I would like to know if it's possible to create a trigger on Oracle that is invoked only when a certain UPDATE is done. For example: UPDATE colors SET tastes_good = y WHERE color_name = 'Apple'; ...
-1
votes
1answer
1k views

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

This error shows up when I try to connect to database string host:port/servicename.
0
votes
3answers
142 views

Displaying user's password [closed]

I need to know if there is a way in SQL*Plus to display the password of a certain username? At my job, sometimes the developers ask me what happened to their account, and what their password is. When ...
0
votes
0answers
66 views

Equivalent of old style join with new style

Can someone please help me write the following join expression in new style: Select tb1.col1,tb2.col2 from table1 tb1, table2 tb2 where tb1.col1>=tb2.col2 I know that the equivalent of ...
2
votes
2answers
487 views

Query hangs forever at first but works after one day

I have two schemas namely A and B. I regularly copy contents of 10 tables from A to B. Here's is how I do it First I rename the original tables in schema B Then, using SQL Developer I copy the table ...
0
votes
0answers
2k views

'oracle.jdbc.driver.OracleSQLException': ORA-01031: insufficient privileges. (SYS.DBMS_XMLSAVE)

I have this function (written here by someone), placed in the package ENVER.ENCODING_VERIFIER: FUNCTION loadxml_table (p_owner IN VARCHAR2, p_tablename IN VARCHAR2, p_format IN VARCHAR2, p_tmpClob IN ...
1
vote
1answer
71 views

Oracle: force shutdown as root without knowing logins

I am root on a GNU/Linux machine with Oracle 10.2.0.1.0 XE installed. I need to shut down Oracle, but I do not have admin logins to Oracle. How do I as root force Oracle to shutdown? I have a normal ...
1
vote
1answer
22 views

Logically Horizontale-Partitioned Tables

I have two legacy tables, lets call them TableA and TableB. Both of them fall under the same schema design with identical columns, in other words you can union them directly as one table. The only ...
1
vote
1answer
506 views

ORA-12541 error while connecting to oracle express edition 11g

My oracle express edition was working some months earlier. I dont know what i changed in the system, now I could not connect to it. I tried logging in from sqlplus as sysdba and altered the accounts ...
1
vote
0answers
2k views

Oracle restore backup on other server

I have following situation: One server with Oracle has to be backed up and recovered on other Oracle server. Second Oracle DB has the same user/schemas, but with a different older data. I intend to ...
0
votes
0answers
608 views

What problems can be caused by dropping a rollback segment manually?

Oracle version: 11.2.0.1 I have the following error: "Transaction recovery: lock conflict caught and ignored" I can't upgrade my database now. I had a RAC. Removed one node, but the undo tablesapce ...
0
votes
1answer
734 views

ORA-44001: invalid schema

I have a db dump which containts db dump for three schemas for e.g. alpha bravo charlie in one file, exported through EXPDP. now when i am trying to import these through following command: IMPDP ...
1
vote
2answers
7k views

Literal does not match format string error in oracle

I was given a SELECT statement that is running in a Crystal Report to investigate a data problem but when I try to run it against the database I get the error: ORA-01861: literal does not match ...
1
vote
1answer
928 views

Oracle: How can I add ROWDEPENDENCIES to an existing table?

If I have a table t create table t (x var number); How can I modify the table so that it appears to have been created with rowdependencies? create table t (x var number) rowdependencies;
1
vote
2answers
2k views

how to change the default date format in oracle

New to Oracle here, i am working on some assigments but i noticed when i was creating the tables using a script, oracle throws the following error: ORA-01858: a non-numeric character was found where ...
0
votes
0answers
194 views

Installing oracle 9i on windows 7

Is it possible to install oracle 9i on windows 7 32 bit? And where can i download the standalone oracle http server?
0
votes
1answer
891 views

Oracle - how to reference to a field%TYPE using database links?

I have this database which includes a couple of schemas. Say I need to access schemaONE from schemaTWO. To do this, I have created a database link named "DB_ONE_LINK". I am able to access to ...
1
vote
1answer
1k views

OEM Grid Control Template

I create an monitoring template for my database on OEM GC, apply it on somes database and now i want to know what database is using this template. Can someone help me please?
0
votes
0answers
168 views

ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7

Oracle version is : 11.2.0.1 I have created alerting on every error occurring in database, and in this alert log I've found the following errors ORA-13901: Object UNDOTBS01 was not found. ORA-06512: ...
0
votes
1answer
436 views

How to Convert a Table into XML Document

I have a table say SCOTT.DEPT and I want to convert it into an XML document. Is there anyway to accomplish this task? Kind Regards,
2
votes
2answers
622 views

ORA-12899 when creating varchar virtual column based on numeric column

I have a table with numeric column: create table test (a number(2,0)); Next I want to create a virtual column based on column a: alter table test add (b varchar2(3) as ('A:'||to_char(a))); This ...
-1
votes
1answer
94 views

Oracle 11g database server password rollbacks

Hi everyone, I installed oracle 11g Database server in windows 2003 server. I changed the password. It works very well when I start at first. After restarting, the password is not at all ...
0
votes
1answer
282 views

“Table or view does not exist” on synonym

I have a database and a USER administrating it. Then I have an additional USER_APP to whom I granted CRUD access to all tables in my oracle data modeler (and then applied these via generated script ) ...
1
vote
1answer
661 views

Retrieve Data faster from a huge Oracle Table

I have a huge Oracle table ( ttdinv700 ) which contains almost 20 million rows. I am trying to execute the below query, on the table: select max(ttdinv700.t$trdt) from ttdinv700, ttiitm001 ...
0
votes
0answers
63 views

“Oneway” Replication from Oracle DB to TimesTen

currently I'm really stuck into a problem and I not able to finde a nice way to realize that. I need a suggestion to replicate from oracle db (some tables) to a TimesTen. A connection is only ...
0
votes
1answer
153 views

ERP (Oracle) real time backup [closed]

I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so ...
0
votes
1answer
130 views

Table design for departments with duplicate department numbers

How should I define a database table for my company's departments where we have a set of duplicate department numbers used by an upper management tier. dept_id dept_name manager_id ...
0
votes
0answers
226 views

Datalink error when executing remote query

This afternoon i was working with an old datalink defined to transfer data from one database to other. It's the first time i've worked with this 'trick'. We use an specific user to work with the ...
1
vote
1answer
579 views

Field Level Auditing in Oracle 11g R2

I want to enable auditing on some column in a table. I have tested the SYS, Schema and Table level auditing. Guide me or refer me some document to enable auditing on column level.
0
votes
1answer
192 views

Connection problem after a big impdp

This morning i had a weird problem just opening the SQL developer i cannot connect to my database. I checked the log file of the impdp operation launched before (14G), all the data is imported without ...
3
votes
1answer
4k views

SHA-256 hashing in oracle 11g

How can i encrypt or hash a password inside a trigger using sha-256 so that i can store the hashed value in another table using that trigger? Also how can I decrypt it??
0
votes
1answer
78 views

How to fix this error Idk?

how to fix it I am new in Oracle? I tried to connect RMAN and it showed me this error...
2
votes
1answer
542 views

Is it possible to automate the configuration of dataguard broker?

We deploy a number of oracle databases every year and a good percentage of them require a dataguard configuration. I've developed a script which is able to perform the database synchronization very ...
0
votes
2answers
505 views

Unusable index on PK - Oracle DBMS

We are executing a large number of INSERT operations (140k circa) on a table during an ETL process and this error pops out: Caught SQLException for insert into DMALM_USER_ROLES [...] Caused by: ...
0
votes
2answers
292 views

Oracle DB Shutdown issue

Gave command: "SQL> shutdown immediate" to shutdown DB. But it is hung. Also I am not able to connect to DB via PL/SQL Developer. Its throwing error: "ORA 12537: TNS Connection closed
2
votes
0answers
150 views

Does Oracle ADO.NET varchar parameter size influence query plan reuse?

I am considering to apply a fix which will generate constant parameter sizes for (n)varchar parameters. The application is based on NHibernate with the old OracleClientDriver (using Microsoft Oracle ...
5
votes
2answers
5k views

Current isolation level in oracle

How to get the current (default) transaction isolation level in oracle?
3
votes
4answers
6k views

Synchronizing data between MySQL and Oracle databases?

I want to sync data between Oracle & MySQL databases. What is the best possible way to achieve this? Are there any tools/software available? This is not a one-time but an ongoing operation. The ...
0
votes
1answer
128 views

Does Oracle Partition by Reference optimizes join queries

Oracle 11g has a new feature in partitioning tables called partition by reference. I want to know whether Oracle joins (nested-loop-joins or hash-join or ...) rows from proper partitions when joining ...
0
votes
1answer
65 views

Proper drive partitioning in Linux for Oracle

I have a current production physical server running on RHEL and I'm going to be building a new Oracle Linux VM to take it's place. Below is a listing of the existing physical drive partitions. Can ...
5
votes
1answer
45k views

“ORA-03113: end-of-file on communication channel” on startup

I have been reading posts here, on Oracle support, and anywhere else I can find for the last three days and I've given up on this problem... An Oracle database hung. Shutdown of the database sat for ...
0
votes
0answers
1k views

sqlldr: command not found

I have a script which has this command 'sqlldr' which gives me the error sqlldr: command not found when I run this script. I googled and found that people say that this command should be there in my ...
0
votes
1answer
94 views

Timestamp with time zone

Please can you explain the meaning of this sentence! Two TIMESTAMP WITH TIME ZONE values are considered identical if they represent the same instance in UTC, regardless of the TIME ZONE offsets ...
0
votes
0answers
324 views

Multiple Oracle TNS error

I have an Oracle 11gr2 32 bit on windows 2008 32 bit OS 8 gig ram. There is an application running on 6 machines simultaneously that accesses the Database on this Server. I get the below errors in my ...
0
votes
2answers
3k views

oracle active sessions waiting for scheduler

Load on my 11g RAC looks like this: and I don't understand how to get insight into what this "scheduler" wait class is. It seems like "scheduler" that it refers to is the process that runs ...
0
votes
1answer
76 views

Oracle backup and recovery using RMAN

Can some please provide a quick guide for backup and recovery of Oracle 11 DB? I just need to test it very quickly so i don't need something too fancy, but should be scheduled. Thanks in advance.
5
votes
3answers
1k views

Return a fully dynamic table from an Oracle function

I'd like to write a function with two IN parameters where the first one is a varchar and the second a list of varchars. Based on these I want to return a table with varying column amounts and names of ...