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

-2
votes
0answers
8 views

How to connect to Oracle Database using SQL Plus?

I need to connect to a oracle database on a remote host (I have no oracle installed locally) using SQL Plus, I've already installed SQL Plus and looking on the internet got those way to connect but no ...
0
votes
1answer
31 views

Best practices for generating a tnsnames.ora entry

I need to integrate some scripts that export and import data from Oracle databases. They are shell scripts that rely on the TNS name being set up (e.g., scott/tiger@tns). The application owners are ...
0
votes
1answer
27 views

Taking time to create Materialised view becuase of functions in the main view [on hold]

due to one of the function in their side, it taking long time to create a MV but later, they commented it and given to us, but after that, they inserted this function again and now the ...
1
vote
2answers
28 views

Oracle RAC Failover functionality clarification

we are running two node active/active Oracle11g R2 RAC cluster i need to replace public network cables on each node. I am planning to do as given below: Setup: OS: oracle Solaris 11.1 Sparc ...
1
vote
1answer
28 views

du of directories in a diskgroup in Oracle ASM

In Linux, you could run the below on a directory to find the size of each sub-directory: du -sh * When you're in asmcmdin the +FRA disk group for example, how can I retrieve the size of each ...
0
votes
0answers
24 views

table not taking records sequencially [duplicate]

While inserting rows into a table in oracle 10g, the rows are not inserted in the order I am putting them, like for the following inserts: insert into emp values (1000, 'debjani', 30); insert into ...
1
vote
1answer
34 views
+50

Duplicate database leaves orphan archivelog files

I am cloning the production database to another one, lets say CLONEDB, in a regular basis. I am using rman duplicate database script like: run { duplicate target database to CLONEDB FROM ACTIVE ...
0
votes
1answer
50 views

optimizing init.ora oracle database server

Can anybody help me in optimizing my SGA, PGA and other paramters of the init.ora file. We usually have average of 159 sessions on the database server. I think there's some thing wrong with my SGA, ...
-1
votes
1answer
22 views

Testing databasis for learning [on hold]

I just instal oracle 12 c on Virtual Dub. I would love to get some sample of working database I can add in and use - to lear, how SQL works, how can I make an export to .xls and so on. Please, can you ...
0
votes
0answers
19 views

Recurse path from leaf to root? [duplicate]

I have a table structure (in an Oracle 11g database [11.2.0.3.0]) that maps out a folder hierarchy for employee records that looks like this (note: I have to start at the leaf node and recurse up to ...
2
votes
1answer
60 views

Oracle 11g connect overhead

Currently one of our new applications is connecting to an Oracle 11g instance over 30,000 daily (at every user request) via their application server, using the same account. (it will be significantly ...
0
votes
0answers
15 views

Can't check out TFS scripts in Oracle [on hold]

I have created a procedure in oracle using toad. I was able to check-out the procedure i've created and check it back in, but after I logged-out and logged back in oracle, I can't check-out the script ...
-3
votes
0answers
21 views

select for loop result in oracle [on hold]

How i can achieve below result : Procedure GET_Test(i_MatricNo in varchar2, i_Subj_Code IN t_c_subj_code, o_cursor out ...
-1
votes
1answer
34 views

Why there are so much restriction on LONG datatype in Oracle [on hold]

Why there are so much restrictions on LONG datatype in Oracle? Why it is recommended to use CLOB instead of LONG? EDIT Its deprecated and the usage is also highly restricted. Moreover, I am not ...
0
votes
2answers
36 views

Oracle StartUp Issue [on hold]

I am facing the following issue while starting the Oracle instance. SQL> Connected to an idle instance. SQL> SQL> ORACLE instance started. Total System Global Area 1269366784 bytes Fixed ...
0
votes
1answer
28 views

Update does not working while select returns right results

I am trying to execute the query below: UPDATE( SELECT Ord.Completed FROM Product P INNER JOIN Order1 Ord ON Ord.OrderID = P.OrderID WHERE EXISTS( SELECT * FROM Delivery ...
1
vote
5answers
82 views

how to check whether Oracle database is accessed or not?

I am an Oracle DBA. Application owner is asking me when was the last time Oracle database was accessed? How do I find information about the DB usage timeline? I mean, I want to check whether it is ...
0
votes
1answer
41 views

Converting sql into mongodb nosql

I am trying to convert oracle sql into its mongodb equivalent version. create table my_hll as select mod(ora_hash(n), 1024) bucket, max(num_zeroes(trunc(ora_hash(n)/1024)))+1 val from previous_data ...
0
votes
2answers
43 views

Error in trigger: table X is mutating, trigger/function may not see it

Having looked at the following Trigger, still getting the Row 2 error: "ORA-04091: table SUMMITTEST.APL_LOG is mutating, trigger/function may not see it" Please can anyone provide any help in ...
0
votes
0answers
12 views

Get memory in Oracle R Enterprise [on hold]

How can I increase memory for ORE? My server have 10G free memory, but I can't use all of them for ORE. These commands have error: begin sys.rqscriptDrop('clustering_test'); ...
0
votes
2answers
39 views

DESCRIPTION_LIST in tnsnames.ora

How does this work? If I specify an address list, I know I can specify a load balance or failover option to switch the connection to the other address. But in case of various descriptors (DESCRIPTION ...
0
votes
0answers
20 views

how to update 'update trigger fired record's column?

I'm new on this task. I tried to update when I/F table insert after trigger. but it wasn't work.. There is my trigger source like.. create trigger T_ATABLE_I after insert on ATABLE for each row ...
0
votes
2answers
37 views

Oracle custom week of the year numbering based on first Monday of the year

I have following sql for generating dates, I wanted to change week of the year numbering based on 'First Monday of the Year'. Hence numbering would be, 01-05-15 ---> 01 01-12-15 ---> 02 ...
0
votes
0answers
25 views

How to cast as type of a table column?

I have multiple views with union like this: select column1, column2 from mytable union select cast(extcol as nvarchar2(15)), cast(extcol2 as nvarchar2(10)) from exttable But later I change the size ...
0
votes
1answer
59 views

Oracle Package in Data Dictionary that can't be dropped

I've encountered a very interesting problem that I can't figure out how to fix. I have a package that I wanted to create on my database with a wrapped body. I mistakenly omitted the word "BODY" from ...
1
vote
1answer
33 views

HTML entity decoding with oracle DBMS_XMLGEN.convert

Here, I am trying to convert the value, where I don't understand I am going wrong. Your help is highly appreciated! Here I am#44; THis is me there#39;s nowhere else on earth I rather be Here I am#44; ...
0
votes
0answers
24 views

How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?

I've got a table schema in Oracle 11 which is storing records that are linked together. The table schema is roughly like this CREATE TABLE "SOMEDATA" ( "ID" INTEGER NOT NULL, "ITEMNAME" ...
0
votes
1answer
34 views

Access Oracle GTT table data from another session?

I have using Oracle GTT tables with condition ON COMMIT DELETE ROWS. Now i know GTT tables data is only session specific. 1 session cannot see the GTT data of other session in General. But is their ...
0
votes
1answer
37 views

Is there are a way to restore System schema to it's original state?

I've installed Oracle 11g Database Enterprise Edition and my task was to import schemas. I'm totally new so I ran command: imp system/password file=path.dmp full=y And import everything (10 dumps, ...
-2
votes
1answer
41 views

what is the difference between data file and data block in oracle

I'd like to know if there is any difference between the data block which is the smallest logical unit of data storage in Oracle Database and the data file which is a physical file on disk that was ...
2
votes
1answer
46 views

Can you use “RENAME” instead of “FLASHBACK TABLE” to restore a table in Oracle?

Just a general question about flashback and the recycle bin in Oracle. I tried doing this on a demo oracle database I have but the recycle bin does not seem to want to be populated; and I want a ...
-2
votes
0answers
34 views

BashScript to run .SQL file in Oracle Partailly [closed]

I know how to execute the .sql file in oracle using the bash script. But the problem is i have 1 file and everyone is updating the Insert, delete and alter statements on daily basis and I am executing ...
1
vote
1answer
45 views

How to find out the segment behind a corrupted block when the database cannot be opened?

Short Version: alter database open fails with ORA-00600. alert.log and dbv both point out that one data block (type: 6) is corrupted. I cannot select from dba_extents as that requires an opened ...
0
votes
1answer
19 views

Can't create user in oracle

i'm using oracle xe edition at ubuntu 14.04. I'm trying to create a user using my sysdba account but when I type the command create user 'myuser' identified by '******'; it gives the error message ...
0
votes
1answer
60 views

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
0
votes
1answer
64 views

how to convert inner join to where clause [closed]

I have a sql query to retrieve a data from a complex database. Following is the sql query, select * from A a inner join B b on a.a_id = b.a_id inner join C c on c.b_id = b.b_.id inner ...
1
vote
0answers
49 views

Oracle instead of trigger update performance issue

I have a large table containing over 15million records with 4 columns that form a compound key. Because we use a development environment that doesn't support compound keys I was required to create a ...
1
vote
1answer
47 views

What is {Oracle}… {Oracle Off}?

I inherited an old script, that should, as part of a pl/sql routine, create a temporary index for me. I tried it on Oracle 11.2.0.4.0, but it does not accept the options. CREATE INDEX x ON y(gid) {IN ...
1
vote
2answers
59 views

Best approach to maintain a single set of DDLs and DMLs for multiple database type

In our application, we support multiple types of databases namely Oracle, IBM DB2 (both UDB and ZOS), postgresql and So on. Currently we are maintaining separate DDLs and DMLs for each of these ...
0
votes
2answers
77 views

Oracle 12c Express Enterprise Manager on Centos 6.5 is not reachable

I have Centos 6.5, and installed Oracle 12c. As dbca utility says after configuring new db, EM Express should be available on https://hostname:5500/em In fact, it is not. Neither on localhost nor by ...
0
votes
1answer
33 views

Alter trigger Oracle

Does alter trigger hang if a table is locked by some DML operation ? What kind of exception does it throw? Resource busy 0054 or some other exception...? I have tried to reproduce this scenario but ...
2
votes
0answers
79 views

Update all rows

I want to know the most efficient manner to update every row in an extremely large Oracle table for a single column. For example: update mytable set mycolumn=null; or: update mytable set ...
0
votes
2answers
102 views

Restoring an Oracle Backup Properly

I've been trying to do a proper restore of a database for weeks now and I'm convinced that I'm doing something simple wrong. I took a cold backup of the database before an update to an application ...
0
votes
1answer
30 views

Will SQL charset wildcard query work on Oracle database? [closed]

I am trying to run the following query SELECT * FROM GEEKYBRAINS.admin_emp where ename like '[sm]%'; It results in an empty set. The admin_emp table has the following data though. I am running ...
0
votes
1answer
50 views

Large sequence cache in Oracle

There was a situation of 108,368,168 executions along with 7,373s elapsed time for "update seq$ set increment$=:........" statement while loading massive(i.e. populating million rows) data in the ...
0
votes
2answers
44 views

joining same table without a common field

Oracle 11g/SQLPLUS Given single table TABLE with three fields ID, PARM, VALUE, I want to select and group by based on different values of VALUE E.g. ID PARM VALUE id1 accnt France-1 id2 ...
1
vote
1answer
39 views

What's the best practice to avoid collisions in throwaway temp tables?

In SQL Server, I'm used to creating a #temp table for temporary storage in a complex stored procedure. Not wanting to clutter up the system, I DROP the table when done. However, if I do the same in ...
0
votes
2answers
61 views

How to find all schemas where a table has records?

In my Oracle database, I have a number of schemas (users/owners) with similar table structures (about 100 in total). However, some tables are empty in a lot of schemas. Is there a way to find out for ...
0
votes
1answer
56 views

Free universe tool monitoring all database [closed]

Is there any free tool to monitor most popular databases like Oracle, MySQL, MSSQL, PostgreSQL. I want to monitor the real time performance of all the above mentioned databases with a single tool like ...
0
votes
1answer
48 views

Error while migrating SQL Server database to Oracle

I am getting this error message while loading database capture script output in Oracle SQL Developer. The source is SQL Server 2000 and destination is Oracle 11g. java.sql.BatchUpdateException: ...