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

Oracle alternative edition for Windows Server 2012

Does Oracle 11.2 support Windows Server 2012? Any alternative for Windows Server 2012 with respect to Oracle editions? I checked in internet but their forums, and this question says its not ...
0
votes
2answers
1k views

Cannot connect to database remotely (not even locally when using ip address)

I can login using this command: sqlplus test/test@127.0.0.1:1521/local But not this one: (where 192.168.0.240) is my IP sqlplus test/test@192.168.0.240:1521/local I am absolutely sure that my ip ...
5
votes
1answer
295 views

Should I group by and then join, or join and then group by?

(oracle's optimizer does the same thing for both approaches when just two tables are involved, thus my question involves three tables) Assume three tables t1, t2 and t3 with a pairwise 1:n ...
0
votes
0answers
404 views

migrate APEX to a new database with newer APEX version?

what is the best approach to migrate an APEX app to a newer version of APEX (4.2.3) on a fresh installed database on a new server? is there any straightforward step by step? I never done that before! ...
2
votes
4answers
2k views

How to find index organized table

I'm working on Oracle 11g database and I need to list all index-organized tables. Is there a dba's view to query for that ? Thanks
1
vote
1answer
3k views

What is the purpose of setting serveroutput in oracle? [closed]

Could someone let me know what is the purpose of using set serveroutput on/off in oracle? I ran the below query to see what it is doing. However I need to know much about serveroutput. Kindly help me ...
1
vote
2answers
148 views

Strange Oracle ORDER BY

I have a problem sorting strings in french : This is my query : SELECT LIBELLE as LibelleCourant, CODE as code FROM S_MARQST ORDER BY LibelleCourant; And this is the result LIBELLECOURANT ...
1
vote
1answer
193 views

Slow join behaviour with 'or' in predicate

I'm faced with a situation which I can't understand and overcome. In short we have left-join query like: select from a left join b on a.key1=b.key1 or a.key1=b.key2 This works VERY slowly, while ...
4
votes
2answers
302 views

Oracle 11g XMLType Experience

We are currently evaluating possibilities to store generic data structures. We found that at least from a functional point of view Oracle XMLType is a good alternative to the good old BLOB. Because ...
1
vote
1answer
760 views

Audit select queries against specified tables by specified users

I have a requirement to audit all SELECT queries (by access) against specified tables by specified users. As far as I can tell, this can't be done with normal auditing; it only supports auditing all ...
0
votes
1answer
43 views

Create table reference foreign key

I'm trying to create a table referencing a primary key from the table person; CREATE TABLE Membership (foreign key (USERNAME) references Person(USERNAME),MembershipNo INT Primary Key,DatePaid date ...
0
votes
1answer
94 views

Oracle_Loader Quote in quoted field

I have a create table ext_file (....) type oracle_loader query that opens a text file to pull data out of it. The access parameters are: records delimited by newline fields terminated by '\t' ...
0
votes
2answers
984 views

Which SQL Developer Version will be compatible with Oracle 9i

My Company is using Oracle 9i. I want to connect to the database. I'm planning to use SQL Developer. Which version will be compatible Oracle 9i?
2
votes
2answers
6k views

Oracle 11g: LRM-00109 followed by ORA-01078 when using PFILE created by SPFILE

I know this is long, but please bear with me - I think the background info may be important. OS: Windows Server 2008 R2 64-bit DB: Oracle 11g 64-bit Enterprise Edition Yesterday evening we had to ...
0
votes
1answer
456 views

Export Data Pump all data from few schemas except one table structure only?

we use to make a copy of schemas from one database and move it to another for testing using this par file ... DIRECTORY=EXPORT DUMPFILE=QQS_PROD.DMP LOGFILE=QQS_PROD.LOG ...
0
votes
2answers
300 views

Query gets slow when bind peeking is turned on

There is an old database that was upgraded from Oracle 10 to 11G R1. In Oracle 10 we had disabled bind peeking. Since Oracle 11 has adaptive cursor sharing, we want to turn bind peeking back on. When ...
2
votes
2answers
649 views

When is it appropriate database design to use a separate schema?

I am developing a database which has data sourced from many different applications. In my first pass at design, I placed the staging tables each in a schema named for their source application. As ...
0
votes
1answer
689 views

Install Oracle 11gR2 driver for Node.js 0.10.20

I want to connect Oracle 11gR2 and Node.js 0.10.20. I use this package but I don't understand this part of installation process. Can you explain it to me? # Replace /opt/instantclient_11_2/ with ...
0
votes
2answers
413 views

“sqlplus as sysdba” startup error

My setup: Oracle 11g 32G RAM 8 CUP threads Three oracle instances have been running. But running this: sqlplus "/as sysdba" gives me a prompt: Connected to an idle instance. When I issue ...
3
votes
1answer
243 views

What is Required to use Oracle Performance Manager to monitor SQL Server?

I am working with a customer who has several SQL Server and Oracle DBMS server instances. My customer would like to setup up performance data collection, monitoring and alerting for all of their ...
1
vote
2answers
86 views

A Separate Oracle Database at work

I recently started working at a company (Junior Web Developer) and so far loving it. The company's all and only database is one giant Oracle database that takes care of all their data persistence ...
0
votes
1answer
2k views

Oracle 11g Enterprise downgrade to Standard One

I'm checking possibilty of downgrade Oracle 11g from Enterpise Edition to Standard One edition. I've cross-checked edition comparison with select name from dba_feature_usage_statistics where ...
1
vote
2answers
52 views

Decode everything that is not defined as 'internal' or 'Web' to 'external' (oracle)

I'm trying to decode a columns with about 30 different possible values down to 3 values. I want the decoded value to be "internal" if the original value is "Interal KS & others", or "Web" if the ...
-1
votes
1answer
226 views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
1
vote
2answers
9k views

How to move csv file into oracle database using sql developer?

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?
0
votes
1answer
863 views

Oracle: how to set only some roles as not default for a user (no GUI)

Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 in instancA has four roles grante to it: ROLE1 default yes admin_option no ROLE2 default false ...
0
votes
1answer
68 views

How to treat a row as a table

I have two tables with the following structures: CREATE TABLE USERS ( USERID VARCHAR2, USERNAME VARCHAR2 ); CREATE TABLE CONFIRMATIONS ( PERSONELID NUMBER, ACCOUNTING VARCHAR2, FINANCE ...
1
vote
1answer
84 views

Mysql, sql server, oracle tables get too large [closed]

I hear a lot about things that, it is a lot cheaper to buy new harddisk than pay staff to come up with genius ideas how to save resources. But what I don't understand, is how these databases handle a ...
0
votes
1answer
483 views

Oracle GoldenGate add trandata errors

I am trying to add trandata to GoldenGate from SQL Server 2008 r2. I am getting an error stating . ODBC error: SQLSTATE 01000 native database error 16954. [Microsoft][SQL Server Native Client ...
1
vote
2answers
267 views

Get a number nth bit value in oracle

How can I get nth bit value in oracle database? I am currently using this query: WITH a AS (SELECT 7 val FROM DUAL) SELECT CASE BITAND (a.val, POWER (2, n-1)) WHEN 0 ...
2
votes
1answer
5k views

Cannot set MEMORY_TARGET for Oracle 11.2

I'm trying to configure an Oracle installation on a developer machine (Windows 7 Professional 64bit). The machine has 16GB of RAM and I'd like to configure MEMORY_MAX_TARGET to 8g but have ...
0
votes
1answer
403 views

how to clone or mirror oracle asm disks to new sets of disks

We have EMC CLARiiON disks/storage arrays that are near their end of support life cycle, so we need to move Oracle ASM disks on them to a new sets of vendor disks. We are trying to minimize the ...
0
votes
2answers
175 views

How to fetch file path from a folder through PL/SQL

We upload files on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible. If possible, please suggest what ...
-2
votes
1answer
32 views

Is there any way to know all the tables(and/or views, triggers, functions) present in the Oracle 9i database?

I want to know this because, I forgot the name of the table I created Using Oracle 9i Thanking you for your time.
1
vote
1answer
224 views

Recover oracle 10g database from old data files

I have an Oracle 10g database. Unfortunately, our machine and system crashed and all the backups and Oracle archive logs, but we have old image copies of our data files and one of the control file ...
1
vote
2answers
770 views

Oracle's UTL_FILE when connected locally or through listener has different behaviour

We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) Until now, we were storing that CSV file into system oracle (the oracle owner) user home ...
0
votes
2answers
174 views

Unclear oracle problem with getting response of query

The problem is very unclear, I have an application server, that constructs queries and sends it to Oracle to get response. The Oracle database is installed on a high perfomance server: Linux ...
-1
votes
2answers
3k views

How do I determine the licensing cost of Oracle Standard Edition for HyperV instances? [closed]

I'm confused by Oracle's licensing for their Standard Edition. My understanding is that licensing for the Standard Edition is determined by the number or physical processors (actual chips, not cores) ...
0
votes
1answer
660 views

Oracle: Tables and Views missing from the all_objects dictionary

I have a couple of database instances that are having the curious issue where tables and views do not show up in the all_objects dictionary which is causing some issue with certain schema viewing ...
0
votes
2answers
259 views

Backup Oracle DB using TSM server version 6.3.0

I'm new to Oracle and TSM server. I installed Oracle11gR2 and TSM server version 6.3.0 (linux Centos 6.4 OS). I did the configuration and everything works fine. so far I arrive to run the following ...
1
vote
2answers
131 views

Audit table insert restriction

So I'm trying to create my own audit table for some user management analysis and stumbled across a little problem. I use this trigger CREATE OR REPLACE TRIGGER usr_t_audit_user_alnd AFTER LOGON ...
1
vote
1answer
67 views

recover oracle db from datafile

We have oracle db which unfortunately we did'n make backup and all control files and other files except all data-files are damaged. Is there any solution to recover db from all of these intact ...
0
votes
1answer
545 views

Connecting to remote oracle db

I am very new to system and db admin stuffs. Infact, I need to have my skills more improved in those areas. Anyways, I was trying to connect to a remote oracle database and use php oci8 library to ...
2
votes
1answer
117 views

Backing up Oracle home directory while instances are running

Can I take a backup of Oracle home directory (with cp -r) before upgrade while the instances using the home are running or is it required to shutdown instances first? Trace files/alert logs are in ...
1
vote
2answers
2k views

Oracle query is slower the second time

I have a general question about something I'm seeing in performance tuning in Oracle. I have a query that I'm testing. It's too big and complex for me to provide a simple example, sorry! (I tried ...
2
votes
3answers
4k views

Find rows where any column matches a search pattern

I have a table "Test" with 15 different columns of different data types. I'm looking for rows having characters like "ABC". But "ABC" can be present in any column and I want to find whole records ...
1
vote
2answers
70 views

Optimizing UDF - Is Using DUAL Expensive

I am new to Oracle technology (primarily versed in SQL Server) and I am having trouble with the performance of a UDF. The purpose of the UDF is to take some inputs for an "event", and look up an ...
3
votes
2answers
242 views

Is it good practice to check for existence of records before deleting them

I've came across the following SQL/PLSQL while investigating a stored procedure written by someone else: 1. V_COUNT NUMBER(5,0); ......... 2. SELECT COUNT(*) INTO V_COUNT FROM TABLE1 WHERE ...
3
votes
1answer
172 views

How to become a DBA…the non-standard route (not beginning as sysadmin or dev)? [closed]

Background: I'm a recent BS graduate who's found myself in an extraordinary situation. I've fallen into something of an entry-level Oracle DBA role straight out of the college box. At my small ...
2
votes
1answer
2k views

Oracle 10g: Optimizing an update query that uses a subquery

I have the following query within a stored procedure, and I've been trying to improve its performance to no avail. UPDATE TBL_REPORTING REP SET (REP.ISSUER_ID, REP.ISSUER_NAME ) = ( ...