Oracle

December 2007

Incremental rownum !
(31 Dec 2007 23:25:54)
pl/sql authenicate with active directory
(31 Dec 2007 22:50:54)
distinct VS unique
(31 Dec 2007 22:6:5)
EIM question
(31 Dec 2007 20:59:13)
Happy New Year
(31 Dec 2007 18:50:46)
Happy New Year 2008
(31 Dec 2007 15:44:50)
length overflow DBMS_OUTPUT
(31 Dec 2007 15:19:16)
utl_file not declared
(31 Dec 2007 14:50:29)
Backup DB full....
(31 Dec 2007 12:45:53)
create table as select cuestion
(31 Dec 2007 12:20:2)
How can I get the table scripts from database
(31 Dec 2007 10:35:39)
urgent help needed ora-19206
(31 Dec 2007 9:59:39)
Varchar2 Max size
(31 Dec 2007 7:21:27)
Primary key index
(31 Dec 2007 6:55:58)
data warehouse
(29 Dec 2007 19:47:31)
LISTOWNER- EMAIL SHIELDING
(29 Dec 2007 14:0:2)
Help please
(29 Dec 2007 8:13:0)
Failed asm_root.sh script
(28 Dec 2007 21:27:15)
rebuild of index
(28 Dec 2007 21:15:31)
Query about tabledictionary
(28 Dec 2007 13:5:44)
Invoking an external procedure in Oracle
(28 Dec 2007 10:44:11)
schedule
(28 Dec 2007 8:49:56)
update table for multiple rows
(28 Dec 2007 8:13:28)
More than one database in oracle ??
(28 Dec 2007 6:47:22)
How to multiplex control files and redo logs?
(28 Dec 2007 6:45:18)
Re: Reg. error in creation new tablespace in oracle 10g RAC at Ranchi.
(28 Dec 2007 6:25:59)
For loop using Date datatype
(28 Dec 2007 5:53:23)
Oracle Server to Client
(28 Dec 2007 5:47:44)
Retrieve Null Value records...
(28 Dec 2007 4:26:11)
How can identify the Number and Alphanumeric data in the table...?
(28 Dec 2007 3:33:44)
schema import created a new schema
(27 Dec 2007 22:43:38)
How to replace exiting table of a database by importing with newly exported file
(27 Dec 2007 16:4:28)
physical writes on v$sysstat
(27 Dec 2007 16:4:20)
db_block_size 16k
(27 Dec 2007 12:44:41)
HINTS with ORDER BY
(27 Dec 2007 12:5:56)
Gather stats taking long time
(27 Dec 2007 10:58:26)
Physical Write on Database
(27 Dec 2007 10:29:0)
Input at runtime in Plsql
(27 Dec 2007 9:46:7)
Issue with Oracle
(27 Dec 2007 9:42:9)
Help needed to sync databases
(27 Dec 2007 9:15:25)
What is RAID in oracle
(27 Dec 2007 8:27:3)
Vedr.: Date format !
(27 Dec 2007 8:8:42)
how to Implementating Clusters in oracle.
(27 Dec 2007 8:1:34)
Date format !
(27 Dec 2007 7:59:44)
how to take cold backup?
()
Optimization of Update Statement
()
Re: Starting an instance
()
connect to oracle DB through a VB script
()
How to find out the difference b/w the data in 2 similar tables?
()
Re:Looking for DBA - Malaysian, KL
()
Looking for DBA - Malaysian, KL
()
Re:RE: Physical Write on Database
()
Re: a non-numeric character was found where a numeric was expected
()
How to Enable utl_file?
()
SGA resize
()
Importing data problem
()
regarding discoverer
()
TNS:listener failed to start a dedicated server process
()
Oracle clusterware
()
Requesting for help regarding Oracle net
()
Sorting Order
()
hot disk
()
trace process
()
SQL script to generate an SQL Script
()
Stale Stats
()
How do I grant import priv to oracle user
()
Oracle net, and shared server configuration
()
execute and send the rsult via e-mail !
()
Re: and ORA-304500 error
()
ORACLE on windows
()
ASM candidate disks
()
Failed configure OCSS
()
Oracle versus MSSql
()
Oracle Workspace Manager first timer
()
Are there any views to see how often a datafile autoextends?
()
Exclusive Lock on Table
()
Rebuilding an Index
()
full Script to install XML DB on 9i
()
Oracle 9.i
()
11g EM Host password incorrect
()
Purge Script
()
how to reisze the redolog files...
()
hide column from user
(19 Dec 2007 17:53:35)
How to grant read only access to user for a particular schema
(19 Dec 2007 17:6:29)
Reading contents of .dmp file
(19 Dec 2007 16:42:27)
SQL select to retrieve next N rows of data
(19 Dec 2007 16:5:51)
Changing STANDBY_ARCHIVE_DEST for Data Guard
(19 Dec 2007 15:51:12)
User/tables created on wrong tablespace - help!
(19 Dec 2007 15:21:56)
Random listeners die
(19 Dec 2007 15:12:31)
Re: failure notice
(19 Dec 2007 15:10:50)
how to get rsponse mail.
(19 Dec 2007 13:40:42)
NLS???
(19 Dec 2007 13:9:42)
Oracle issue - end-of-file on communication channel due to recursive execution
(19 Dec 2007 12:54:36)
Number of DB_FILES too high
(19 Dec 2007 12:51:26)
Data gatherer [SEC=UNCLASSIFIED]
(18 Dec 2007 21:42:22)
Statpack report
(18 Dec 2007 20:9:32)
no one can connect as sys
(18 Dec 2007 19:28:54)
ASM candidate disks - Oracle's solution which worked for me
(18 Dec 2007 18:51:54)
Are Proprietary Databases Doomed?
(18 Dec 2007 18:15:2)
Re: Listener stop script with password
(18 Dec 2007 15:42:10)
I need to find out if a db user has access to dbms_stats package
(18 Dec 2007 15:2:27)
Error while importing from dump file
(18 Dec 2007 13:58:39)
how to write a query to.....................
(18 Dec 2007 13:28:1)
Maximum number of connections and timeout
(18 Dec 2007 12:27:49)
Database link works fine when used in a sqleditor but does not work when used in a Procedure.
(18 Dec 2007 11:31:4)
Please Help
(18 Dec 2007 11:23:36)
hot backup and restore steps
(18 Dec 2007 10:19:39)
Alternative for table swap
(18 Dec 2007 10:6:15)
Re: Problem Creating Java Source
(18 Dec 2007 9:33:29)
Movinb of table from one large tablesapce to small tablespace...
(18 Dec 2007 8:38:10)
Parse to Execution Ratio
(18 Dec 2007 8:3:14)
CONTAINS??
(18 Dec 2007 1:27:9)
Unique Index problem
(17 Dec 2007 21:41:59)
problem in parameter cursor...
(17 Dec 2007 17:31:6)
Help in RMAN backup
(17 Dec 2007 15:45:8)
Avoiding index
(17 Dec 2007 14:45:41)
thousands of forks for /oracle/product/crs/opmn/bin/ons -d ; how to get rid of or decrease it
(17 Dec 2007 14:44:44)
PLSQL parameter passing
(17 Dec 2007 13:35:49)
problems with utlrp in 10g?
(17 Dec 2007 12:3:31)
Grants to all schemas dynamically
(17 Dec 2007 8:0:32)
Oracle 10g -- Import failed -- Segmentation Fault
(17 Dec 2007 6:18:1)
Réf. : RE: import from 10g to 8.17 (unix platform)
(14 Dec 2007 19:18:52)
Upgrading from 9i to 11g
(14 Dec 2007 17:9:12)
Unicode
(14 Dec 2007 16:18:26)
awrrpt report
(14 Dec 2007 15:24:15)
pb connexion SAP & Oracle
(14 Dec 2007 12:1:14)
nonprintable characters in the table data?
(14 Dec 2007 11:41:41)
Changing sga_size
(14 Dec 2007 0:4:47)
October Critical patch
(13 Dec 2007 18:0:44)
Re: METHOD FOR ADDING SECOND NODE WITH 10.2.03 PATCHSET12.
(13 Dec 2007 17:54:33)
When was a Procedure or Package executed?
(13 Dec 2007 13:44:38)
How to know ?
(13 Dec 2007 13:40:13)
Re: unable to allocate 4160 bytes of shared memory
(13 Dec 2007 13:22:52)
Scheduling a backup job via Enterprise Manager
(13 Dec 2007 12:51:54)
Sql script to get difference between two schemas in two databases in Oracle with out using any schemas.
(13 Dec 2007 8:26:56)
Re: internal error code, arguments: [kcbnew_3], ...
(13 Dec 2007 7:57:31)
Where to find oracle Enterprise Manager Database Console
(13 Dec 2007 7:23:9)
how to flush v$recovery_file_dest values
(13 Dec 2007 6:20:42)
Proxy Authentication
(12 Dec 2007 22:24:16)
ORA-01406 from a perl script using DBI package
(12 Dec 2007 21:45:29)
ODBC ERROR
(12 Dec 2007 20:50:5)
10 application server
(12 Dec 2007 13:43:30)
Database creation
(12 Dec 2007 13:40:30)
Oracl 10g with vb6
(12 Dec 2007 13:4:40)
Problems with Database SID change - ora-01161
(12 Dec 2007 11:4:40)
SQL 2000 Server DB to Oracle 10G DB
(12 Dec 2007 10:5:3)
To selcet a Clob field XML Data
(12 Dec 2007 9:22:17)
how to install oracle
(12 Dec 2007 8:55:48)
Memory Leaks
(12 Dec 2007 6:54:43)
materialized view on lob column across DB link
(12 Dec 2007 5:31:52)
Scheduling Jobs >>>>
(11 Dec 2007 19:45:11)
Re: cannot identify/lock data file 92 - see DBWR trace file ORA-01110: data file 92: '/u01/app/oracle/product/10.1/db/dbs/auto_billing01.dbf'
(11 Dec 2007 14:22:51)
perform Checkpoint process
(11 Dec 2007 13:47:41)
Re: exception encountered : Address not mapped to object
(11 Dec 2007 13:23:6)
CASE statement in Where clause
(11 Dec 2007 12:2:55)
Pb démarrage SAP & ORACLE
(11 Dec 2007 9:5:19)
How to get the isqlplus
(11 Dec 2007 5:58:30)
import from 10g to 8.17 (unix platform)
(11 Dec 2007 3:30:51)
Import Errors
(10 Dec 2007 22:40:47)
GSD wouldn't start
(10 Dec 2007 22:31:42)
Restoring an Oracle DB to another server with no info.
(10 Dec 2007 20:8:22)
Changing the SGA Size
(10 Dec 2007 18:25:29)
Oracle to Microsoft Access ODBC issues - duplicate rows returned in ODBC Access but not in Sqlplus
(10 Dec 2007 17:52:28)
Re: RMAN Restore into a diferent Machine
(10 Dec 2007 17:48:9)
response file for oracle install
(10 Dec 2007 17:35:49)
Using a response file
(10 Dec 2007 16:54:20)
Re: !!!SPAM!!!: Error ORA-01620: no public threads are available for mounting
(10 Dec 2007 16:16:38)
ASCII file creation from Large Table data content
(10 Dec 2007 16:10:27)
DBA_HIST_SNAPSHOT-urgent Help
(10 Dec 2007 12:38:6)
india localization patch
(10 Dec 2007 12:31:22)
Error ORA-01620: no public threads are available for mounting
(10 Dec 2007 11:57:38)
Migration to RAC
(10 Dec 2007 6:3:16)
QUERY RUN TIME
(9 Dec 2007 7:1:24)
slow query - help
(8 Dec 2007 1:2:17)
Duplicating a database
(7 Dec 2007 23:23:19)
Migrating from 9i db to 10g db.
(7 Dec 2007 21:37:36)
display/save too many columns
(7 Dec 2007 18:3:31)
indexing a warehouse
(7 Dec 2007 17:22:56)
Oracle 10G ASM instance can't find on Linux
(7 Dec 2007 16:45:45)
JI Lock Contention
(7 Dec 2007 15:56:15)
How to use a string function in sqlldr control file on a CLOB field
(7 Dec 2007 15:2:58)
Re: TNS:protocol adapter error
(7 Dec 2007 14:41:23)
Ref Cursor Data to Excel Format
(7 Dec 2007 14:33:5)
alternative to isqlplus
(7 Dec 2007 14:22:5)
undo tablespace size
(7 Dec 2007 12:56:8)
export a table
(7 Dec 2007 11:47:17)
unwrap a PL/SQl procedure
(7 Dec 2007 10:19:54)
Check auto extend on tablespace
(7 Dec 2007 8:23:4)
ORA-12502 error!!!
()
Urgent ?????
()
sqlbacktrack question
()
OCP Exam
()
oracle portal issue
()
package variable as a procedure parameter value?
()
host credentials
()
Ingress
()
sftp via an oracle procedure?
()
alter database open; ORA-00600: internal error code, arguments
()
UTL_FILE Permissions
()
constraint issue
()
Cron scheduled job Unix
()
Date format
()
Data Migration with Scrambling
()
which backup is better?
()
Creating stand by database on remote system
()
when&What was the LAST DML operation was performed on table
()
IMPORT Issue
()
Complie issue
()
Scheduling Job !!!!
()
DB autostart error
()
encryption key length
()
Sale group by 3 days
()
setting autoextend on tablespace
()
Query Issue
()
Display output using IN clause
()
Oracle Application Server and Portal
()
Oracle connections from Proc Executables
()
ora-12505:tns:listener does not currently know of SID given in connect descriptor".
()
Error During LDAP Access using DBMS_LDAP package
()
auditing - 10G
()
Oracle BI Discoverer 10g install: hardware/architecture config recommendations
()
ORA-00942 from a Stored Procedure
()
Mview error
()
Select any Table priv
()
basic sql question
()
SQLPLUS scripting
()
Sql Loader
()
how to create a csv file?
()
Storing Text
()
Generate table script..
()
import
()
REDO CORRUPTION PROBLEM
()
Oracle Client install - Can it be automated?
()
Backup Restore Question
()
Could not open trace file for tkprof.
()
About Past Export ?
()
How to import procedures only from one schema to another schema.
()
ORA-09925 while recreating database
()
Oracle at Fedora Core 8
(3 Dec 2007 10:36:47)
error tns on oracle 817 32b on AIX5.3
(3 Dec 2007 7:48:3)
Identifying Unused Indexes
(3 Dec 2007 6:50:33)
step to restor the rman backup on widows server
(3 Dec 2007 5:46:5)
Becoming an Oracle DBA
(3 Dec 2007 4:27:15)
Creating a new database
(2 Dec 2007 22:38:44)
start emagent on Sun solaris
(2 Dec 2007 14:52:46)
oracle lazydba home page