Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle10g** are assumed to be specific to this version or features introduced in this version.
Questions tagged [oracle10g]
110 questions
14
votes
6 answers
How can I diff two Oracle 10g Schemas?
I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article…
Stuart Woodward
- 1,343
- 4
- 14
- 29
13
votes
4 answers
Oracle: how to find out storage space used by a table?
How to find out (if possible via Enterprise Manager), the total in Mb that a certain table is using?
b.roth
- 249
- 1
- 4
- 12
8
votes
4 answers
ORA-12705: Cannot access NLS data files or invalid environment specified
I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2.
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment…
M.N
- 337
- 3
- 7
- 15
8
votes
4 answers
How to restore/import an Oracle database from dmp file?
I've recently received the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now I need to restore the original database.
Can anyone give me a step by step procedure for how to restore it from the *.dmp file ?
Paul
- 714
- 2
- 6
- 19
7
votes
2 answers
Oracle 10g for Windows does not start up on system boot
We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to Windows Server 2008 Hyper-V.
The services start on…
Mike Dimmick
- 251
- 2
- 4
4
votes
2 answers
oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist
I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 08:19:58
Copyright (c) 1991, 2007, Oracle. All rights…
nelaaro
- 584
- 4
- 9
- 25
4
votes
1 answer
Are there any performance differences between Oracle Entreprise and Oracle Standard editions?
Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition.
Given the same hardware, OS, versions and data - and only using the…
BIBD
- 1,826
- 10
- 29
- 44
4
votes
1 answer
How to prevent remote login for SYS
Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
schurik
- 141
- 3
4
votes
3 answers
How can I find my Oracle 10g server version?
I don't have physical access to my Oracle server but I can run some sql command from Toad. Is there a way I can find wich version the server is running, like 10.2.3.1. I know it's 10g but I'd like to know wich patchs and maybe more (memory used,…
Philippe
- 191
- 2
- 6
3
votes
2 answers
How to diagnose frequent "500 Internal Server Error" on Oracle Apex
I have an Oracle 10g XE database running on OEL 5 on an Amazon EC2 instance. On it I run a public website (actually, 2 web sites) written in Oracle Application Express 4.0.1.
Most of the year, the site is primarily used by people just viewing…
Jeffrey Kemp
- 168
- 2
- 9
3
votes
1 answer
Is there a way to easily run the same query in Toad against multiple Oracle database servers?
I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
Cade Roux
- 375
- 2
- 5
- 18
2
votes
1 answer
Oracle Account Not Responding
I have an Oracle instance which has user1, user2 and user3 accounts. Yesterday I was able to log in to all three accounts. Today, I can get in to user1 and user3, but user2 is completely 'frozen' in some way that I don't understand.
If I try to log…
wweicker
- 495
- 2
- 4
- 13
2
votes
1 answer
Oracle DB import error
I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error.
Prior to doing the import we drop all objects in the schema. The import always fails when importing the same…
Marcus Leon
- 141
- 1
- 7
2
votes
1 answer
Documentation on the SQL execution plan page in Oracle Enterprise Manager (Oracle 10g)
In Oracle Enterprise Manager, in "Performance > Top Activity", you can click a SQL that is being executed and then go to the Plan tab to see SQL execution plan.
For the execution plan, the Enterprise Manager shows a table with the execution plan…
b.roth
- 249
- 1
- 4
- 12
2
votes
4 answers
Oracle Logical Standby redo generation
Oracle 10.2.0.4 database with a logical standby on Win2K3. Recently a rather large delete operation was carried out on the production instance. I'm experiencing difficulty with the logical standby, in that it gets a couple of hundred (58M size)…
DCookie
- 2,098
- 17
- 18