Oracle Corporations version 10 of its flagship RDBMS product.
0
votes
0answers
448 views
How to detect when did ocurre ORA-00604?
Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of ...
-1
votes
1answer
316 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 ...
1
vote
1answer
362 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 ...
9
votes
1answer
382 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
50 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
321 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
165 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
90 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
135 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 ...
6
votes
4answers
6k 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
2k 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 ...
0
votes
0answers
73 views
How can I move my database from linux server to SAN? [closed]
Please anyone4 can tell me How can i move my oracle 10.2.0.4 database which is on linux server to SAN(Storage Area Network).?
5
votes
3answers
4k views
Cannot drop nonexistent constraint and cannot create it either
While testing some migration scripts with a copy of production data (scripts run fine with development data) I found a curious situation. A CONSTRAINT has changed so I'm issuing DROP + ADD commands:
...
1
vote
0answers
207 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
117 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
282 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
138 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 ...
2
votes
2answers
623 views
Oracle - abort within a “before insert” trigger without throwing an exception
I know that this is an awful thing to do for many reasons, but I am in Get Things Done mode and we have a piece of software, which we can't modify, that writes records to a table. Some of these ...
0
votes
0answers
104 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
607 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
576 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
192 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
920 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
228 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
186 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 ...
1
vote
1answer
121 views
Size of an empty database
Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
0
votes
1answer
396 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
262 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
Why Oracle sessions are still alive after two weeks being Inactive
DB: Oracle 10g
O/S: Windows Server 2003 64 bits
I query list of Oracle sessions generated by web applications (filter by program=w3wp.exe)
select * from V$session
where UPPER(program) LIKE '%W3%'
...
2
votes
1answer
390 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. ...
0
votes
0answers
55 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
0
votes
0answers
171 views
How to Import a file to Oracle APEX & what are invalid files to import? [closed]
APEX is running. I tried to import a workspace that I exported in a 4.0 version of APEX
After choosing the file I get this message:
the export file has been imported but is not a valid workspace ...
0
votes
0answers
63 views
Oracle form 10 g “RUN” Error
I have built a form from the employees table and trying to run it.But nothing is showing except for some text in the web browser with address being my local documents location instead of
...
2
votes
1answer
136 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
232 views
Find fragmented space free below HWM Oracle
That High Watermark Value always eludes me when calculating free space in my tablespaces.
Will the following query consider fragmented free spaces of object below the HWM value for each TS?
select * ...
0
votes
0answers
319 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
116 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.
...
2
votes
1answer
2k 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/******** ...
1
vote
1answer
263 views
Are multiple dbf files better than one?
Is it better to distribute a large database over several dbf files than over a single one?
0
votes
1answer
3k 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 ...
3
votes
0answers
270 views
Convert Oracle Query for Date to Mysql queries
Need to convert the following oracle queries to MYSQL queries.
1)
select to_char(to_date(?,'DD-MM-YY'))
from dual;
2)
select to_char(next_day(to_date(?,'DD-MM-YY'),'FRIDAY'))
from dual;
3)
...
1
vote
1answer
266 views
How do I determine if FORCE LOGGING is on for the entire database?
How can I determine if force logging is on, at the database level. (Not asking about finding out if force logging is on for particular tablespaces.)
What rights are needed to perform the check of the ...
4
votes
1answer
670 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
237 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
207 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
324 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 ...
2
votes
2answers
857 views
Return many rows on a plsql Oracle10g
I'm doing a little project and I need to do a plsql to return many rows.
I have someting like:
Table(id, data1, data2, from)
And the user gives me the value of from and I have to return all that.
...
9
votes
1answer
175 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
1k 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(
...
