|
|
Browse by Tags
- 10
- all objects stored in one tablespace
- analyze table error ora 27507 -IPC error disconnecting from a port
- cluvfy
- Database
- Database 10 g
- Database 10g
- FireFox 3.0.1
- Foreign Language Characters Inserts.
- Installed on Windows XP SP2 - want to upgrade to 10.2.0.3
- Intranet on Secure Government Site
- no in-parallel indexes
- non-partitioned tables
- oracle
- Oracle Database
- Oracle RAC
- Oracle Text
- Oracle XE
- PL/SQL
- runs on a SuSE Linux Ent. Server 10
- sql
- SQL SELECT
-
Oracle XE / ASP 115 Trappable Error Help
I am looking for help/advice. We installed Oracle Express Edition (XE) to a Windows 2003 SP2 server and it works fine through the APEX interface and SQLPlus. We have set up a web site and use ASP (not .NET) pages, utilizing the ADO object, to connect to the server with almost no problems. We can use... -
Slow Select Statement
A SQL select statement is verry slow in an custom database. The execution plan shows very hight cost for the operation. All tables are indexed and the statistics are corect. In all other cases the statement work well. In the problem database a lot of records (600000) are deleted in the last days. See... -
Oracle 10g Listener Set up on windows
I have installed Oracle Database 10.2.0.1 on windows NT, But i am not able to bring the listener up there is a 9i database with its listener. so i got this 9i listener down and cleared the registry and rebooted the windows server. So there is no 9i listener now on the server weird thing is when i am... -
Oracle 10g DB 10.2.0.3 and Windows XP SP2
I'm unable to find the following patch set clearly identified as being supported on the Windows XP SP2 platform: Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) Enterprise/Standard Edition for Microsoft Windows Vista and Windows 2008 Can anyone tell me if this patch set will work on the XP SP2... -
User equivalence check failed for user "oracle".
I am setting up a 2 node RAC cluster on Solaris 10 (sparc)... I have 2 nodes... bart and moe... when I run the cluvfy command to check the configuration I get the following back... and ideas... /runcluvfy stage -pre dbinst -n bart,moe -r 10gR2 Performing pre-checks for database installation Checking... -
How can I insert CHINESE/JAPANESE/GREEK/LAT<wbr />IN CHARACTERS into an Oracle Table?
I need to insert foreign language ( e. g. CHINESE, JAPANESE, GREEK, LATIN etc. ) characters into an Oracle Table. Can you describe the complete step-by-step process on how I can achieve this using a SQL QUERY? I would really appreciate if you can describe this right from the beginning to end. TIA. -
How do I correctly upgrade Oracle 10.2.0.1 up to version 10.2.0.3 and patch number 6602482?
The DB runs on SuSE Linux Ent.Srv 10.0. I am new to Oracle upgrading issues and would appreciate if you help to figure out how to correctly upgrade, according to the subject? -
Problem: oracle, 10, 10.2.0.1, analyze table error ora 27507 -IPC error disconnecting from a port
folks when i run anaylze table on an object i get a 'ora 27507 error IPC error disconnecting from a port ' can anyone advise me on the error and a possible solution to this error? greets r -
Problem: Errors after importing from dump file... procedures and packages are invalid
I created a new database. I received a dump file from another database (I do not know what all users were present in the original database) and would like to get everything, users, table definitions, data etc into the new database. I tried imp 'sys/*** as sysdba' FILE='/xxxx/xxx/xx.dmp'... -
Problem: How do I tune a complex query (nested loops with full table scans)?
I have attached a complex query and its execution plan. The query acts on the linked results of a document search. The SQL collects all the stored meta-data across all affected tables. I am trying to determine a more performance geared way of using this query. The _l tables are look-up tables. An expert's...