Oracle Corporations version 10 of its flagship RDBMS product.
9
votes
1answer
420 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
357 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
178 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 ...
0
votes
1answer
2k views
Moving a 10g database to 11g with rman backup
Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 11.2.0.1.0), which is in other server.
What I did on 11g server:
- Generate full rman backup of 10g ...
0
votes
0answers
74 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
2answers
601 views
How to install Oracle 10g Express and 11g Enterprise on same machine
I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support ...
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 ...
1
vote
0answers
222 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
119 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
216 views
Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped?
everything is in the question.
I have a table named tableA on which we have indexes and foreign keys and constraints.
I have to modify content in a column called column1. This being a production ...
0
votes
0answers
105 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 ?
...
2
votes
2answers
697 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 ...
2
votes
1answer
992 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
256 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 ...
3
votes
1answer
92 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 ...
1
vote
1answer
141 views
Find who will change a record in oracle DB
Someone is updating a record in a custom Oracle table, is there a way to find who is updating the record and or at least the table?
1
vote
1answer
130 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 ...
1
vote
0answers
187 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
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%'
...
0
votes
1answer
401 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
1answer
417 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
3answers
272 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?
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
65 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
142 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 ...
1
vote
1answer
645 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
...
0
votes
1answer
1k views
Why does dbms_scheduler max_run_duration not raise event JOB_OVER_MAX_DUR?
Starting from this question and this example I've tried to create an event based dbms_scheduler job, which waits for event JOB_OVER_MAX_DUR raised from jobs, which exceeded their max_run_duration.
...
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 ...
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/******** ...
0
votes
1answer
203 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.
...
1
vote
1answer
284 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
277 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
302 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
685 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
251 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 ...
0
votes
0answers
172 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 ...
1
vote
2answers
931 views
oracle 10G forms connection with Oracle database 10G Enterprise Edition in windows 7
I am trying to connect Oracle Forms 10g version (9.0.4) to the Oracle 10G Enterprise Edition.
At first I tried to connect to the db without setting the "Local Net Service Name Configuration" in ...
1
vote
1answer
214 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 ...
4
votes
2answers
127 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.
...
1
vote
1answer
336 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
180 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(
...
2
votes
2answers
1k 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.
...
3
votes
2answers
2k 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 ...
1
vote
1answer
339 views
Backing up an Oracle 10G Express on Windows 2000 Server
Oracle 10G Express installed on Windows 2000 Server Enterprise Edition.
I am trying to automate backups and on Oracle's website I have found the following documentation.
...
0
votes
2answers
1k 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 ...
0
votes
0answers
342 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
...
