Tagged Questions

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
1answer
11 views

XMLDB - Nodes to Rows

I have an application that stores XML as XMLType in a table. This is the first time I'm using XMLDB and XMLType features, and was wondering if I could use the results from an XQuery FLWOR expression ...
0
votes
1answer
9 views

MySQL rapid Data Replication from multiple Databases

I am a Freelance Web Developer but not a Database Administrator at all except basic Database Operations like DML etc. Today I got a client asking me to develop a Web based application but there is a ...
-1
votes
0answers
9 views

Transferring full database to another machine oracle 10.2 xe

We are having oracle 10.2 xe working on windows xp sp3(32bit). We need cloning/copying full database to windows server2008r2 machine(64bit). Any help.
0
votes
1answer
14 views

How to retire a physical standby in Oracle 11.2

I have a production Oracle 11gR2 RAC database with a single node physical standby. Now it has become the time to retire the old standby and pass that role to a RAC on fresher hardware. We don't use ...
0
votes
2answers
39 views

Summarizing Pay Checks Based on Employee's Job Code

What I'm trying to do is summarize an employee's earnings for each job code they worked in for the year. Employees are assigned a job code based on an effective date. I'm trying to line up the job ...
0
votes
1answer
17 views

ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express

I am using Oracle Database 11g Express Edition. I'm on Windows 7-64Bit I get this error when trying to access the database: ORA-01033: ORACLE initialization or shutdown in progress I set up the ...
1
vote
1answer
14 views

can't backup 11.2.0.2 database after catalog upgrade to 11.2.0.4

(main question is 4th) 1. We today have almost all databases running with Oracle 11.2.0.2. Actually we have an RMAN database created (in 11.2.0.2) and a Catalog with user (called RMAN112) 2. We are ...
1
vote
0answers
31 views

Allowing users access to SQLPLUS and to compile PLSQL [duplicate]

As a DBA - assuming my users are knowledgeable with PLSQL and SQL - why would I not grant my users privileges to compile and run their own PLSQL code. We have an MI database environment where the data ...
1
vote
3answers
12 views

Allowing users to compile / run PLSQL and SQL

As a DBA - assuming my users are knowledgeable with PLSQL and SQL - why would I not grant my users privileges to compile and run their own PLSQL code. We have an MI database environment where the data ...
1
vote
0answers
17 views

How to replace empty, multi-column result with single 'none'

If it is possible to make query in Oracle which will return single column/row with value "none" instead of empty, multi-column result? Otherwise return proper amount of columns with result. This is ...
1
vote
1answer
17 views

Is there any way to use “like” operator during oracle table partitioning

I am using Oracle 11g database and I have 45 million records. I want to partition the table, but if it's possible for partitioning to support the like operator then it will be much helpful for me. In ...
3
votes
3answers
36 views

How to raise_application_error beyond a when others clause

Background: I've used a few Oracle articles to develop an error package, with some procedures. One of these is Log_And_Return which is called throughout the database. I've simplified it for brevity, ...
0
votes
0answers
26 views

PL/SQL IDE like C++ compilers [on hold]

Are there IDEs out there like Codeblocks that can help debug syntax errors in PL/SQL scripts? I am currently using Oracle XE and trying to create a PL/SQL script.
-3
votes
0answers
28 views

how to open 'sql*plus' in the oracle terminal [on hold]

how to open 'sql*plus' and 'oracle developers' in oracle enterprise manager cloud 12c.ova in vbox? i dont have much knowledge in the linux just basics. how to open sql pus through terminal or any ...
-1
votes
0answers
24 views

Database status unknown error when will it occurs and reasons? [on hold]

database status unknown when will it happens and what are the particular reasons of this status? how to rectify the db status unknown?
0
votes
0answers
55 views

Query that can pick up data that falls between rows having unique parameter [on hold]

Suppose a table has data in the following format: Id Name ----------- Main Abc Check Def Check Ghi Main Jkl Check Mno Check ...
0
votes
0answers
14 views

Why does dmbs_xmlgen.convert only decode some entities?

I'm trying to decode html containing html entities. For example: SET ESCAPE ON; SELECT dbms_xmlgen.convert('\♥', 1) AS hearts, dbms_xmlgen.convert('\&', 1) AS amp FROM dual; ...
0
votes
1answer
30 views

Linking Oracle 10g XE with SQL server using ODBC

I am connecting Oracle 10 XE with an SQL server 2008 using ODBC in windows 7. I have successfully done following steps: Configured ODBC and test it, runs ok! Configured listener in tnsnames.ora and ...
0
votes
1answer
23 views

ORA02063 error while connecting to remote databse

I have connected to remote database using DB link. From prod databases it works fine but from test env reporting error invalid username/password. Please help.
-2
votes
0answers
30 views

DBA MySQL experience [closed]

I am in a programming class (Python) as well as a database concepts class. I'm also taking an HTML/CSS class. I knew HTML years ago, but much has changed in 10 years. I have a good background in ...
0
votes
1answer
30 views

How to design a query that gives count of different parameters based on different condition from a single table

I have a table books containing columns as bookid, issue_date,return_date. Once a book is issued from library an issue_date corresponding to it is made into the table while return_date can have valid ...
0
votes
1answer
23 views

Oracle Missing Comma error on check constraint

I'm attempting to create a table in Oracle, but keep getting the "ORA-00917":missing comma error at the end of my first constraint (P_IMAGEFILE_CHECK). I've tried adding and taking away commas but ...
0
votes
0answers
28 views

Confirm Oracle Batch Update When User Clicks OK [migrated]

How do I commit an oracle transaction (update many rows) AFTER user confirms an update?. The sequence of events would go like this: User selects rows from grid to batch update and clicks > GO oracle ...
0
votes
1answer
28 views

Constrain Partial Values in Timestamp

I'm working on a some Create Table statements for a project I have. I have two columns (StartDate, EndDate) where the data type is Timestamp. One of the requirements is to ensure that the date is ...
0
votes
1answer
40 views

Split column into 2 column oracle

I have a data like this AIN ACCEPT_TYPE DATE1 91957753 A 04-NOV-14 12.50.31 PM 91957753 R 06-NOV-14 11.18.01 AM 919577 A 04-NOV-14 12.50.31 PM 919577 A ...
0
votes
0answers
24 views

ERLANG ODBC giving core dump [closed]

Trust you are doing well I am facing a serious issue on my production environment. My Erlang odbc application is giving core dump on uncertain intervals. Whenever I trace the core using dbx it always ...
0
votes
1answer
34 views

Data are not saved to database - Auto creating new datafile in oracle

I have some problem with Oracle database. Before it works like that, if INDX[Counter].dbf file reach its maximum size (8GB) Oracle automatically created new datafile INDX[Counter+1].dbf. But on server ...
1
vote
2answers
66 views

Are there any special characters that are never allowed in SQL?

I am a Java programmer. We always make database-related things configurable so that they can be easily modified by the DB team as per their requirements. I want to make some queries as configurable, ...
0
votes
2answers
51 views

my oracle db won't open please help

This is what happens when I try to query as DBA: SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys ...
0
votes
2answers
50 views

How Datapump is faster than export/import backup? [closed]

Why is datapump export faster than exp?
0
votes
0answers
15 views

Oracle 11g - Matrikon opc server

I need to connect MatrikonOPC client for ODBC with an external database on Oracle 11g in a Windows Server 2003. This is for passing information to the database. I have all the info of the database. ...
0
votes
2answers
88 views

Oracle Database 12c on Oracle Linux 7 - autostart, enabling connection as sysdba

I've installed 12c on Oracle Linux 7 for my development work, as per document Oracle Database Installation Guide 12c Release 1 for Linux (E41491-10). My previous experience with administering Oracle ...
0
votes
2answers
40 views

Can I use a Synonym to point to an object in a schema using another schema?

I don't have too much experience in Oracle, so I am sorry if this is a simple question. I have to move many objects in the database from one schema to another. I am trying to update all dependencies ...
0
votes
1answer
55 views

Oracle Database Client 11g R2 Installation Types, which components?

I need to know which component is under each installation type! Instant Client Administrator Runtime Custom (No need as it shows all the components) ALSO? does it includes ODP.NET? is it the ...
2
votes
0answers
87 views

Failed to drop column - value too large

I'm trying to remove column from DB and got a strange error: Error starting at line 147 in command: alter table config drop column dte Error report: SQL Error: ORA-12899: value ...
0
votes
1answer
34 views

Exadata RMAN vs. Non-Exadata RMAN - any differences?

Can you please let me know the differences, if any, in the architecture of the non-Exadata RMAN vs. that of the Exadata-RMAN from an SBT plugin perspective? Have you observed from your vast ...
0
votes
1answer
36 views

Oracle Nested Query with Group By and Having Clauses

So here's the question Find the IDs of aircraft which have flown more distance for a destination than the average distance of all flights for that same destination Here is the schema ...
0
votes
2answers
33 views

glogin.sql supress error when Instance Idle

I have a pl/sql block in my glogin.sql file to show information from v$instance when I connect on the database server. Is there a way to suppress the ORA-01034 we would naturally get when the ...
0
votes
2answers
57 views

Slow import for users .DMP files in Oracle 11G

After upgrading my DBMS Oracle 10g to 11g, when it will import user files, they are slower than the old version. A .DMP file in Oracle 10g with the size of 20GB takes almost 1 hour to import, but ...
-2
votes
1answer
36 views

opening_database

When I try to create user in the sqlplus, it raises an error at line 1 ORA-01219: database not open: queries allowed on fixed tables/views only. How to correct this error? Please help me out.
0
votes
3answers
59 views

Active/current (1-5%) and historical records in same table: index or partitioning?

I am trying to discover the correct architecture for the following situation. An application stores 'source data' in multiple tables. Each of these 'source data' tables contains actual, current, ...
0
votes
2answers
24 views

Add ENum Attribute to existing table using Alter

I am using oracle XE and trying to add a attribute that restricts to only three available value 'Small','Medium','large' to an existing table using Alter Table and Enum. Tried doing, ALTER TABLE ...
0
votes
1answer
38 views

Oracle Enterprise Manager - top activity

I'm looking at the Top Activity view in OEM. The left axis is labeled "Active Sessions" (up to 24 in the graph I'm looking at) and there is a line labeled "Maximum CPU". The measured activities ...
1
vote
3answers
57 views

Oracle static lookup table

What is the best approach (or what options am I not aware of) to creating a static table or view where the data rarely, if ever, changes? An example use-case is a list of US states, where my ...
0
votes
3answers
38 views

Upgrading Oracle from 11.1.0.6 to 11.2.0.2 on Linux Red Hat

I am trying to upgrade the Oracle db from 11.1.0.6 to 11.2.0.4 in Red Hat Linux 5.3. The current database is installed on location. I checked the path using command cat /etc/oratab ...
0
votes
1answer
20 views

Keeping messages in a backup table after dequeue is completed

I would like to transfer the enqueued messages to a backup table after they have been dequeued. Currently we are using DBMS_AQ.DEQUEUE with mode dequeue_mode := DBMS_AQ.REMOVE. So after the message ...
1
vote
0answers
34 views

Database recommendation for load of 100M rows [closed]

I am currently using mysql databases for storing and processing 20M rows, now I want to move from processing volume of 20M to 100M rows. I am thinking of going for Oracle database, Please let me know ...
0
votes
1answer
19 views

Connect by prior - multiple fields and query efficiency

I have 2 tables one of which defines the hierarchy for the other equipment id desc 1 item1 2 item2 3 item3 4 item4 5 item5 6 item6 7 item7 8 item8 ...
0
votes
0answers
26 views

SQL Loader data load in multiple tables

I have a question regarding SQL*Loader : We are loading 40 tables from external files using sqlloader; if data load fails and only 30 tables are loaded, is it possible to start load from 31st table ...
0
votes
3answers
50 views

Which version is the right one to begin with Oracle [closed]

I see many versions of oracle 8i , 11g and 12c. I am familiar with SQL Server 2012 and SQL. Which version of Oracle should I start with?