Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

-1
votes
1answer
994 views

Oracle XE: Transfer Database from Linux to Windows

our professor gave us a linux VM with a Oracle XE 11g Database. I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise. Everything ...
2
votes
1answer
3k views

ORA-00984: column not allowed here

I am running Oracle 10g. I am writing a script (a delta script over a created database) that will be executed in SQL*Plus. It is needed to fix a bug. I need to know if a row exist in a table, and if ...
12
votes
1answer
2k views

Commit vs Fast Commit vs Commit Cleanout in Oracle Database

I was wondering whether someone could verify my understanding regarding the differences between those 3 terms as pertaining to Oracle Databases. Many sources confuse these terms and do not explain ...
1
vote
1answer
61 views

Supporting Multiple Oracle Clients

I have an application where the data repository is moving to Oracle 11g. This means we need the new Oracle 11g client on the application server to support the retrieval of their data. Is it ...
2
votes
1answer
2k views

How do I export data from Oracle 11.1 to 10.1?

I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server. While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the ...
1
vote
0answers
443 views

Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?

I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server. I have created a database template (DBCA) from an existing database (structure and data). I have copied ...
3
votes
1answer
112 views

Using Inteval Datatype to store result of calculation

I want to create a table which has hiredate and Interval of hiredate and sysdate. How to create a column that automaticlaly stores the calculation.
5
votes
1answer
160 views

how do I configure a new Oracle 11g instance to match the configuration of the old Oracle 10g server

How can I compare two Oracle database servers which are on two different machines? We need to ensure that the new server is setup correctly. For example, one machine is running Oracle 10g on ...
7
votes
4answers
25k views

create incremental number in oracle sql query

how to create incremental number in oracle sql query without create any table ? I have tried using "with" clause, but I failed to get the expected result. I am using oracle 10g here is the code that ...
1
vote
1answer
8k views

ora-01410 invalid RowID sporadically in a select statement

I have a select that looks up some data by a join. The system runs Oracle 10.02g and the select looks like this SELECT distinct t1.crit FROM table_name1 t1 INNER JOIN table_name2 t2 ON t1.crit ...
1
vote
0answers
694 views

v$logmnr_contents with username as unknown

I applied logminer to find who deleted a lot of rows in one table. View v$logmnr_contents give me details of that operation. Unfortunately, minimum supplemental logging was not active when archived ...
1
vote
1answer
278 views

Logminer archived redo logs in other database

Can I move my archived redo logs to other database and apply logminer there to analyze them?
1
vote
2answers
693 views

Analyzing an Oracle dump

I have a full Oracle dump, I know I have to imp the dump with the fromuser touser clause. However, I don't know the names of the schemas included in the dump. How can I open the dump created with ...
1
vote
2answers
273 views

Join on clustered tables shows greater cost than non-clustered tables?

I have created a cluster and have two tables emp and sep on the cluster. When I do the simple query... explain plan select * from emp_cluster join dep_cluster using (dno) the cost is 26. I ...
0
votes
0answers
189 views

How to load XML data into an oracle db table ?

Is there a way to load the XML format data into an Oracle 11g DB table directly ? I mean, Can we write a Stored Procedure to accomplish the same in a more efficient way with the best performance ? ...
1
vote
1answer
3k views

ORA-12541: TNS:no listener using EXPDP

I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct: expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump ...
1
vote
1answer
2k views

Solution to error NID-00135 in Oracle 10g, Solaris 10

We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test. We've successfully restored and opened the database ...
0
votes
1answer
522 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. ...
2
votes
1answer
3k 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
3answers
784 views

When are Archived Redo Logs generated?

We have an instance in Oracle 10g. Only one schema is used for a web application (Internet-facing), which is only user for reading information, no adding or modifying data. The rest of schemas are ...
1
vote
0answers
578 views

Timeout on remote query over database link

We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
2
votes
1answer
811 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
3answers
3k 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?
2
votes
1answer
1k 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
334 views

Oracle function based index is not used in query

I cannot figure out why the following is not working as I expect it : CREATE TABLE table1(table1_id INT NOT NULL PRIMARY KEY, col1 INT NOT NULL, val1 VARCHAR(50)); CREATE INDEX ...
4
votes
1answer
5k views

Is there a timeout for a query over database link?

Edit/Preface: This question has been migrated from SO as I am particularly interested on the question on timeouts on DB link queries. The provided workaround from SO is somewhat OK, but I'm really ...
0
votes
0answers
1k views

RMAN Error ( 00601, 03004)

Please help on this RMAN error: RMAN> backup database plus archivelog; Starting backup at 08-MAY-12 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=297 devtype=DISK ...
4
votes
2answers
337 views

What are the risks of the parameter PRESERVE_COMMIT_ORDER of Oracle's DBMS_LOGSTDBY?

We have the following setting, with Oracle 10g: One primary database One logical standby database with setup with data guard. The logical standby is only used for generating reports and alike. ...
3
votes
1answer
6k views

Is it possible to do a datapump import with a different user than did the export?

I have one db dump below is the log file for that dump Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
0
votes
1answer
5k views

How to take oracle 10g backup? [duplicate]

Possible Duplicate: How to take oracle 10g backup? I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create ...
4
votes
1answer
1k views

Oracle subquery column aliasing syntax?

I have something like: SELECT a, b INTO v_a, v_b FROM ( SELECT x, y FROM whatever UNION SELECT z, w FROM something ) AS subquery (a, b) Which of course doesn't work in Oracle ...
0
votes
0answers
564 views

Problem in exporting users from oracle database. (Oracle 10g express edition)

I am trying to export the user from database, but its showing export done in we8mswin1252 character set and al16utf16 nchar character set But if i am trying to export entire database then its ...
1
vote
1answer
489 views

This refactoring from cursor on a dblink'ed Oracle table OK?

The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle ...
1
vote
1answer
595 views

Enterprise Manager Database Control on host with an underscore in it's name

I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name: C:\>emca -deconfig dbcontrol db -repos drop STARTED EMCA um 30.05.2012 ...
9
votes
1answer
365 views

SQL substitution feature in Oracle 10g

Three or four years ago I read in an Oracle blog somewhere that a DBA had used for an emergency incident resolution an Oracle 10g feature of real time SQL substitution. Basically, he configured Oracle ...
0
votes
1answer
3k views

Returning Row Count in a Stored Procedure in Oracle

I'm mostly SQL Server person, so forgive me if this is too close to SQL Server, but in a nutshell using Oracle 10 I'm trying to build a procedure something like this: PROCEDURE SP_INFO_EX_S( ...
3
votes
2answers
17k views

Using Same CASE WHEN Conditions For Multiple Query Columns

Is there a "better" way to rewrite a SELECT clause where multiple columns use the same CASE WHEN conditions so that the conditions are only checked once? See the example below. SELECT CASE ...
0
votes
2answers
3k views

oracle 10g xe to 11g xe upgrade

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
3
votes
0answers
249 views

changing Virtual IP interface names on RAC nodes - how to reconfigure

We are adding an extra interface on our nodes and we are going to bond these so the VIP interface will change from eth5 to bond3. Can someone point on documentation on what to do to reconfigure the ...
7
votes
1answer
906 views

Can I anchor my data type to system type?

The following code: create or replace type sqlids_t is table of sys.v_$sql.sql_id%type; ...gives me... Error(2,31): PLS-00329: schema-level type has illegal reference to SYS.V_$SQL I get the ...
6
votes
1answer
32k views

How do I declare and use variables in Oracle?

My main skills are with SQL Server, but I have been asked to do some tuning of an Oracle query. I have written the following SQL: declare @startDate int select @startDate = 20110501 And I get this ...
1
vote
1answer
716 views

ORA-07445: An unexpected error: core dump

We use oracle 10g. We found the following error in a trace file: *** 2012-05-07 11:50:56.421 ksedmp: internal or fatal error ORA-07445: An unexpected error: core dump [ACCESS_VIOLATION] ...
3
votes
1answer
241 views

Can this be accomplished with Oracles Fine Grained Auditing?

We need to audit when a table is accessed (either select, update or delete) and I know Oracles Fine Grained Auditing can handle that. The issue we are having is that all of our users use the same ...
1
vote
1answer
5k views

restore database from dmp file

I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to ...
1
vote
2answers
595 views

Oracle Databases - need to export nightly for backup/DR purposes

I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things. I have 2 ways I see currently that I can backup a server running 3 Oracle ...
3
votes
2answers
422 views

How can I change three hundred procedures at once?

I need to change about 300 procedures and packages in the database, due to a migration that will accomplish this weekend. We will do a migration from one server to Exadata. However the database has ...
1
vote
1answer
4k views

Materialized view taking too much time

i create a materialized view fast refresh. it takes almost 45 min to create but it did not refresh in 24 hours. i tried it on with index and without index. i check the log of all table max record in ...
2
votes
0answers
308 views

What do I need to do to avoid ORA-32696 errors?

I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the ...
1
vote
0answers
177 views

Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x

I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message: ...
4
votes
2answers
525 views

Installing oracle RAC 10.2.0.1 install and patch to 10.2.0.5 directly or install CRS ASM and RDBMS then patch?

I'm installing my first RAC and I was wondering if I should install CRS 10.2.0.1 (we are still at 10g for compatibility reasons) then patch to 10.2.0.5 before I install ASM (then patch) and finally ...