Oracle

July 2007

Materialized View
(31 Jul 2007 23:34:36)
File upload
(31 Jul 2007 21:48:4)
Error when applying patch to RAC instance
(31 Jul 2007 20:47:52)
Re: 'beforereport': Unknown user exit
(31 Jul 2007 20:12:38)
Help database not working
(31 Jul 2007 19:0:31)
Severe Performance degradation while using LOB
(31 Jul 2007 18:52:4)
Prefixing zeros for a number column value
(31 Jul 2007 17:49:17)
MS-SQL 2005 and Data Import Wizard
(31 Jul 2007 17:48:34)
Uncompress csv file over FTP
(31 Jul 2007 14:45:38)
schedual on windows to load data
(31 Jul 2007 14:43:40)
RAC 10G load balancing
(31 Jul 2007 14:38:13)
Procedure script code using SQL prompt in Oracle: Which command?
(31 Jul 2007 14:18:40)
Re: unrecognized statement in the export file:
(31 Jul 2007 12:39:22)
BLANK DATE IN FILE SQLLOADER
(31 Jul 2007 11:37:15)
Re: OCP Developer 9i
(31 Jul 2007 11:7:17)
GRANT CREATE TEMPORARY TABLES to user on 9.0.1.0
(31 Jul 2007 11:4:15)
Resize UNDOTBS01.DBF
(31 Jul 2007 10:33:6)
OCP DBA 9i
(31 Jul 2007 10:27:16)
Oracle Listener problem when accessing thru CITRIX
(31 Jul 2007 10:8:33)
How to install Oracle Forms and Reports 9i
(31 Jul 2007 9:58:23)
Force deletes to use indexes.....(my 1st email!)
(31 Jul 2007 9:41:56)
regarding OCP DBA 9i
(31 Jul 2007 8:29:50)
Hide Code
(31 Jul 2007 8:6:4)
elapsed_time in v$sqlarea
(31 Jul 2007 8:1:39)
How do I find a user password?
(31 Jul 2007 7:57:11)
tune sqlldr
(31 Jul 2007 7:56:17)
How to reclaim space on Unix on removing user datafiles
(31 Jul 2007 5:46:15)
Encryption Required
(31 Jul 2007 5:40:51)
replication error
(31 Jul 2007 4:27:28)
How to improve the insertion time
(31 Jul 2007 0:27:43)
Exporting error EXP-00091
(30 Jul 2007 18:57:49)
For all your Peoplesoft folks
(30 Jul 2007 12:47:21)
Speed Number verses varchar primary key.
(30 Jul 2007 12:23:32)
Long to char conversion - 9i
(30 Jul 2007 12:8:3)
Non-Duplication records
(30 Jul 2007 11:49:21)
Views vs Materialized Views
(30 Jul 2007 11:43:40)
DOS PROGRAMMING.convert .csv to .txt
(30 Jul 2007 6:57:53)
ORA 00376
(30 Jul 2007 3:25:20)
Replication
(29 Jul 2007 11:56:46)
compress in Exp
(28 Jul 2007 21:31:39)
LISTOWNER- EMAIL SHIELDING
(28 Jul 2007 13:0:2)
To Analyze or Not To Analyze
(27 Jul 2007 23:6:58)
Oracle 10g - Host Credentials question
(27 Jul 2007 17:57:47)
Error PLS-00201: identifier 'X$KGLOB' must be declared
(27 Jul 2007 17:39:42)
Mathmetics and Timestamp
(27 Jul 2007 15:18:20)
Mathmetics and Timestamps
(27 Jul 2007 15:14:15)
forms 6i (execute_query)
(27 Jul 2007 14:45:20)
Running system commands for PL/SQL
(27 Jul 2007 14:41:2)
Oracle 11G
(27 Jul 2007 14:33:2)
problem with sequence
(27 Jul 2007 14:30:3)
bulk collect
(27 Jul 2007 13:8:2)
Change character set after creation of database
(27 Jul 2007 11:48:51)
Problem connecting to DB
(27 Jul 2007 10:57:47)
Problem with auditing
(27 Jul 2007 8:45:43)
please help with Table Space questions
(27 Jul 2007 5:29:56)
Dropping Oracle Database
(27 Jul 2007 5:27:26)
Exists and Not Exists in 10g are very slow
(27 Jul 2007 5:8:58)
Returning content!
(26 Jul 2007 19:18:46)
LOGON LOGOFF triggers
(26 Jul 2007 18:41:0)
ORA-00824 after adjusting memory parameters
(26 Jul 2007 16:56:23)
ORA-12157 on AIX
(26 Jul 2007 15:3:14)
Oracle 11G (Data Pump and RMAN)
(26 Jul 2007 14:36:5)
Not able to connect through sqlplus without connecting string from unix
(26 Jul 2007 13:34:31)
Oracle Generic Select
(26 Jul 2007 13:0:11)
Dodgy SQL
(26 Jul 2007 12:51:37)
run OS commands from Oracle
(26 Jul 2007 12:45:51)
Memorey usage in Oracle by runnig particular function??
(26 Jul 2007 12:45:37)
Database Instances
(26 Jul 2007 12:19:36)
URGENT
(26 Jul 2007 11:25:46)
Help invalid triggers
(26 Jul 2007 11:10:19)
transports in SAP
(26 Jul 2007 10:55:23)
Rrgarding sys_refcursors
(26 Jul 2007 10:50:5)
DataGuard Implementation manually
(26 Jul 2007 9:0:8)
sys_refcursors
(26 Jul 2007 8:30:39)
Use of AUDIT_SYSLOG_LEVEL
(26 Jul 2007 4:45:51)
Directory with a minus sign
(26 Jul 2007 4:37:4)
PL/SQL question
(25 Jul 2007 21:3:42)
stupid question
(25 Jul 2007 20:50:30)
Grid
(25 Jul 2007 19:16:43)
help with regexp
(25 Jul 2007 18:47:48)
Automating an import/export across different servers
(25 Jul 2007 13:5:24)
Conflict between the installations of Oracle 9i and D2K
(25 Jul 2007 11:59:48)
can cursor can have default values
(25 Jul 2007 10:30:22)
Restoring RMAN backup through Tivoli Storage Manager
(25 Jul 2007 10:5:23)
Table fragmentation
(25 Jul 2007 9:28:37)
Oracle error
(25 Jul 2007 7:17:42)
import with differents tablespaces...( 9i version )
(25 Jul 2007 6:52:59)
Re: Targets not providing data 10g
(25 Jul 2007 6:51:20)
sql *Net event.
(25 Jul 2007 6:16:45)
Urgent : Datafile in oracle
(25 Jul 2007 6:10:5)
Tuning import parameters
(25 Jul 2007 5:20:57)
forms 6i
(25 Jul 2007 5:20:20)
10g Installer Problem
(25 Jul 2007 5:14:37)
Backward Compatible Export
(25 Jul 2007 4:44:59)
TDPO error
(24 Jul 2007 19:57:10)
SGA in Linux RHEL 4 32-bit
(24 Jul 2007 16:55:45)
Réf. : RE: import with differents tablespaces...( 9i version )
(24 Jul 2007 15:48:35)
ROLE passwords
(24 Jul 2007 15:25:37)
Re: SQL Tuning Plea
(24 Jul 2007 15:6:50)
iscsi anyone?
(24 Jul 2007 14:31:42)
RMAN to NAS device
(24 Jul 2007 6:13:7)
Syntax Assistance
(24 Jul 2007 5:11:17)
Histograms and Statistics
(23 Jul 2007 19:30:43)
Oracle 9i 9.2.0.8 Install
(23 Jul 2007 19:16:57)
export with pipe
(23 Jul 2007 14:14:46)
Oracle id known as SCVOOR5?
(23 Jul 2007 14:14:34)
Targets not providing data
(23 Jul 2007 13:40:40)
Recommended size of TEMP tablespace
(23 Jul 2007 12:37:56)
LAST_QUERY VALUE ??
(23 Jul 2007 12:30:33)
What could be the reason for this warning message?
(23 Jul 2007 9:33:32)
Change Name of Server
(23 Jul 2007 8:42:51)
Moving data from Oracle 7 to Oracle 8i
(22 Jul 2007 20:29:43)
job in florida
(21 Jul 2007 20:27:40)
size of tables
(21 Jul 2007 18:26:58)
Problem with FULL OUTER JOIN in Oracle 10G.
(21 Jul 2007 14:47:41)
Oracle _ Pivoting Columns into Rows
(21 Jul 2007 13:6:36)
FRX
(20 Jul 2007 21:29:10)
Expensive Delete Statement
(20 Jul 2007 19:2:9)
CPU_TIME in V$SQL
(20 Jul 2007 18:3:50)
Cant Serialized this transaction
(20 Jul 2007 17:31:34)
Réf. : RE: Réf. : RE: job oracle dba in switzerland...
(20 Jul 2007 14:18:42)
Re: Urgent libcwait Script
(20 Jul 2007 12:51:44)
Réf. : RE: job oracle dba in switzerland...
(20 Jul 2007 12:0:4)
Coverting Microsoft Excel data to Oracle dataBase
(20 Jul 2007 8:7:7)
DATAFILE
(20 Jul 2007 8:6:24)
Oracle Backup Job Hanging with "Stop Pending"
(20 Jul 2007 5:19:46)
Oracle7 for Windows
(20 Jul 2007 2:53:2)
SQL%ROWCOUNT not working
(19 Jul 2007 23:44:50)
killing Sniped and inactive session.
(19 Jul 2007 21:19:27)
TRANSACTION STATISTICS!!!
(19 Jul 2007 20:19:37)
Réf. : RE: Réf. : RE: Réf. : RE: job oracle dba in switzerland...
(19 Jul 2007 18:56:17)
job offer in switzerland
(19 Jul 2007 18:18:56)
oracle 10g takes 90% prosessor usage.
(19 Jul 2007 17:7:3)
Installing Oracle9i RDBMS Software on Linux
(19 Jul 2007 15:34:56)
Calculatingf Table Space Growth.
(19 Jul 2007 15:12:44)
job oracle dba in switzerland...
(19 Jul 2007 13:58:54)
Re:JDK home
(19 Jul 2007 13:46:3)
high parse to execute ratio .... Help
(19 Jul 2007 13:2:50)
Oracle Installation problem
(19 Jul 2007 12:55:28)
Backup Job Hanging with "Stop Pending"
(19 Jul 2007 10:53:24)
Installing Oracle on Linux
(19 Jul 2007 8:44:43)
SYS/SYSTEM password
(19 Jul 2007 8:39:13)
system tablespace resizing
(19 Jul 2007 7:57:47)
ORA-02420 while creating a new schema
(19 Jul 2007 4:24:56)
block size 16384 does not match
(19 Jul 2007 3:29:2)
Best practice to upgrade 9.2.0.5 on old server to 10.2.0.3 on a different server
(19 Jul 2007 1:30:16)
Oracle 10g hangs. Help!!
(19 Jul 2007 1:3:37)
experts
(18 Jul 2007 20:35:14)
Question about gather schema stats
(18 Jul 2007 18:59:37)
Who Locked the User?
(18 Jul 2007 18:51:58)
Re: line 1, column 7:
(18 Jul 2007 16:2:7)
mySQL import into Oracle
(18 Jul 2007 16:1:58)
Error while trying to restore controlfile from autobackup
(18 Jul 2007 15:12:2)
Re: oracle9i (9.2.0.4.0) RDBMS software on Fedora core
(18 Jul 2007 11:45:12)
Delete by ROWID take to much Time.
(18 Jul 2007 11:44:53)
Connect by Prior in Oracle 9i
(18 Jul 2007 11:41:29)
RMAN help
(18 Jul 2007 11:30:47)
Multiple databases on a single server
(18 Jul 2007 10:48:36)
tablespace
(18 Jul 2007 10:45:27)
How To calculate the DB Size in Oracle?
(18 Jul 2007 10:43:58)
through which view we could see complete create table syntax
(18 Jul 2007 10:4:3)
View DDL for an object
(18 Jul 2007 10:3:31)
Rman delete based on apply
(18 Jul 2007 9:48:51)
CREATE TABLESPACE userdata
(18 Jul 2007 6:37:57)
change the character set on a database
(18 Jul 2007 6:35:18)
online backup script oracle10g in UNIX.
(18 Jul 2007 6:25:40)
Re: Oracle9i (9.2.0.4.0) RDBMS software installation
(18 Jul 2007 6:23:12)
high water mark
(18 Jul 2007 6:4:21)
How to create alert
(18 Jul 2007 4:36:19)
how to empty the undo tablespace
(18 Jul 2007 2:31:55)
can oracle 9i database (R2) install on win vista?
(18 Jul 2007 1:29:30)
empty_clob
(17 Jul 2007 21:53:12)
hi
(17 Jul 2007 21:12:12)
error on commit?
(17 Jul 2007 20:5:30)
regexp_count
(17 Jul 2007 19:37:52)
dblink_encrypt_login
(17 Jul 2007 17:56:15)
Agent Unreachable
(17 Jul 2007 15:51:32)
Re: what is the actual difference between delete and truncate.
(17 Jul 2007 15:49:8)
Basic question I know. check all users with dba auth
(17 Jul 2007 15:22:33)
UNIX -v- Windows
(17 Jul 2007 15:2:56)
SCRIPT FOR RESTORATION
(17 Jul 2007 12:45:49)
How to list all schema in a database in unix
(17 Jul 2007 11:22:41)
what is the actual difference betwwen delete and truncate.
(17 Jul 2007 10:15:45)
Oracle 8i drop tablespace with multiple datafiles
(16 Jul 2007 21:7:30)
ensuring that oracle 8174 indexes are ok..... not physically corrupt
(16 Jul 2007 20:36:55)
Oracle 11G (Passwords)
(16 Jul 2007 17:49:15)
11g Launch
(16 Jul 2007 16:37:41)
11g is out!
(16 Jul 2007 16:11:51)
Incremental checkpoint
(16 Jul 2007 15:11:59)
oracle standby db
(16 Jul 2007 12:50:47)
StarTeam configuration management tool
(16 Jul 2007 9:7:25)
Granting privileges
(16 Jul 2007 9:4:37)
frm-40735 - anyone have experience with this? production outage situation
(16 Jul 2007 6:43:52)
hi all..gudmrng....one help..
(16 Jul 2007 6:33:48)
if there is a good way to determine if someone manually deleted the row from the sys.dual table?
(16 Jul 2007 5:22:30)
default values of procedure in user_arguments table unable to see
(16 Jul 2007 4:1:20)
Cold Backup RMAN help
(15 Jul 2007 20:17:10)
trace_enabled
(15 Jul 2007 16:17:23)
replace java system fails on Oracle 8.1.7.4 patch install
(15 Jul 2007 15:29:39)
system tablespace locally managed?
(15 Jul 2007 15:18:18)
AUDIT_TRAIL
(15 Jul 2007 15:0:20)
aargh dbms_metadata.
(14 Jul 2007 17:49:59)
How to determine how the dual table had row deleted?
(14 Jul 2007 14:30:11)
Urgent Help!!!!!!!!
(14 Jul 2007 9:58:33)
third party application export of data very slow after migrating to 10g
(14 Jul 2007 8:40:24)
convert two columns of data to one
(13 Jul 2007 22:27:35)
Re: can run one database on two instances
(13 Jul 2007 22:14:42)
can run one database on two instaces
(13 Jul 2007 21:42:0)
RDA Tool on Solaris 2.9 8174
(13 Jul 2007 21:24:23)
Performance: Oracle 10gXE vs Oracle 10gSE
(13 Jul 2007 18:57:43)
My sad java story
(13 Jul 2007 16:42:23)
Re: How to get multiple row contents in single column.
(13 Jul 2007 16:36:48)
Kathy - 11g project
(13 Jul 2007 16:23:17)
RMAN standby database recommendation for SE
(13 Jul 2007 13:33:16)
Oracle 10G
(13 Jul 2007 13:25:2)
DBA_LOCKS
(13 Jul 2007 13:19:6)
Trigger Problem
(13 Jul 2007 12:44:51)
FRM-92101
(13 Jul 2007 10:2:47)
Left outer Join
(13 Jul 2007 9:41:31)
RAC FAIRNESS THRESHOLD Question
(13 Jul 2007 8:17:35)
where do i fine procedure default values
(13 Jul 2007 8:8:44)
Negation of subexpressions in regexp_like...
(13 Jul 2007 7:30:57)
Please help on Ora-04013
(13 Jul 2007 6:21:5)
user createtion without default tablespace
(13 Jul 2007 5:16:40)
SQL Tuning
(13 Jul 2007 4:32:38)
Recall: Need to audit the sys userid
(12 Jul 2007 21:12:40)
Need to audit the sys userid
(12 Jul 2007 20:30:4)
gather stats v/s analyse table
(12 Jul 2007 20:5:18)
OEM Configuration Question(s)
(12 Jul 2007 17:40:34)
Java version
(12 Jul 2007 17:31:6)
exp 8.1.7 to 10g
(12 Jul 2007 16:58:48)
Help with grouping query
(12 Jul 2007 15:51:59)
errors when trying to backup via OEM
(12 Jul 2007 15:44:1)
migration to 10g w/standby
(12 Jul 2007 15:30:52)
Oracle Agent fails to start on Linux
(12 Jul 2007 14:51:37)
increase ulimit DATA on HPUX B11 11
(12 Jul 2007 14:33:21)
Help with query please
(12 Jul 2007 10:51:45)
AWR Question
(12 Jul 2007 10:24:33)
Install statspack on 9.2.0.7
(12 Jul 2007 10:23:57)
FRM-92101 Error
(12 Jul 2007 8:31:39)
Oracle and VSS
(12 Jul 2007 7:48:32)
page width
(12 Jul 2007 5:52:45)
regarding stored procedure convertor
(12 Jul 2007 5:36:56)
Question for one and all
(12 Jul 2007 3:15:53)
help with Explain Table
(11 Jul 2007 19:54:28)
Personal Oracle 9
(11 Jul 2007 18:13:30)
db_block_size 16k
(11 Jul 2007 17:54:35)
How do I import data from a csv file into oracle table
(11 Jul 2007 16:13:54)
export schema except two tables
(11 Jul 2007 16:11:16)
Oracle Merge Statement
(11 Jul 2007 14:27:44)
basics
(11 Jul 2007 11:42:59)
Oracle 9i on several IP simultaneously
(11 Jul 2007 11:30:25)
hello
(11 Jul 2007 10:37:32)
significane of OPTIMIZER_DYNAMIC_SAMPLING
(11 Jul 2007 9:3:55)
import
(11 Jul 2007 7:18:10)
ORA-01167
(11 Jul 2007 5:49:52)
Range Partitioning
(11 Jul 2007 4:31:29)
ORA-01722 Invalid Number!
(10 Jul 2007 18:34:27)
Change the Db_domain Parameter .
(10 Jul 2007 18:24:42)
Manamgement Agents with RAC
(10 Jul 2007 17:37:39)
VPN IPSec Aix to Windows
(10 Jul 2007 15:40:14)
Multihomed instance
(10 Jul 2007 14:49:0)
ORA-25153
(10 Jul 2007 14:0:26)
Oracle and Db2
(10 Jul 2007 13:10:13)
How to find the time taken by one dbms_job
(10 Jul 2007 13:9:18)
moving flash recovery area
(10 Jul 2007 12:6:16)
How to import data in oracle9i/10g exported from db2on windows os
(10 Jul 2007 8:1:36)
PC is restarting
(10 Jul 2007 6:42:24)
Unable to connect to SQL
(9 Jul 2007 18:9:29)
upgrade to 10g
(9 Jul 2007 17:43:21)
EMC CX300 / Snapview and Oracle 10.1.0.4 Standard
(9 Jul 2007 15:35:58)
Backing up 10g with 9i RMAN?
(9 Jul 2007 15:28:3)
Permissions needed to create views
(9 Jul 2007 13:59:2)
SQLPLUS Authentication with third party ldap server
(9 Jul 2007 13:49:48)
TNS Listener error when in workgroup
(9 Jul 2007 13:36:24)
oracle report 10g not able to call from XP
(9 Jul 2007 13:27:32)
ora-1653
(9 Jul 2007 13:23:45)
hi all...
(9 Jul 2007 8:19:21)
reorganisation of tablespace
(9 Jul 2007 7:23:41)
dbms_metadata
(7 Jul 2007 13:55:12)
SHUTDOWN TRIGGER NOTIFICATION
(7 Jul 2007 11:36:5)
Error while importing
(7 Jul 2007 8:36:35)
RMAN - Upgrading from 9i to 10g
(6 Jul 2007 16:41:0)
Recall: aargh dbms_metadata.
(6 Jul 2007 16:10:54)
ORA-22992 - Syncronizing BLOB Columns
(6 Jul 2007 12:21:47)
sqlldr: ORA-01847: day of month must be between 1 and last day of month
(6 Jul 2007 11:42:9)
Application Server!
(6 Jul 2007 11:41:24)
Export error
(6 Jul 2007 8:13:55)
EXPORT TAKES USUALLY LONG TIME TO COMPLETE
(6 Jul 2007 8:2:45)
Dropping of Snapshot log
(6 Jul 2007 4:10:45)
Re - Database Control - User Credentials Error
(5 Jul 2007 20:21:1)
problem opening database
(5 Jul 2007 18:27:3)
java
(5 Jul 2007 12:59:3)
how to sort out with this error ora-01034 ora-27101
(5 Jul 2007 10:21:14)
hi all
(5 Jul 2007 6:37:10)
RE:j2re-1_3_1_15-linux-i586.bin
(5 Jul 2007 5:8:50)
Connecting to Oracle
(4 Jul 2007 10:38:50)
How to find Oracle Installation Details
(4 Jul 2007 10:33:29)
import to 8i from 9i
(4 Jul 2007 10:29:34)
error in opening database file
(4 Jul 2007 9:14:0)
Réf. : RE: import to 8i from 9i
(4 Jul 2007 8:16:0)
how to calculate size of a row's columns in a table
(4 Jul 2007 8:12:13)
user_tab_column
(4 Jul 2007 7:35:21)
standard to enterprise upgrade
(3 Jul 2007 18:41:0)
Diff Between Count( * ) and Count( 1 )
(3 Jul 2007 15:18:55)
what is wrong?
(3 Jul 2007 14:27:59)
OIDCA failed to configure
(3 Jul 2007 13:10:11)
problem in shutdown the database
(3 Jul 2007 11:6:6)
how to identify the users those are using dblink through OEM.
(3 Jul 2007 10:23:1)
one query...
(3 Jul 2007 9:27:18)
Oracle 10g question
(3 Jul 2007 8:53:8)
table space system
(3 Jul 2007 8:44:26)
unix script question
(3 Jul 2007 6:3:24)
Re - Sqlplus / TNSPING issue
(3 Jul 2007 3:31:4)
QUERY_REWRITE_INTEGRITY
(2 Jul 2007 23:7:35)
any body help pl. output in single line
(2 Jul 2007 18:33:3)
Re: [SPAM] - what is wrong? - Number of numbers in MIME From exceeds maximum threshold
(2 Jul 2007 17:40:34)
help in Dynamic SQL
(2 Jul 2007 9:26:23)
ORA-01882
(2 Jul 2007 8:23:34)
Recall: Diff Between Count( * ) and Count( 1 )
(1 Jul 2007 23:25:42)
ORACLE FORMS
(1 Jul 2007 21:38:37)
ORA-12514
(1 Jul 2007 11:11:8)
recovery error
(1 Jul 2007 10:27:4)
oracle lazydba home page