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
175 views

Mistake during Oracle 11g PITR

I tried using set time until.. and mis-typed the date. Can anyone help me understand how to get my backups into a manageable state? After the accidental recover, most of my backupset disappeared. I ...
4
votes
2answers
2k views

How to remove all hidden parameters from Oracle Database

How do I remove all hidden parameters from Oracle Database before upgrading? I'm using the SQL query below. So what do you recommended? SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ...
2
votes
1answer
110 views

What's the most appropriate NLS_SORT parameter to cover all/most European languages?

I'm developing an Oracle 11g-based application which is likely to be used by clients in many different countries (mostly European). I want the program to change its NLS_SORT so that it's case ...
1
vote
1answer
815 views

Oracle RAC 11g R2 DB silent install: parameter needed for system class

I'm installing Oracle RAC DB 11gR2 using response file and silent mode. The installation is failing with the error message: [INS-35421] This options installs a single instance database only You ...
0
votes
3answers
142 views

Built-in XML functions

I am trying to use built-in XML functions, but I'm getting an %s: invalid identifier error. Selects works fine without the XML functions. Any ideas where is the mistake? select id,full_name from ...
2
votes
2answers
4k views

User Password Expiry date

Is it possible to find my password expiry date without asking the DBA? My user does not have privileges to view the DBA_USERS table. Also, I tried select * from USER_USERS table, but expiry_date is ...
2
votes
1answer
361 views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
4
votes
2answers
273 views

General tool to load dump files

I am a big fan of Postgres both for its price but also for its features. I am going to have to need to upload into it both Oracle dump and SQL Server files. I will try to ask and beg for plain .csv ...
2
votes
3answers
158 views

Oracle error : Shutdown immediate error

echo $ORACLE_SID YBRD conn sys/hello as sysdba SQL>shutdown immediate Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window. Then I again logged in and ...
4
votes
1answer
1k views

Do I need to use NVARCHAR rather than VARCHAR to properly store UTF8 characters in Oracle?

I want my Oracle database to properly store ALL possible UTF8 characters. If NLS_CHARSET is set to AL32UTF8 is that all I need to do? Or do I need to also make sure I use NCHAR and NVARCHAR rather ...
0
votes
2answers
286 views

Oracle 10XE: Stop schemas seeing the all_users table?

I've got an Oracle 10g XE Database that I want clients to be able to view remotely via SQL*PLUS or SQL Developer. Each schema has a name which includes the name of the client, so anyone looking at the ...
1
vote
1answer
326 views

Using a Having clause with an outer join

I want to use a "having" clause with an outer join, using a column that is used in the outer join. This is my query: SELECT I.CARD_BIN BIN FROM GE_ICA_BIN I LEFT OUTER JOIN GE_PAYEE_VALIDATION ...
2
votes
3answers
1k views

Transfer data from DB2 to Oracle

I want to transfer data from an old DB2 system to a new Oracle database. How should I go about doing this?
2
votes
1answer
423 views

Testing AFTER INSERT Trigger

I have the following table: CREATE TABLE Train( Train_No integer PRIMARY KEY, Loco_No integer REFERENCES Locomotive(Loco_No), Back_Loco_No float REFERENCES Locomotive(Loco_No), ...
0
votes
1answer
2k views

Find Underlying Data Type (int - integer) of Oracle Table instead of number

I can create an example table using following syntax. CREATE TABLE "TABLE2" ( "COLUMN_INT" INT NOT NULL, "COLUMN_INTEGER" INTEGER NOT NULL, "COLUMN_SMALLINT" SMALLINT NOT NULL, ...
0
votes
1answer
1k views

User with dba privs can't login to APEX, but can from SQL*Plus

I'm using Oracle 11gR2 XE. A user with dba privileges can't log in to the APEX interface, but can from the command line with sqlplus. I just created user: CREATE ROLE administrators; GRANT dba TO ...
0
votes
0answers
165 views

DBA_SCHEDULER_Job is not giving any result

I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering. select job_name,status from dba_scheduler_jobs; ...
2
votes
2answers
377 views

Duplicating a Database with RMAN

I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below. SQL> SELECT ...
2
votes
2answers
1k views

How to connect to Oracle 11g using “Navicat for Oracle”?

My Oracle 11g Enterprise Manager runs like this: I have taken the following screen-shot after my Oracle installation has been completed: I have the following Oracle-related services running: ...
1
vote
1answer
837 views

Getting “BadImageFormatException” when attempting to connect through Visual Studio to Oracle

I get the following message: “Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components ...
0
votes
2answers
3k views

Exporting 30 million rows to CSV

I have a query that hits multiple tables in an Oracle database (11g). I don't have access to the server itself. I use SQL Developer or SQL*Plus to connect. There are about 31 million rows, and 7 ...
0
votes
1answer
491 views

Timezones in Oracle 10

I have an application that stores its timestamps in Oracle using UTC (Coordinated Universal Time). Another application reads these timestamps from the database, but there is no convenient way to ...
0
votes
1answer
75 views

Compare dates problems

I created a table with the following columns: CREATE TABLE INDICADOR_DADOS ( ID VARCHAR2(10 CHAR) NOT NULL, DATE_START DATE NOT NULL, DATA_END DATE NOT ...
1
vote
1answer
861 views

NLS_TIMESTAMP_FORMAT changing automatically and randomlly

I am using Oracle 11gR2. My nls_timestamp_format is changing randomly from dd-mon-rr to yyyy/mm/dd. Does anyone have any clue why this is happening?
0
votes
1answer
67 views

Migration of SQL Server to Oracle Database

In Sql server, My Procedure will create temporary tables where column names are dynamically comes from every user, then inserts the data into the temporary tables and i use the data further based on ...
1
vote
1answer
174 views

Oracle Express intermittently stops responding, requiring a OS reboot to fix

I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out. There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
-2
votes
4answers
933 views

How to load the Adventureworks database into Oracle?

I am trying to work through some of the examples at sqlzoo and I would like to load the example adventureworks example database into an Oracle database at home. Google search has not turned up any ...
2
votes
2answers
1k views

Using dynamic sql inside Oracle stored procedure

Assuming I have the following procedure CREATE PROCEDURE foo (table1_id IN TABLE1.table1_id%type, table1_val IN TABLE1.table1_value%type) AS SQL_UPDATE VARCHAR2(500) := ...
1
vote
0answers
542 views

Why Oracle Database trigger can became DISABLED

We have an application, using ddl database trigger on oracle database. Trigger depends on package and several tables, package depends on user defined function. It works on different customer sites ...
1
vote
1answer
1k views

Oracle database created whats next? Create Schema or Create Tablespace?

I'm a programmer that's being thrown to the DBA/Sysadmin island all by myself with a volleyball that I named Wilson. I'm trying to survive here. I'm supposed to create a database for an application. ...
-3
votes
1answer
332 views

Windows Server 2008 R2, Active Directory, and Oracle Database Server

I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server I Want to know how to make the configuration of the following Diagram in this link: ...
2
votes
1answer
1k views

Why does DBMS_UTILITY.COMPILE_SCHEMA break function-based indexes?

After mass structure updates, some views/procedures became invalid. So I just recompiled them with: exec dbms_utility.compile_schema( USER ) But after that, all function-based indexes, which ...
2
votes
3answers
5k views

how to check which background process are running in my oracle database?

To check all background process in oracle we can see using v$bgprocess view. I want to check which background process are active. Can anybody please help ? Thanks
4
votes
4answers
727 views

Oracle 11g delete by unique key slow

We have been plagued by a deadlock issue for quite some time that relates to deletes and inserts on the same table. It happens sporadically, but had been increasing in frequency. It would manifest ...
0
votes
1answer
102 views

using row data for column headers

I have a table CREATE TABLE "AUTOMATION"."TESTRESULTS" ( "BUILDNUMBER" VARCHAR2(30 BYTE), "TESTNAME" VARCHAR2(100 BYTE), "STATUS" VARCHAR2(100 BYTE) ) sample data would be ...
1
vote
1answer
65 views

Summation query with complex grouping criteria

I have a database of coded actions with this structure. {User, Date, ActionCode} I need to generate reports based on dates and action codes, and the action codes are not clean because we have to ...
0
votes
1answer
1k views

Database creation on Linux with dbca: “command not found”

I have installed an Oracle on my machine. When I open a session with VNCServer and type dbca, either as root or as oracle, I get these errors: -bash : -dbca : Command Not found Xlib: connection to ...
0
votes
1answer
334 views

Ideal frequency to gather table statistics in Oracle for database of 1GB in size

I want to know what should be the ideal Frequency for Analyzing tables in a schema. Database size 1GB. Currently the frequency is set to 7 days, it takes around 40 mins to complete. Data volume is ...
0
votes
4answers
91 views

Selecting the first purchase item of each customer

I have a table like this: CREATE TABLE SALES ( CID NUMBER(4), PDATE DATE, ITEMCODE NUMBER(4), ITEMNAME VARCHAR2(20) ); INSERT INTO SALES VALUES (1111,'15-JAN-2011',4001,'LUX'); INSERT INTO SALES ...
0
votes
1answer
126 views

Efficient way to perform approximated search?

I have to perform a join between table_a and table_b, using three fields as key being one of them the date of the event, say, both tables have id1, id2 and evnt_time for eache record. As it happens ...
0
votes
3answers
2k views

Exporting schema data (tables, permisions) into another schema on same database

I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
0
votes
1answer
69 views

Combine multiple queries into single query

I am trying to run the following query: SELECT Freight.Freight_No, Freight.Available, Locomotive.Loco_No, Locomotive.Available, Driver.Driver_No, Driver.Name, ...
-1
votes
2answers
75 views

Partitioning in Oracle 11g

If I alter the partitioning in oracle and trying to retrieval the data,is necessary to mention the partition name or not?
0
votes
1answer
433 views

Removing the Oracle Instance details from windows machine

Actually, I have installed the Oracle 11g Version 1 in my machine. After that instead of using universal installer for uninstallation manually I had removed the files from installed location. Now, ...
1
vote
2answers
2k views

How do you correct a corrupted index in Oracle?

I have this ORA error in our logs: Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: ...
0
votes
1answer
129 views

How do you correct a corrupted index in Oracle? [duplicate]

I have this ORA error in our logs: Caused by: java.sql.BatchUpdateException: ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: ...
4
votes
2answers
661 views

Alternative to sequence and timestamp: uniquely ordering records in time

Oracle 11gR2 Exadata I'm required to uniquely identify when records are created in time. Sequence caching means I cannot use a sequence-based ID and batching inserts means that all records inserted ...
0
votes
1answer
588 views

SQLPlus: Cmd vs PowerShell

From cmd.exe, when I run: C:\oracle\client\BIN\sqlplus.exe username@server then type my password, I get in. However, if I run the same command from PowerShell and type the same password I get: ...
0
votes
1answer
81 views

Is the data fetched by an explicit cursor immutable in PL/SQL?

This seems like an obvious question, but Googling has so far failed me... Say I have a view which delineates updates that I need to apply and, to this end, I have an SP that opens the view as a ...
0
votes
1answer
196 views

Oracle transactions deadlock

How to rollback all active transactions on Oracle DB? I execute query and see 4 transcations in ACTIVE status. SELECT * FROM V$TRANSACTION