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

1
vote
1answer
907 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;
0
votes
0answers
190 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
415 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,
0
votes
0answers
166 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: ...
1
vote
0answers
556 views

whats the fastest way to copy data from table to new one?

Whats the fastest way to copy table "table_1" to new table called "table_2" ? I'd like the constraints copied as well as the data.
2
votes
2answers
605 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 ...
0
votes
1answer
249 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
286 views

Reorganize 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 ...
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 ...
1
vote
1answer
646 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
1answer
148 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 ...
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
2answers
203 views

Database is slow once in a while

I am executing a web service for 100 times. The average response time of this service is 1.5 seconds. But when I look at the response time of each execution individually, there are a few executions ...
0
votes
1answer
188 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 ...
0
votes
0answers
220 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
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
1answer
123 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
2answers
494 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: ...
1
vote
1answer
550 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
2answers
284 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
146 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 ...
0
votes
1answer
124 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 ...
2
votes
1answer
326 views

How does Oracle 10g use indexes?

I have table called result: CREATE TABLE result (id_graduate NUMBER NOT NULL, id_sml NUMBER NOT NULL, last_update DATE NOT ...
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
93 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
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.
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
189 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
1k views

sqlplus startup - failure in processing system parameters

I am trying to do the startup command this is what I have done set oracle_sid=ORCL sqlplus /nolog SQL> conn /as sysdba startup It shows this error message, failure in processing system ...
0
votes
0answers
320 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 ...
2
votes
1answer
71 views

Sometimes getting quotes in Oracle spool sometimes not

Using Oracle SQL Developer, I do: spool c:\temp\file1.csv select /*csv*/ id, version, key, pattern, name from mydatabase.edition; spool c:\temp\file2.csv select /* csv */ id, version, amount, item ...
0
votes
0answers
129 views

Oracle: REGEXP functions hang with “DIRECT PATH READ”

Oracle 10.2.0.5 OS: Solaris Problem: Need to filter a table with REGEXP. Occasionally sessions that execute Regexp on multiple rows hang on if SQL contain like: "where id in (1,3...) or id in ...
1
vote
1answer
294 views

Pl/SQL web application

I have a PL/SQL web application,got the entire DB dump from remote DB. Its very old application, running on oracle 9i. I basically want to get the application up and running on my laptop,but i am not ...
0
votes
1answer
52 views

What does this TRIGGER do? [closed]

I have this trigger in DB2 that I need to convert to ORACLE, but I don't know how it works in DB2 so i can translate it to a ORACLE one, I think it doesn't do anything. CREATE TRIGGER ERRLOG_TRIGGER ...
1
vote
1answer
357 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
46 views

Oracle Autodop disabled at the table level

I have a question related to Oracle auto DOP and parallel DML concepts. I have a scenario, if I set the Auto DOP set to 1 on the table and if I run parallel DML statements on that table through ...
1
vote
1answer
236 views

Concept, ER model, “employee tracking”

I have to achieve 3NF with following specifications: Database where I will determine priority skills for specific jobs and track the employees ability to complete them. Train employees. Example of ...
1
vote
0answers
189 views

Move data from a Greenplum database to Oracle

my company is migrating its Data Warehouse from Oracle to Greenplum. The migration is gonna be progressive, that is they will migrate the ODS first and at a later stage the DDS as well. I would like ...
0
votes
1answer
57 views

Database Configuration In DB2 and Oracle

what is the equivalent in Oracle for these field (taken from DB2)? Interval for checking deadlock (ms) (DLCHKTIME) Lock timeout (sec) (LOCKTIMEOUT) Thanks,
0
votes
0answers
31 views

How can I calculate database disk usage in Oracle? [duplicate]

I'd like to get the real disk usage of a database, i.e. the amount of megabytes or gigabytes (could be any) that the tables use with all of their respective rows.
1
vote
0answers
83 views

Amazon RDS for Oracle Offsite Backup

Am considering Amazon RDS to host our Oracle database. Ideally, I'd like to have my daily backup and as many of the transaction logs as possible since copied to an external location in case of Amazon ...
2
votes
1answer
17k views

How to run procedure in Oracle SQL developer

Hello I have a table named CITY in oracle SQL developer, my problem is how to run the procedure -- start the script SET SERVEROUTPUT ON SET LINESIZE 400 SET TIMING ON CREATE OR REPLACE PACKAGE BODY ...
0
votes
0answers
54 views

Logical or in oracle PL/SQL

I have this code: declare error1 number; error2 number; error3 number; begin error1 := 1; error2 := 0; error3 := error1 | error2; -- should be error3 = 1 end; But I dont know how to ...
0
votes
1answer
1k views

What does enable mean in Oracle DDL constraint?

My understanding is the different between NOT NULL and NOT NULL ENABLE is that the later will also be be applied to existing data in the table. If then you are starting from scratch is there ...
0
votes
1answer
6k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
1
vote
1answer
497 views

How to check Oracle database connection encryption type

How to check the Oracle database connection encryption type?(between Oracle database and other client applications)How do I assure between Oracle database and Toad the database connection is ...
0
votes
1answer
81 views

How do I resolve “ORA-23293: Cannot rename a column which is part of a join index?”

Disclaimer: I am a developer, not a DBA, but this question seems more appropriate for DBAs than for StackOverflow. Now to my question: We have a table in an Oracle Exadata schema that uses a numeric, ...
0
votes
0answers
4k views

ORA-03137: TTC protocol internal error

I have 11g 2-node RAC. My alert.log contains several ORA-03137 errors: Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362): ORA-03137: TTC protocol ...
1
vote
1answer
127 views

How can I delete rows in an oracle table from xml input parameter?

> CREATE OR REPLACE PROCEDURE PRC_OPEN_PERIOD > ( InputXml in VARCHAR2,Tmode in varchar2,pOUT OUT number ) > IS > v_count NUMBER(38) := 1; > v_inner NUMBER(38) := ...