All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

1
vote
1answer
606 views

Oracle Streams Setup Error

I am running Oracle 11g on a Linux box. I am trying to run the following command to set my streams user grants and other authorizations: BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE( grantee ...
0
votes
1answer
821 views

Unable to restore database in Oracle 10g

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message. ...
12
votes
4answers
2k views

Reason to not use nullable number in Oracle?

Our company is interfacing with another software company for a joint project, and we were told that, if a particular value should not be displayed, we should pass in a -5000 (their arbitrary sentinel ...
0
votes
1answer
522 views

getting oracle error ora-00103 when I try to execute a package in oracle 10g

I have to delete and repopulate tables on a remote database.To access the remote tables I have created synonyms. my package is as follows create or replace PACKAGE eco_push IS PROCEDURE ...
4
votes
1answer
140 views

Thoughts about Oracle backup procedure for 11.2 (beginner question)

Two days ago we "found out" that our old, not taken care of, horribly neglected, Oracle DB server was extremely important to our business. The only person who knew anything about this server was ...
1
vote
0answers
57 views

Diskless Oracle and persistent filesystems

I'm putting together a diskless Oracle database SLES image. What will need to be kept stateful? For example, what filesystems need to persist? Right now, the easy ones I know of are /home, /perf ...
2
votes
1answer
1k views

Oracle SQL Loader - load file where record is composed of “n” delimiters

How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas? I have read the documentation, however I cannot find how to handle this scenario, ...
2
votes
1answer
5k views

How do we free up disk space from allocated namespace? / ORA-03297

We are running out of disk space. The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g). The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
3
votes
1answer
922 views

Option to tell Toad to never split a file which contains multiple objects?

Is there an option to tell it to stop prompting me to split a file which contains multiple objects when opening .sql files from an edit window? I never want to split the file!
1
vote
1answer
2k views

Oracle XE 11.2 Export / Import Charset

I created a database in oracle XE 11.2 that uses charset AL32UTF8 that I now want to export. When I perform the export, the resulting data appears in WE8MSWIN1252 character set and AL16UTF16 NCHAR ...
4
votes
1answer
2k views

Oracle integer to number conversion

According to the Oracle documentation, creating a table with a column of ANSI type INT, Oracle will convert it to NUMBER(38). According to the same document, NUMBER(38) is supposed to be a NUMBER ...
10
votes
2answers
3k views

Does Oracle PL/SQL have a standard ASSERT routine?

I'd like to use an ASSERT routine functionally similar to the one found in other languages, i.e. a construct (be it a procedure, syntax...) ASSERT( <condition>, <msg>) such that when ...
2
votes
1answer
2k views

Installing Oracle XE 11gR2 on Fedora 15 - linux group permission deadlock

During installation of Oracle XE 11gR2 on Fedora 15, I am presented with: The install cannot proceed because ORACLE_BASE directory (/u01/app/oracle) is not owned by "dba" group. You must change ...
1
vote
1answer
144 views

Use of '@' '.' and 'public operator/keywords in Oracle database?

I got into a weird SQL query-patch which looks for @ . and public keywords. I was wondering what is the purpose of these operators/keywords? I suspect that it might be looking for SQL injection or ...
7
votes
2answers
3k views

Is DB2 more reliable and stable compared to PostgreSQL or MySQL?

Always i was using MySQL or PostgreSQL for my projects such as Web/Desktop apps. I had data loss few times and thanks to old backup i was always up and running. But for a recent project for Airport, ...
2
votes
1answer
5k views

Oracle not available error with Oracle XE 11.2.0-1.0

I have downloaded Oracle XE 11.2.0-1.0 and installed it on a CentOS 6.3 virtual machine with 1.5GB memory and 3GB of swap. SYS and SYSTEM set to have password 123456. I have set ORACLE_HOME=/u01/app/...
4
votes
1answer
2k views

Oracle High-water Mark: how relevant it is when using ASSM tablespace for tables?

I have several questions: 1) If Oracle manages both High-water Mark and Low High-water Mark in ASSM tablespace then do we have to think about that when thinking about performance? I mean, does ...
-1
votes
1answer
268 views

Selecting just one table from Oracle view [closed]

I am creating a view to ease my manual selecting because I only want to fetch data from DB where it is meeting certain criteria which are present in several tables, so it is containing a lot of joins. ...
2
votes
0answers
10k views

Oracle 11g .DMP viewer

I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel... Is that possible in some sort of a simple way? I've found a few ...
3
votes
0answers
500 views

Oracle sqldeveloper Database Diff - not seeing indexes/sequences

I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...
5
votes
2answers
2k views

Using Multi-table Insert for Parent and Child Table

Is it safe to use Oracle's multi-table insert statement to insert into a (foreign key constrained) parent and child table? With minimal examples, I've found that it works as long as the parent table ...
2
votes
2answers
651 views

simulate sequence on mysql in preparation for move to oracle

I've been developing an application against MySQL while a new development server has been slowly being set up. The new dev server will use oracle, and since we're getting close to it being ready, I ...
1
vote
1answer
1k views

Using Apache/ mod_proxy_ajp/ APEX Listener together

Our application is developed with APEX, and it is accessed through APEX listener through HTTP on default port 8080. Now, we want to switch to Apache with mod_proxy_ajp and reconfigure APEX listener to ...
4
votes
2answers
2k views

What's a free client for Oracle 8 on Linux / Ubuntu? [closed]

I need to connect to a legacy Oracle 8 database. Oracle SQL Developer would be my tool of choice, but the current version doesn't support Oracle 8 anymore. I tried Squirrel too, but the connection ...
3
votes
1answer
1k views

How far should bind variables go in Oracle?

I am currently examining all database users's SQL code in our department for not using bind variables. We do experience an ORA-04031 error within a constant period of time. Now, I have a quite firm ...
2
votes
4answers
1k views

Limiting Generated Sequence Values in Multi-table Insert

In Oracle, given the following objects: create table a (x number ); create table b (val number ); create table c (val number ); create sequence my_seq; Suppose I populate table a as follows: ...
3
votes
1answer
1k views

Oracle - Need help with RMAN Active Duplication on Windows 32 bit to a 64 bit

I need to have an Oracle 11g R1 on a Windows 32-bit duplicated to a Windows 64-bit using RMAN Active Duplication. 32-bit setup: Windows Server 2003 R2 Standard Ed. SP2 Database - Oracle 11g ...
2
votes
1answer
1k views

impdp import fails with object already exists in oracle 10g?

I exported the dump using EXPDP command. After exporting I dropped the user and the associated tablespaces by logging is as / AS SYSDBA. Then I re-created the User and the Tablespaces. Then I ...
2
votes
2answers
4k views

How can I delete duplicates records in a table efficiently

I know there are several options to delete duplicate rows, eg: ROWID Analytical fn's like Rank(), row_number() What would be the most efficient way?
1
vote
1answer
3k views

ORA-00379 no free buffers

I'm trying to do collection_manager in OVPI but I'm getting db error ORA-00379 no free buffers available in buffer pool default for block size 32k oracle 10.2 Thanks for any help in advance
4
votes
2answers
17k views

Updating Multiple Rows with Data from Column A into Column B?

I have about 60,000 rows that I'm needing to update the information from column_a to column_b. For example, 60,000 customers need their arrival_time to match their departure_time. I understand that ...
1
vote
4answers
818 views

Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl

What could be the best approach ? Till now could figure out the following (Oracle) Calling exp.exe and imp.exe utilities in Oracle client using Java and inturn call it from Perl. Calling exp.exe ...
2
votes
2answers
9k views

Oracle 11g r2 standard edition installation - set environment variable PATH and create tnsnames.ora

I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for ...
4
votes
1answer
645 views

SQL unpivoting multiple rows/columns, but keeping the rows grouped together, and in the same order they were selected

This is a complicated explanation, so sorry that it is going to be a wall of text. I'm dealing with pre-existing code and am trying to work out a solution, so I can't alter the core way any of this ...
4
votes
1answer
4k views

Drop user did not reduce size of tablespace file

I have a development environment in which I frequently copy a certain schema. When I'm done with the copy, I will use OracleEM to drop that user/schema. My problem is that this does not seem to ...
3
votes
2answers
2k views

Character Set Database Migration

This is a follow-up question to a previous thread I had posted. We're in the process of migrating to a new character set. Now, I am a programmer and we have DBA's who will be performing the work but I'...
3
votes
2answers
2k views

FORALL on Nested Collections

Suppose I have the following two tables in my Oracle database: create table a (num number); create table b (val varchar2(30); and in my PL/SQL program I have declared a nested collection as follows:...
4
votes
7answers
6k views

What database front end do you use? [closed]

What database front end do you use? It should let you manage databases, tables, indexes and ideally even data records. And it should ideally be free so we can all use it too. Databases that it could ...
4
votes
1answer
399 views

Dodgy causes of ORA-12549?

I am dealing with a rather massive ETL processing which keeps throwing me the ORA-12549 error. Have been looking for problems in the database so far and nothing. The DBA says the database is "fine" - ...
2
votes
1answer
2k views

How to copy bytea from Postgres to Oracle

I have a db on Postgres 9.1. The db collected some binary data that are stored in bytea file. I need to copy the data to Oracle 10g. How to do it? The details I have a table plines in Postgres9.1. ...
2
votes
1answer
442 views

Oracle Change Data Capture: Unsubscribed column results in change set record

I am using Oracle 11g's Change Data Capture to track changes on a database table. I am using synchronous mode to minimize latency. Here's an example to illustrate my problem: Published_Table ...
1
vote
1answer
4k views

Oracle 10g Listener problem

In Oracle 10g I have a listener problem, Here is tnsnames.ora : MYTNS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = testiold) (PORT = 1521) ...
2
votes
1answer
18k views

Oracle DBCA utility: “Listener is not up or database service is not registered with it”

I'm a software engineer with some experience on SQL Server but a newbie on Oracle. I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
1
vote
1answer
354 views

Why are Oracle processes only using half the SGA set?

I have an Oracle set up on a remote server that's maintained by a third party. Recently it became corrupt and we replaced it with a new instance. Since then it's been running slower when performing ...
0
votes
1answer
228 views

Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)

I am sure there are some easy ways to do this... I have a simple flat Oracle table which is 13 terabytes or so in size due to a large number of rows accumulating over the years. I need to do a search ...
2
votes
2answers
2k views

Oracle - How can I find the session id of a shell script (Linux)?

I have a Linux script run periodically from crontab which executes some sql scripts. How can I get/identify the session of that running job? thanks
1
vote
1answer
664 views

Testing an Oracle DB connection before it is made - ERROR?

I tried to make a new oracle DB connection with user name and password. I entered the connection name, user name and password in the new connection window. When I click the "test" button or the "...
3
votes
3answers
6k views

Revert to old plan in Oracle

A weekly, scheduled, schema wide stats update was run on our Oracle 11R2 RAC cluster on Sunday. One of the queries had no apparent data or code change but now runs at 3 hours instead of 20 minutes. ...
1
vote
1answer
4k views

Oracle backup with RMAN Options?

I'm trying to learn RMAN but getting confused everytime I read Oracle docs! Can someone help me what are the differences and when to use the following? BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT ...
10
votes
2answers
2k views

Recovering logical space from a tablespace

I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space. A week ago I queried ...