|
|
Browse by Tags
- 10g
- 11 g
- 11.1.0.6
- 11.1.6.0
- 11.X
- 11g
- 1Z0-007
- 1Z0-051
- 7
- alert log file
- auditing
- auto
- Backup
- can I use sql loader to update an already exiting table in my oracle 11g database?
- checkpoint
- column
- communication channel error
- configure listener
- configuring the kernal (32bit)
- 'D')
- Database
- Databases
- Day of Week
- dbca
- Does Oracledbconsole cause elevated processes in Oracle 11g?
- EM Problem
- Export Log
- external tables
- Firefox 3 IE 6
- flat file
- full version number
- got ORA-01878 after DST
- iBatis
- increment
- Linux Red Hat
- Linux5
- log switch
- merge
- OEM
- ojdbc6
- ORA-03113
- ORA-12560: TNS:protocol adapter error
- ORA-12638: Credential retrieval failed
- oracle
- oracle 10g
- Oracle 10g AS
- Oracle 9i
- Oracle Enterprise Edition
- oracle exams
- Oracle Import
- Oracle SCM
- Oracle Update Column To Auto-Increment
- Oracledbconsole
- Password Verify
- PL SQL
- pl/sql
- plsql
- profiler
- query
- RDBMS
- redo logs
- running in to ORA-03113: end-of-file on communication channel error when trying to select from the external table
- scheduled jobs fail
- software database checks
- Spring Framework
- sql
- Sql Developer
- sql loader
- Sqldeveloper
- tnsnames.ora
- to_char(sysdate
- Ubuntu 9.0.4
- update
- VB.NET 2005
- VB.NET 2008
- Visual Studio 2008
- VMware
- window 2003 R2
- windows 2008
- xmldb
-
running in to ORA-03113: end-of-file on communication channel error when trying to select from the external table
Hi I am running into the following error while trying to do a select on the external table.. SQL> select CORP_PRODUCT_DW_ID from ext_test_lu_corp_product; select CORP_PRODUCT_DW_ID from ext_test_lu_corp_product * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 8380 Session... -
Oracle Update Column To Auto-Increment
I have a table called effort. Table has 3 columns: id, effort_id, acp_viewer_id I want to set id to autoincrement. How do i do this in oracle? (sequence,trigger i have been reading but do not understand) I am using sqlplus details on command would be helpful. by the way id type is NUMBER(10) Thanks -
Does Oracledbconsole cause elevated processes in Oracle 11g?
Experts, I have been working with Oracle 11g for a while and would recieve an error from Oracle that all instances were blocked when the process reached 150. I was convinced that it was an outside client consuming all the connections. However, someone here is convinced that Oracledbconsole is the root... -
can I use sql loader to update an already exiting table in my oracle 11g database?
Hi all, I need to load data from flat files in to my Oracle tables. Once I load data from the flat files, every day I get a flatfile/table (with the same name). That new flat file contains just inserts and updates. Now if i use sql loader again, then then the Inserts will be inserted into the tables... -
got ORA-01878 after DST
Based on the schemas (WKSYS and FLOWS_030000), the jobs (job 26 and 4002) causing these errors appear to be related to Application Express and Ultra Search. i believe that the error started right after the DST however the other 2 DB on the same oracle server don't have any error. the difference i... -
log switch occuring every 10 mins. Checkpoint not complete in alert log file
Hi All, We run a daily load process which updates millions of records. For, eg, a customer table has 600,000 updates and there are tables with even 4 million updates going on. It is a dataware house environment and we refresh(load) the database on a daily basis. I have a merge statement for each table... -
How do I enable auditing for Oracle 11g?
Experts, I need to be sure that auditing is enabled for event auditing. Is there one command I can add to my script, for example, audit all by access; or do I need to cover all events. For example, privileges by access, java class, java resource, mining model etc? I thought Oracle 11g had auditing turned... -
Substitution in Oracle sql statement
Platform is windows 2003, but use DOS console. Have a question in sql ------ define owner=test select count(1) from &owner.tbl1; --there is a dot between &owner and tbl1 ------- After substition, it became select count(1) from testtbl1 The dot disappears. I really expects select count(1) from... -
Oracle 11g AND application failed logins
Experts, I am trying to do some research on an issue we are having with our Oracle db. Using the OEM, there are errors logged that a specific software is trying to login to the database but failing. Login attempts are 676 per half hour continuously. would this cause a connection refusal error from Oracle... -
What version of ODAC should I use for Oracle 10g?
Hi, I am developing a software application that will work with XMLTypes in an existing Oracle 10g database. I want to take advantage of ODAC and ODP.NET, but am unsure if the latest version of ODAC that is targeted for Oracle 11g, Oracle 11g ODAC 11.1.0.6.20, will work on a 10g database. Can someone...