Oracle

May 2004

Just your thoughts please
(2 Jun 2004 08:30:41)
TEMP TABLESPACE BECOMES TOO LARGE
(1 Jun 2004 07:23:47)
What is LCKn
(31 May 2004 17:57:47)
Oracle Exam Crams
(31 May 2004 17:56:57)
Re: Oracle Corp Question
(1 Jun 2004 13:08:31)
How To Install Oracle6i in silent mode
(1 Jun 2004 04:41:09)
Using 4 Processors in a query.
(1 Jun 2004 17:29:45)
Dblink Query Issues
(31 May 2004 12:49:10)
test mail pl ignore........
(31 May 2004 12:33:32)
Urgent ......error while installing oracle 9i on redhat linux 9
(31 May 2004 12:24:16)
Installing oracle 8.0 client on 9i Database Server Machine in WIndows 2003
(31 May 2004 11:56:52)
Automatic Shut-down
(31 May 2004 12:36:10)
improving - Export and import parameter
(1 Jun 2004 18:27:07)
10g AS installation.
(31 May 2004 10:48:33)
let me know
(31 May 2004 10:19:56)
Hw to generate Password file?
(31 May 2004 13:08:04)
Urgent help required .How to send message from one system to another
(31 May 2004 10:13:22)
Need a shell Script
(31 May 2004 09:17:26)
using inconsistent backup for standby database
(31 May 2004 08:48:46)
View Definition
(2 Jun 2004 04:53:37)
4 problems encountered while installing oracle 9i on redhat linux 9.0
(31 May 2004 07:38:19)
duplicate constraints
(31 May 2004 05:41:48)
sms system
(31 May 2004 12:52:05)
Oracle 10g As - logs
(2 Jun 2004 14:39:47)
I/O Tuning
(31 May 2004 04:51:49)
Online Redo Log Group or Members
(30 May 2004 22:02:55)
Online Redo Log Group or Member
(30 May 2004 22:02:07)
Serial# is keep increasing after Session was Killed
(30 May 2004 19:40:34)
Recovering from a lost/corrupted SYSTEM tablespace
(31 May 2004 04:42:13)
Scheduling a procedure to run at Mid Night ( DBMS Package) -- Oracle 9i rel 2
(30 May 2004 12:55:53)
server sqlnet tracing
(30 May 2004 07:00:44)
view datastructure in oracle without using oem
(30 May 2004 19:25:34)
fedora core 2
(30 May 2004 20:11:44)
Access Database Remotely
(29 May 2004 05:37:02)
Réf. : Export Problem
(29 May 2004 03:36:09)
Split export script
(1 Jun 2004 20:38:06)
Inventory list
(28 May 2004 19:48:59)
Re: Oracle Forms / Reports books
(28 May 2004 20:28:08)
How to a value from sqlplus a shell variable
(29 May 2004 03:26:17)
LISTOWNER- more on blank emails
(28 May 2004 18:13:58)
user_privs
(3 Jun 2004 17:39:17)
CLOB loggging command
(9 Jun 2004 22:33:27)
Database on OEM
(28 May 2004 15:59:28)
help !! oerr ora 06550
(28 May 2004 16:04:53)
Bad block solution
(28 May 2004 14:36:56)
Get name of package, procedure, function through sql trace
(28 May 2004 14:12:04)
Pseudo columns 10g
(28 May 2004 14:52:16)
Increase session connections
(28 May 2004 17:30:12)
Truncate Versus Delete - Plz help
(28 May 2004 14:23:33)
[Q] how to startup/shutdown 10g OEM agent?
(28 May 2004 13:04:12)
How database design/development projects are estimated
(29 May 2004 06:55:03)
RAID setups
(28 May 2004 12:57:45)
Cannot upload large files into Oracle IFS (or CMSDK) using DocumentDefinition.setContentStream
(28 May 2004 09:55:57)
Ora 10g and 9i on same machine (Windows 2003)
(28 May 2004 09:47:54)
Index/Constraint Question. repost - please assist if possible
(28 May 2004 09:20:43)
Perl dbd:: oracle 1.03
(28 May 2004 18:40:27)
Windows Batch to stop Oracle Services
(28 May 2004 10:05:27)
PLZ HELP : CONNECT ERROR WHILE USING /
(31 May 2004 00:04:39)
Japanese Language Support :Help required -- Urgent
(28 May 2004 10:51:24)
Need Help to do certification
(28 May 2004 04:35:24)
10g OEM: hot to add other DBs
(27 May 2004 23:28:37)
Discoverer, 9iAS, Oracle Portal
(28 May 2004 16:29:42)
Re: LSNRCTL Syntax for password 9i
(28 May 2004 16:32:56)
Which index to choose for partitioned table
(27 May 2004 20:41:58)
partition exclusion
(27 May 2004 19:37:27)
Splitting of Salary
(29 May 2004 08:51:54)
LISTOWNER- Blank emails from LazyDBA
(27 May 2004 17:23:37)
Software for Creation of Test Databases
(27 May 2004 16:34:29)
Any DBA's supporting IFS ERP applications on Oracle?
(27 May 2004 16:12:52)
ORACLE INTERNAL ERROR [732] PGA
(27 May 2004 15:17:55)
installation errors...
(27 May 2004 14:33:40)
Informix to Oracle Pro*C
(27 May 2004 14:30:59)
Help on Database Import
(27 May 2004 15:08:31)
Re: connection to sys should be as sysdba or sysoper
(27 May 2004 13:30:06)
Migration strategy from 9i to 10G (Windows 2000)
(27 May 2004 15:32:22)
Agent Problems
(27 May 2004 12:45:24)
TOAD for Oracle 9i
(27 May 2004 13:26:05)
What is happening to this index ?
(28 May 2004 09:47:02)
Questionable Statistics in Export
(27 May 2004 13:32:05)
Blank email from LazyDBA
(27 May 2004 15:23:07)
ORACLE UPGRADATION FROM 8.1.5 TO 9.2.0
(27 May 2004 17:19:25)
error in send mail
(28 May 2004 07:56:05)
LSNRCTL & ORACLE STARTUP SCRIPT
(27 May 2004 07:37:05)
Data cleansing tool
(27 May 2004 10:23:33)
export tables from one user to another user
(27 May 2004 07:17:41)
DBMS Scheduler for Sequence
(2 Jun 2004 06:16:08)
Free website for Oracle exercise
(27 May 2004 15:35:54)
Re: DB_BLOCK_SIZE]
(27 May 2004 00:19:01)
Re: small request]
(26 May 2004 23:55:06)
small request
(27 May 2004 14:30:48)
how do I change the maxsize for a datafile?
(27 May 2004 19:39:10)
ODBC Driver Oracle 9.2.0.4
(26 May 2004 21:27:35)
Installing Patchset
(26 May 2004 20:55:27)
exporting from 9.2.0.3 and importing to 9.2.0.5
(26 May 2004 21:29:21)
how often do you bounce Oracle?
(27 May 2004 14:25:06)
Trying to read a external table
(26 May 2004 19:37:48)
SQL-BackTrack by BMC Software
(27 May 2004 19:40:27)
AIX script execution
(26 May 2004 18:55:54)
max dump file size?
(26 May 2004 16:50:03)
distributed_transactions parameter for Oracle 9.2
(26 May 2004 18:49:17)
resumable space management in 9i
(26 May 2004 16:23:56)
LSNRCTL
(27 May 2004 04:41:35)
Killing a user process in the middle of rollback
(26 May 2004 14:53:50)
dbms script
(28 May 2004 19:28:52)
Finding the application or program associated with a query?
(27 May 2004 13:54:55)
Same Procedure some times and fails other times
(26 May 2004 13:11:55)
Object Comparison
(26 May 2004 12:06:12)
STRANGE ORACLE BEHAVIOUR...NEED HELP
(26 May 2004 21:45:32)
Re: must use RESETLOGS or NORESETLOGS option for database open --urgent!
(26 May 2004 16:25:01)
please help me urgent!!!
(26 May 2004 10:29:39)
Problem with IMP huge file (11GB) on WIN2000 Server
(26 May 2004 14:56:46)
Hi lazyDBA's
(26 May 2004 10:28:28)
Informix ESQL/C to Pro*C migration.
(26 May 2004 10:17:26)
if one of the archive file get corrupted
(26 May 2004 11:34:41)
Installer hanged
(27 May 2004 07:48:04)
Manual Creation of 9i DB
(26 May 2004 08:31:34)
Oracle to Terradata: Wise Carrer Move?
(26 May 2004 12:58:45)
Snapshots or Standby Database
(26 May 2004 07:09:31)
NLS_DATE_FORMAT problem -- Urgent
(27 May 2004 14:19:37)
Issues using SYSDBA
(26 May 2004 08:59:32)
SQL Query.
(26 May 2004 06:29:10)
Performance Tuning and Backup/Recovery
(26 May 2004 01:01:46)
RMAN or user managed
(26 May 2004 01:31:52)
Recovering a table or deleted data
(26 May 2004 10:20:30)
Redo log miracle.
(26 May 2004 14:09:37)
sqlplus doesnt' return record as expected
(3 Jun 2004 17:06:47)
Snapshot Log Not Refreshed
(26 May 2004 08:22:09)
last repeat : error occured at recursive SQL level 1 on db table create
(25 May 2004 18:03:23)
Upgrading multiple instances sharing same OH
(26 May 2004 19:06:23)
Re: null password given; logon denied when trying to use a database link
(25 May 2004 17:11:25)
enterprise maanger
(25 May 2004 15:56:48)
[Q] shutdown remote DB before shutdown server
(25 May 2004 15:45:22)
sysdba priviliege
(26 May 2004 19:01:05)
Recommended aix utility for cold backup
(25 May 2004 15:39:55)
SIZING QUESTION
(25 May 2004 15:11:50)
Killing a sqlplus active session
(25 May 2004 18:39:47)
prove analyze table
(25 May 2004 14:56:19)
if one archive in your archive directory is corrupt
(25 May 2004 14:35:42)
Convert a BLOB to an ORDVideo
(25 May 2004 14:05:32)
Alert Log E-mail
(25 May 2004 14:11:58)
Suggestion Req on Storage Parameters !!!
(25 May 2004 12:24:30)
migration of database
(25 May 2004 12:21:33)
How to find nearest date
(25 May 2004 13:39:55)
Definition of Procedure and functions defined in Package
(25 May 2004 10:34:27)
Initial/next extents and db_block_size
(25 May 2004 12:49:40)
SQL for retrieving schema/tables
(25 May 2004 08:27:37)
Redo Logs placing
(25 May 2004 13:02:51)
Import/Export of schema
(26 May 2004 18:35:54)
DB Slow urgent!!!
(25 May 2004 06:54:46)
Interview question - SQL or performance tuning
(25 May 2004 13:51:30)
Interview question - backup and recovery
(25 May 2004 13:53:42)
Interview question - Backup/Recovery
(25 May 2004 06:23:31)
how to get back DML statements!!
(25 May 2004 21:11:48)
Ora-12519
(25 May 2004 07:32:58)
migration of database from oracle8i to oracle9i
(26 May 2004 18:13:49)
decode function to determine if value is in range
(25 May 2004 04:54:34)
Substring or Instr
(24 May 2004 23:26:02)
Re: Extents Size on import
(25 May 2004 11:41:09)
Space used by multiple tables with a single tablespace
(25 May 2004 03:14:35)
desc table / no response
(25 May 2004 17:58:16)
Bad Block
(26 May 2004 17:52:14)
Upgrading to 10g
(24 May 2004 19:58:49)
oem : incorrect login credentials
(25 May 2004 15:59:14)
Modify Tables
(24 May 2004 18:56:59)
drop your index?
(24 May 2004 18:36:11)
Exntents Size on import
(25 May 2004 15:11:44)
Oracle text
(24 May 2004 20:50:58)
Re: similar to Soundex function
(24 May 2004 16:01:53)
Is 8.1.7 desupported?
(24 May 2004 20:11:26)
similar to Soudnex function
(26 May 2004 21:26:50)
Enabling and disabling triggers
(26 May 2004 08:30:19)
REG SQL PERFORMANCE
(24 May 2004 15:06:26)
importing tables
(24 May 2004 16:23:17)
Unable to drop a user
(24 May 2004 15:09:28)
old stats of a table
(24 May 2004 13:10:52)
Help Reqrd from Pune..India urgent pls
(24 May 2004 12:15:17)
Utilizing the processors.
(24 May 2004 10:43:23)
Temporary tablespace coalesce-- Urgent!!
(24 May 2004 11:36:16)
CONNECT BY PRIOR clause
(24 May 2004 09:33:09)
sqlplus sys
(24 May 2004 09:13:56)
TABLESPACE & DATAFILE FRAGMENTATION.
(24 May 2004 09:55:09)
Spatial Identification.
(24 May 2004 09:20:42)
Unable to Install Oracle 9.2.0.1 on RedHat 9
(25 May 2004 00:08:28)
Update column width in Oracle 9i..
(24 May 2004 07:08:50)
Variable substitution
(24 May 2004 10:58:59)
ORA-03113:end of communication file
(24 May 2004 04:29:45)
Getting error while fetching data through DB link..
(24 May 2004 13:17:09)
MS Access COUNT DISTINCT PROBLEM
(24 May 2004 03:27:16)
OMS Nodes
(25 May 2004 17:05:21)
Mass deletion
(23 May 2004 23:14:45)
remote_listener
(23 May 2004 14:14:18)
data in index_stats table
(23 May 2004 12:30:05)
sort_area_size and pga_aggregate_target
(23 May 2004 12:02:02)
Password.
(25 May 2004 06:42:38)
Disk space running out.
(27 May 2004 04:43:06)
Sheduled Export Job & OS User password expiry
(23 May 2004 05:12:31)
'MAN' COMMAND
(22 May 2004 13:32:33)
Conversion of Multiple Rows into single row with multiple column (SQL Help) -- Urgent
(22 May 2004 11:52:19)
Help needed in SQL server 2000:Selecting roes for next/prvious like functionality
(22 May 2004 11:45:56)
Create table from one server to another server
(22 May 2004 11:36:04)
ORACE 9i DS
(22 May 2004 10:09:43)
Help Backup Recovery
(22 May 2004 07:53:21)
exp from Endlish character to Chinese
(22 May 2004 05:52:42)
oracle/mssql database replication interoperability
(22 May 2004 03:54:00)
Performance Tuning and Troubleshooting
(22 May 2004 13:44:27)
Offline File in Hot Backups.
(21 May 2004 20:59:21)
Ora-1031 during create trigger
(21 May 2004 19:21:35)
Data Guard : Failed to request gap sequence
(22 May 2004 09:21:36)
Installation for a Newbie
(24 May 2004 16:10:06)
Get Redhat Enterprise Linux AS equivalent
(21 May 2004 18:56:37)
[Oracle][ODBC][Ora]ORA-04030 HELP!
(21 May 2004 19:16:27)
10g Grid Control Install Issue
(21 May 2004 18:22:14)
Query doesn't use the Proper INDEX
(21 May 2004 20:55:53)
Had to restore system now database won't start
(21 May 2004 17:46:17)
open cursors is over the limit...........WHY?
(21 May 2004 17:07:08)
Last Saturday's Date
(21 May 2004 16:12:12)
Re: no descriptor for this position
(21 May 2004 19:28:01)
Temp tablespace full.
(21 May 2004 16:23:05)
How to read and act upon on Statspack Report ?
(21 May 2004 14:27:06)
Optimal Oracle Block size
(24 May 2004 15:28:29)
cpu per call
(21 May 2004 13:39:56)
exp and imp on two dbs
(24 May 2004 09:05:18)
Cold Backup Scripts
(21 May 2004 12:02:51)
bos.adt.libm library installation on AIX5.1
(21 May 2004 12:40:33)
Oracle Base
(21 May 2004 11:34:52)
QUERY REGARDING CHANGE OF TABLESPACE NAME
(21 May 2004 10:37:30)
Get current session ID
(21 May 2004 18:48:18)
Error creating View...
(21 May 2004 14:44:06)
maximum varchar2 length in pl/sql in 9i
(21 May 2004 09:23:45)
What happens when the archiver is stuck
(21 May 2004 11:50:47)
How to installation oracle9i in silent mode - please give me some ideas - URGENT
(21 May 2004 09:27:58)
ORA:02064:distributed operation not supported
(21 May 2004 06:30:03)
export backup of multiple tables
(21 May 2004 06:42:11)
Ojdbc14 Driver
(21 May 2004 06:13:05)
EXPORT - SELECTIVELY
(21 May 2004 05:56:14)
HOT vs COLD backup...
(21 May 2004 15:05:12)
Enterprise Manager 10g Grid Installation
(21 May 2004 00:09:40)
RMAN stby & ORA-01034: ORACLE not available
(21 May 2004 03:23:08)
Materialized view defs
(21 May 2004 09:34:10)
Urgent help with import
(20 May 2004 21:52:28)
Update Query.
(21 May 2004 09:58:15)
Re: oracle script
(20 May 2004 20:26:36)
Archive log Error - ORA-16020 - Help!
(20 May 2004 20:01:21)
slow exp
(20 May 2004 19:18:43)
oracle apps DBA course
(20 May 2004 19:13:25)
table space growth
(20 May 2004 21:56:25)
Ascential datastage tool
(20 May 2004 18:44:28)
Exp Tables
(21 May 2004 09:59:58)
slow performance of exp
(20 May 2004 19:26:02)
Back to basic for QUERY time - URGENT PLEASE
(20 May 2004 18:19:05)
Oracle 9i and Server Manager
(20 May 2004 23:59:37)
Re: problem regding index usage, try this
(20 May 2004 16:13:57)
Client installation on OpenVMS
(20 May 2004 16:14:55)
Migrate from 8.1.7.4 to 9.2.0.4 and new servers - repost
(20 May 2004 16:56:42)
problem regding index usage
(20 May 2004 16:00:35)
Test address
(20 May 2004 14:03:57)
DBLink Error
(20 May 2004 15:22:25)
Help Required for Ora-00060
(20 May 2004 12:55:06)
disable all contraints in a schema
(20 May 2004 12:52:16)
How to bypass Memory checking for 10g
(20 May 2004 12:30:34)
resource busy and acquire with NOWAIT
(20 May 2004 12:38:31)
Rebuiliding the indexes
(20 May 2004 12:36:00)
Connecting as sysdba using sys via SQLPLUS on the command line
(21 May 2004 15:07:59)
Grant select on all tables
(20 May 2004 12:39:34)
Hoe to start oracle management server
(22 May 2004 09:23:45)
Multibyte char!
(21 May 2004 10:21:32)
Convert IFS CREATEDATE in ODM_PUBLICOBJECT (number datatype) to DATE object
(20 May 2004 10:01:09)
change Default partition for database files..urgent help needed
(20 May 2004 10:19:06)
Storing of milleseconds in Oracle 8i
(21 May 2004 10:44:59)
SPFILE
(20 May 2004 14:58:18)
Dynamic Query With Ref-Cursor Output - Urgent Help Needed
(20 May 2004 20:47:11)
How to Set Text Charset?
(20 May 2004 08:18:48)
question pls Redhad 9 server windows desktop at the same time?
(20 May 2004 08:07:02)
Recovery Catalog Backup
(20 May 2004 18:26:52)
Exporting Spatial Data.
(20 May 2004 07:44:10)
Urgent Help needed on Creating Sequences
(20 May 2004 09:50:19)
Single Sign On Component not running on Oracle Infrastructure
(20 May 2004 04:30:15)
Regarding redo buffer
(20 May 2004 13:01:25)
updating one table with a value from another table
(20 May 2004 04:51:18)
Oracle9 or Oracle10 on Redhat Linux 9
(20 May 2004 10:31:04)
ORA-00227
(20 May 2004 04:09:54)
Re: download Pro*C and Oracle AS 10G
(19 May 2004 21:37:07)
intel or sun
(19 May 2004 19:51:18)
Create DB link as sysdba
(19 May 2004 19:47:41)
upgrade 8.1.7.4 to 9.2.0.4 on cluster
(19 May 2004 19:46:24)
Function does not work in Oracle 9.2 anymore.
(19 May 2004 19:45:48)
anyone seen this error before?
(19 May 2004 19:51:36)
Re: SYBASE : numeric datatype ASE 12.5
(19 May 2004 19:44:00)
download Pro*C
(19 May 2004 19:33:33)
help with export using query
(19 May 2004 20:21:56)
getting create sequence syntax out of data dictionary
(20 May 2004 14:44:45)
Shared Pool - Oracle Error Code 4031
(20 May 2004 14:48:08)
Migrate from 8.1.7.4 to 9.2.0.4 and new servers
(19 May 2004 16:59:13)
How to find 32 bit or 64 bit
(19 May 2004 17:25:16)
Re: [SPAM-high]DBSNMP
(19 May 2004 16:20:49)
why get different tablespace_name by querying dba_segments and dba_users?
(19 May 2004 17:35:14)
Statspack output
(19 May 2004 17:24:59)
ORA 27125
(19 May 2004 15:58:34)
HELPPPPP! 2000 alert log monitor
(19 May 2004 17:39:27)
Regarding buffer cache.
(19 May 2004 15:20:46)
installing oracle 9i to redhat 9 linux
(19 May 2004 21:16:02)
redo log file activation identifier mismatch
(19 May 2004 15:45:14)
[Q] How to by pass RAM check on 10G Grid control??
(19 May 2004 14:43:09)
How to get all schemas available in particualar db
(19 May 2004 15:08:20)
rollup query
(19 May 2004 13:31:54)
Very Simple SQL Query
(19 May 2004 13:54:58)
Advance Replication Problem
(19 May 2004 12:09:51)
TNS LISTENER get crash
(19 May 2004 12:18:23)
Need Oracle backup scripts in Unix
(19 May 2004 13:20:28)
Re: TO_DATE function
(19 May 2004 11:25:28)
Oracle8i and P4 problem
(19 May 2004 13:43:15)
DIM-00019
(19 May 2004 09:47:30)
Advanced Replication Prolem
(19 May 2004 12:07:55)
CLOB to LONG
(19 May 2004 08:24:37)
Query : Deadlock error
(21 May 2004 06:26:43)
sp2-0310 when running script (Ora 9.2.0.4.0 / windows server)
(21 May 2004 04:50:16)
Query running very slow - little urgent
(19 May 2004 07:45:12)
Doubt.!!!!!!!
(19 May 2004 07:04:04)
Index tablespace
(19 May 2004 06:57:16)
Database going slow ...
(19 May 2004 14:10:26)
Setting up a standby database
(19 May 2004 22:13:14)
Insert Script
(19 May 2004 06:32:38)
Table or view does not exist.
(19 May 2004 14:08:59)
Simulate a StandBy with Standard Edition
(18 May 2004 21:28:53)
PeopleSoft Install: What permissions do they need? Userid?
(18 May 2004 23:31:43)
DB_Block_buffer increase
(18 May 2004 20:23:20)
Upgrade project plan
(18 May 2004 19:16:37)
Oracle 10G OCP
(19 May 2004 09:49:17)
Standby issue
(18 May 2004 18:12:44)
10g installed, but what's with DCBA!
(21 May 2004 04:41:34)
Need info on MySQL
(19 May 2004 12:47:31)
a little off topic, but I need unix date help
(19 May 2004 17:11:38)
Want to get SQL updating the table...
(18 May 2004 17:25:20)
Oracle Error 904
(18 May 2004 15:20:52)
Postings
(18 May 2004 19:49:14)
Query: Third Highest Salary
(19 May 2004 07:20:54)
PASSWORD_REUSE_MAX
(18 May 2004 16:27:53)
Information the fields spare1 and spare2 the table sys.aud$
(18 May 2004 13:39:47)
FK cross-reference
(18 May 2004 13:32:24)
Re: Oracle 8.0.5 to Oracle 9.2.0.1.0 ... how can I do it ?
(18 May 2004 13:04:15)
What is PRAGMA?
(18 May 2004 20:39:11)
Problem with 9205 patch
(18 May 2004 12:09:26)
CLOBs and performance
(18 May 2004 16:42:20)
Password of System account in Oracle
(18 May 2004 14:15:36)

oracle lazydba home page