Oracle

January 2005

SQL*Plus query question
(31 Jan 2005 21:42:22)
Query help!!
(31 Jan 2005 20:38:25)
Sample data dump
(31 Jan 2005 20:1:12)
date coversion as interval - 12 months
(31 Jan 2005 19:50:0)
10g export file problem
(31 Jan 2005 15:47:55)
OEM JOB HISTORY HELP
(31 Jan 2005 12:35:59)
Data load help
(31 Jan 2005 10:39:3)
stored procedure help
(31 Jan 2005 10:12:33)
hi all
(31 Jan 2005 8:42:39)
LARGE_POOL_SIZE
(31 Jan 2005 7:43:17)
Perl or VBScript/WScript
(30 Jan 2005 16:16:56)
Designer 9i
(30 Jan 2005 8:23:36)
oracle 9i on sun Solaris 9
(29 Jan 2005 15:53:55)
LISTOWNER- EMAIL SHIELDING
(29 Jan 2005 14:0:6)
LISTOWNER- Too Many Emails in your inbox?
(29 Jan 2005 14:0:2)
ocacle 9ir2 client
(29 Jan 2005 13:7:57)
Query issue in 9i
(29 Jan 2005 4:56:28)
Hints question
(28 Jan 2005 22:11:45)
date time conversion 12 months out
(28 Jan 2005 21:14:18)
command line use of OEM
(28 Jan 2005 20:20:39)
connect as sysdba (sqlplus)
(28 Jan 2005 18:47:56)
Job History Full in OEM
(28 Jan 2005 18:28:28)
Problem with DBCA utility
(28 Jan 2005 17:34:17)
Renaming a partition key in Oracle8
(28 Jan 2005 17:31:28)
Renaming Tablespace in Oracle9i?
(28 Jan 2005 15:47:17)
DG and Blobs
(28 Jan 2005 14:57:50)
10g install problems
(28 Jan 2005 14:30:54)
migrating from 8.1.7 to 9.2.0.6
(28 Jan 2005 13:48:56)
Re: Sopa9m: Finding triggers/procedures names populating a table
(28 Jan 2005 13:48:9)
Finding triggers/procedures names populating a table
(28 Jan 2005 11:14:56)
oracle standard and enterprise versions
(28 Jan 2005 10:59:44)
DML Locks
(28 Jan 2005 7:56:15)
Sizing the extents - Migrating dictionary to locally managed
(28 Jan 2005 3:3:31)
Help in SQL Query - TIMESTAMP
(27 Jan 2005 21:54:39)
Looking for information on RMAN channel allocation and read rates...
(27 Jan 2005 19:42:31)
Unix command
(27 Jan 2005 17:24:20)
Removing carriage returns from a column
(27 Jan 2005 17:16:14)
SQL PROBLEM
(27 Jan 2005 16:56:48)
Running a procedure
(27 Jan 2005 16:2:18)
Cisco PIX firewall
(27 Jan 2005 11:36:49)
Connecting to database thru stored procedure
(27 Jan 2005 11:33:47)
Single Sign On
(27 Jan 2005 10:58:41)
Oracle 8i AS
(27 Jan 2005 6:9:38)
tnslsnr eats CPU
(27 Jan 2005 3:12:14)
Example of a Korn Shell script that executes SQL and passes the sqlcode back to the script as a variable?
(26 Jan 2005 23:29:57)
Re: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalog
(26 Jan 2005 23:25:24)
oracle8i backup
(26 Jan 2005 20:35:2)
Script for grants and synonyms
(26 Jan 2005 19:3:22)
newdatabase
(26 Jan 2005 18:20:42)
files search
(26 Jan 2005 16:56:15)
Alert log errors
(26 Jan 2005 15:12:29)
ETL practice
(26 Jan 2005 14:14:14)
Oracle Database Documenter
(26 Jan 2005 11:25:50)
Help on starting Oracle Management Server on AIX....
(25 Jan 2005 22:46:49)
Add a new Oracle product and patch installation
(25 Jan 2005 21:28:34)
Update stmt in 10g
(25 Jan 2005 18:41:57)
isqlplus issues
(25 Jan 2005 18:29:6)
10g install fails to create DB
(25 Jan 2005 18:5:25)
forms 6i web based application
(25 Jan 2005 18:0:32)
newbie question
(25 Jan 2005 17:51:10)
Monitoring Archivelog destination
(25 Jan 2005 17:40:18)
Maximizing Index Rebuild Performance
(25 Jan 2005 17:30:14)
Online redo log
(25 Jan 2005 16:33:11)
Script to identify and free locks!
(25 Jan 2005 16:15:5)
Spool of data
(25 Jan 2005 13:32:23)
Performance gain after index rebuild ?
(25 Jan 2005 13:16:32)
Oracle HR Self Service
(25 Jan 2005 12:27:36)
How to export data dictionary
(25 Jan 2005 11:14:31)
Creation of another database in oracle 10g
(25 Jan 2005 9:43:55)
lousy view query performance
(25 Jan 2005 7:5:33)
OWB Error
(25 Jan 2005 6:47:47)
DBMS package to generate DDL statements
(25 Jan 2005 6:37:5)
Duplicate problem
(25 Jan 2005 6:27:10)
OWB
(25 Jan 2005 3:11:19)
Oracle upgrade and patches
(24 Jan 2005 21:48:0)
Help on disabling indexes
(24 Jan 2005 20:14:19)
Shared Pool Size
(24 Jan 2005 18:22:18)
Oracle internet directory
(24 Jan 2005 17:40:47)
Disabling Alert Logging
(24 Jan 2005 15:12:38)
Dynamically Increase Shared Pool Size
(24 Jan 2005 13:49:37)
Supported compilers
(24 Jan 2005 12:13:55)
Import Criteria
(24 Jan 2005 7:8:31)
How to check which datafile my table is created in..
(24 Jan 2005 1:37:29)
Oracle Names
(23 Jan 2005 20:31:57)
Opatch execution problem
(21 Jan 2005 22:5:24)
OEM Help
(21 Jan 2005 19:56:24)
TWO DATABASES IN SYNC
(21 Jan 2005 18:37:0)
DBWR
(21 Jan 2005 16:10:45)
Proper SQL format
(21 Jan 2005 14:7:9)
Client version vs Db Version
(21 Jan 2005 13:59:2)
Unable to create a tablespace in oracle 9i-quick reply needed
(21 Jan 2005 13:40:15)
Credential retrieval failed
(21 Jan 2005 13:34:43)
Quick question
(21 Jan 2005 10:34:54)
Transpose Data
(21 Jan 2005 9:56:30)
Fragmented tablespace or datafile - probably silly
(21 Jan 2005 6:6:58)
Need Oracle RDB Help
(20 Jan 2005 22:0:0)
Oracle XML DB
(20 Jan 2005 20:56:49)
Moving to partitioning
(20 Jan 2005 20:48:57)
Outlook.pdf
(20 Jan 2005 18:29:30)
Re: RMAN error:URGENT,HELP :(
(20 Jan 2005 18:2:10)
Please Help
(20 Jan 2005 17:53:40)
Is there any way to rollback when refreshing MV(Materialized View) failed
(20 Jan 2005 17:33:14)
9.2.0.1 to 9.2.0.5
(20 Jan 2005 17:20:14)
PART 1 System running a process dog slow....any way to measure what the throughput of the DB is?
(20 Jan 2005 14:52:42)
PART 2 System running a process dog slow....any way to measure what the throughput of the DB is?
(20 Jan 2005 14:42:55)
query help
(20 Jan 2005 13:18:49)
Objects in Local Managed Tablespaces
(20 Jan 2005 0:0:10)
procedures in packages
(19 Jan 2005 23:1:40)
Need to determine if Tablespace is Indeed Fragemented
(19 Jan 2005 21:50:12)
Need to export mulitiple tables within Tablespace
(19 Jan 2005 21:43:49)
LMT tablespaces: Need for Undo Tablespace necessary?
(19 Jan 2005 20:4:33)
move/create controlfiles
(19 Jan 2005 16:54:49)
Trouble installing patch 3811857 on an HP system
(19 Jan 2005 14:5:12)
Problem with Range Partition!
(19 Jan 2005 13:40:37)
Error in index
(19 Jan 2005 13:29:18)
10G Grid Control
(19 Jan 2005 12:22:47)
Release
(19 Jan 2005 9:11:9)
NETWORKING ISSUE
(19 Jan 2005 5:31:50)
Architecture question
(19 Jan 2005 3:51:48)
column heading format not working
(19 Jan 2005 0:20:10)
Difference between 1 Datafile vs 2 or 3
(18 Jan 2005 23:58:30)
PeteFinnigan.com - Oracle security advisory
(18 Jan 2005 22:38:38)
SELECT STATEMENT help. - SQL
(18 Jan 2005 22:17:21)
PUBLIC Oracle 8 Synonnyms
(18 Jan 2005 22:15:53)
Tablespaces and objects in them.
(18 Jan 2005 21:54:22)
10g HTTP Server
(18 Jan 2005 19:52:36)
version question
(18 Jan 2005 19:33:35)
Keep it clean
(18 Jan 2005 19:24:54)
extracting time zone (PST,EST)
(18 Jan 2005 19:14:20)
varchar2 to number conversion
(18 Jan 2005 18:27:11)
The French Connection
(18 Jan 2005 16:7:24)
RAID and OFA for Oracle 9i on RedHat Linux !!
(18 Jan 2005 16:5:7)
How to find the SQL State of Unique Key constraint violation
(18 Jan 2005 15:4:22)
executing query in remote database
(18 Jan 2005 15:1:47)
Store access data into Oracle ( Using Access Form)
(18 Jan 2005 14:11:32)
10g replication push problem
(18 Jan 2005 14:7:59)
Enforcing Upper Case for Data Entry on Columns
(18 Jan 2005 13:53:31)
Microsoft SQL Server 2000 Error:9001, Severity:21, State:1!
(18 Jan 2005 12:54:15)
Swap Space on a Solaris Server (Version 2.8)
(18 Jan 2005 10:22:40)
URGENT!!!!! Problem with database
(18 Jan 2005 9:37:35)
URGET HELP NEEDED
(18 Jan 2005 9:17:38)
Sql Loader
(18 Jan 2005 6:42:42)
Packages 101
(17 Jan 2005 22:43:53)
SYSDBA recovery password
(17 Jan 2005 22:0:46)
Re: SQL DBA Job Description
(17 Jan 2005 20:23:5)
OEM ERROR
(17 Jan 2005 19:25:13)
Time need to convert in military format
(17 Jan 2005 18:48:52)
How to use SQL Loader ?
(17 Jan 2005 18:48:35)
oracle details
(17 Jan 2005 15:11:7)
Finding tables with LONG column
(17 Jan 2005 13:43:40)
HELP ON SAP PLEASE - Migrating dictionary managed tablespace to locally managed tablespace in SAP database - HELP ON SAP
(17 Jan 2005 13:20:41)
Re: too many values
(17 Jan 2005 9:49:34)
how many IPs neede in RAC(two nodes)
(17 Jan 2005 7:35:19)
Memory usage of oracle
(16 Jan 2005 23:34:50)
Migration To Linux
(16 Jan 2005 18:5:48)
finding a column in the database
(15 Jan 2005 13:32:6)
Tru64 Performance Slowness
(15 Jan 2005 13:12:48)
windows
(15 Jan 2005 5:32:28)
Power Objects
(15 Jan 2005 4:21:12)
executing java
(14 Jan 2005 23:5:3)
Estimated cost is higher after Oracle 8 to 9 upgrade
(14 Jan 2005 22:46:3)
default role list setting
(14 Jan 2005 20:17:44)
How to find out Table Size in oracle.
(14 Jan 2005 19:8:18)
FRM-91500 Unable to start/complete the build (Oracle Forms 10 g on the Solaris Server using Oracle Application Server 10G)
(14 Jan 2005 18:57:58)
unregistered a snapshot id from its snapshot log
(14 Jan 2005 18:21:35)
Reason for Coalesceing tablespaces
(14 Jan 2005 18:21:15)
imp/exp questions
(14 Jan 2005 14:30:30)
Parameter
(14 Jan 2005 11:45:47)
FRM-91500 Unable to start/complete the build (Oracle Forms 10g on Solaris Server using Oracle Application Server 10G)
(14 Jan 2005 8:18:28)
FILE STRIPPER to use for Oracle RDA - Remote Diagnostic Agent
(14 Jan 2005 2:30:13)
Urgent Help Continued !!
(13 Jan 2005 20:46:14)
Data insert problem
(13 Jan 2005 18:59:12)
Formula for calculating Java_Pool_Size
(13 Jan 2005 16:44:38)
Oracle Application Server : Unix Vs NT
(13 Jan 2005 16:25:56)
Need help
(13 Jan 2005 16:1:40)
ORA-19566 not ORA-19583 sorry
(13 Jan 2005 15:27:51)
Finding table and column name that holds a given value
(13 Jan 2005 15:4:1)
ORA-19583
(13 Jan 2005 14:44:27)
Here is one for ya.....Raid 5 and DB layout question
(13 Jan 2005 11:48:5)
help for Fix Pack for db2 8.1
(13 Jan 2005 9:37:50)
import utility
(13 Jan 2005 9:27:6)
Oracle Forms - passing variables between forms
(13 Jan 2005 8:41:11)
DROP INDEX and DROP TABLE
(13 Jan 2005 8:26:8)
Oracle Forms... Again!
(13 Jan 2005 6:6:3)
optimizer mode
(13 Jan 2005 0:57:55)
Importing data into Oracle from TerraData or DB2
(12 Jan 2005 22:27:37)
EM 9i or 10g
(12 Jan 2005 18:49:45)
Quick Question I still have a major ORacle Problem
(12 Jan 2005 18:37:39)
Any good tools for design and create oracle database
(12 Jan 2005 16:56:29)
Urgent Help !!
(12 Jan 2005 16:2:9)
Dual Copy of ORACLE database thru RMAN
(12 Jan 2005 16:0:4)
Database details
(12 Jan 2005 15:50:0)
SQL Server procedure
(12 Jan 2005 14:54:27)
Urgent help
(12 Jan 2005 14:32:8)
Re: Message Level Threshold
(12 Jan 2005 14:9:23)
Installing 11.5.9 on RHAT ES 3
(12 Jan 2005 13:58:46)
max # extents 505 reached - Problem
(12 Jan 2005 12:44:23)
Index Problem
(12 Jan 2005 12:12:25)
Updateable snapshot
(12 Jan 2005 7:52:14)
Help regarding Group !!
(12 Jan 2005 7:12:19)
Explain Plan - Reg
(12 Jan 2005 7:8:40)
How to TRACE SAP sessions ... aaargghhh
(12 Jan 2005 6:38:14)
It can't to select v$sgastat ?
(12 Jan 2005 5:50:16)
VALUE OF DB_BLOCK_BUFFERS
(12 Jan 2005 5:14:52)
Resending mail with ZIP file
(12 Jan 2005 4:13:40)
create scripts from existing database ?
(11 Jan 2005 20:57:22)
sqlpus report count question
(11 Jan 2005 20:48:55)
select SYSDATE@! FROM DUAL
(11 Jan 2005 20:26:13)
Can Oracle use an index if a non-first colum is in the where clause
(11 Jan 2005 20:18:0)
can you have a listener without a listener.ora
(11 Jan 2005 19:50:25)
OEM Discovery failed: VNI-4009
(11 Jan 2005 18:57:25)
change home directory question
(11 Jan 2005 18:2:2)
Forms Help!
(11 Jan 2005 17:19:30)
Need Query
(11 Jan 2005 17:6:2)
Oracle 9i or 10g on IBM xSeries Linux or pSeries AIX
(11 Jan 2005 16:58:50)
diff between 9i and 10g
(11 Jan 2005 15:53:12)
RMAN / Hot backup failure
(11 Jan 2005 14:35:11)
Database edition
(11 Jan 2005 14:32:56)
How to determine db upgrade history
(11 Jan 2005 14:26:45)
Oracle XA transaction timeout configurable?
(11 Jan 2005 13:11:39)
Partititioning
(11 Jan 2005 13:8:16)
why, It is called 10g. ?
(11 Jan 2005 12:34:43)
Oracle Collaboration Mail Problem (very Urgent )
(11 Jan 2005 11:30:50)
SECURITY IN DEVELOPER 6i
(11 Jan 2005 10:7:47)
Help!!
(11 Jan 2005 8:59:3)
Alter Table move tablespace is very fast..Why?..................
(11 Jan 2005 8:55:10)
how to tell if patch is applied
(11 Jan 2005 7:3:3)
DEF_SID.ORA
(11 Jan 2005 5:20:26)
primary key vs. unique key
(11 Jan 2005 5:10:53)
replication and data model
(11 Jan 2005 3:8:2)
Bounce the database ?
(11 Jan 2005 2:4:49)
Composite bitmap indices
(10 Jan 2005 22:2:7)
columns names and special characters
(10 Jan 2005 20:25:37)
user_role view
(10 Jan 2005 20:14:0)
function to return one value where several exist
(10 Jan 2005 18:47:48)
Tabel creation with BLOB
(10 Jan 2005 18:46:39)
Warehousing tables
(10 Jan 2005 16:48:37)
Compare server configuration...
(10 Jan 2005 15:32:38)
Listener Questionn
(10 Jan 2005 13:27:5)
INITSID.ORA doubt
(10 Jan 2005 11:4:43)
Parent-Child Relationship
(10 Jan 2005 6:9:14)
Who has privs on a specific table
(9 Jan 2005 21:35:47)
Converting FROM Dictionary-Managed Tablespaces to Locally-Managed Tablespaces
(9 Jan 2005 14:40:14)
Re: Tablespace used
(9 Jan 2005 8:5:23)
URGENT: SPFILE Path not found
(8 Jan 2005 11:29:54)
Mutating in trigger/function
(8 Jan 2005 7:36:7)
SQL*Plus: Delete records, excluding ranges?
(8 Jan 2005 7:28:35)
DBMS_JOB interval
(7 Jan 2005 23:6:34)
GATHER_DATABASE_STATS in 9.2.0.4
(7 Jan 2005 21:33:20)
Backup through OEM
(7 Jan 2005 19:36:19)
Urgent: Transaction is spinning (8.1.7) ... is only sorting, and not processing ...
(7 Jan 2005 19:1:5)
Multi table insert
(7 Jan 2005 13:28:11)
A DATABASE error has occured.Overflow EXCEPTION
(7 Jan 2005 12:27:38)
URGENT: Unable to create pfile from spfile
(7 Jan 2005 11:32:35)
Similar Query Performance
(7 Jan 2005 9:51:5)
Import/Export between different version...
(7 Jan 2005 9:49:58)
Oracle connection problem
(7 Jan 2005 7:54:17)
Password in service name
(7 Jan 2005 7:22:41)
10g availability date
(6 Jan 2005 23:2:16)
group by weekday or week,
(6 Jan 2005 20:36:27)
Objects in Locally Managed Tablespaces
(6 Jan 2005 16:17:24)
ALTER TABLE MOVE REBUILD INDEX
(6 Jan 2005 16:9:37)
Connection size
(6 Jan 2005 15:49:50)
aiowait timed out
(6 Jan 2005 15:46:41)
Right tablespace
(6 Jan 2005 15:39:39)
Export from Long data type column
(6 Jan 2005 14:2:10)
SQL*Loader: Dont want to load an empty file
(6 Jan 2005 13:59:39)
UNIFORM EXTENT SIZE - DMT to LMT
(6 Jan 2005 13:48:29)
off hand question - access 97
(6 Jan 2005 11:49:0)
Dropped Indexes
(6 Jan 2005 11:40:24)
Restrict CREATE OR REPLACE PROCEDURE Privilege
(6 Jan 2005 10:36:1)
Oracle 9.2 on AIX 5.3
(6 Jan 2005 9:33:15)
Check i/o for a filesystem
(6 Jan 2005 6:42:45)
detect the Hosts name or IP address being in SQL prompt
(6 Jan 2005 6:40:41)
Raw data value to date
(6 Jan 2005 3:31:17)
migration from one instance to another
(5 Jan 2005 23:4:4)
Redo log space request
(5 Jan 2005 22:53:28)
Configuring an IPC Connection
(5 Jan 2005 22:13:4)
Replication versus Streams
(5 Jan 2005 21:23:46)
DATETIME arithmetic
(5 Jan 2005 21:21:44)
table name
(5 Jan 2005 20:58:7)
Reposting - SAP tablespaces
(5 Jan 2005 20:53:5)
Quiz Question
(5 Jan 2005 17:23:12)
DB size estimated
(5 Jan 2005 16:27:25)
Migrating dictionary-managed to locally-managed tablespaces
(5 Jan 2005 16:8:45)
moving archive partition question
(5 Jan 2005 15:21:44)
Totally off topic but...
(5 Jan 2005 14:18:23)
Oracle 10g Recommendation
(5 Jan 2005 12:33:53)
Suggestions for platform independent migrations
(5 Jan 2005 12:32:29)
Opinions on Datafile Sizing please
(5 Jan 2005 11:35:50)
RESTORE\CLONING DATABASES and PERFORMANCE ...
(5 Jan 2005 11:31:47)
cold backup on oracle 92
(5 Jan 2005 9:19:54)
Re: Contract position
(4 Jan 2005 22:17:47)
Standby database
(4 Jan 2005 21:43:47)
cursor question
(4 Jan 2005 19:59:36)
[HELP]did anyone meet ORA-04031 error?
(4 Jan 2005 18:18:54)
High CPU Usage
(4 Jan 2005 16:52:30)
Database link
(4 Jan 2005 16:42:56)
User can check dba user PWD .. Pls Sove this Problem
(4 Jan 2005 16:18:17)
rollback segments
(4 Jan 2005 16:14:30)
Why the ORA-12540 error
(4 Jan 2005 7:35:35)
Size logs
(4 Jan 2005 5:38:46)
RMAN recover error 06025
(4 Jan 2005 0:9:56)
Re: RMAN recover error 06025 Metalink Note 155656.1 Part 2
(4 Jan 2005 0:2:50)
Re: RMAN recover error 06025 (Metalink Note:155656.1 part 1)
(4 Jan 2005 0:2:43)
Restores after the nologging load
(3 Jan 2005 21:43:48)
Oracle Provider for OLE db
(3 Jan 2005 21:41:50)
INIT.ORA Parameters
(3 Jan 2005 14:31:1)
Security Alert - 68
(3 Jan 2005 13:25:24)
V$ VIEWS for OS and SERVER
(3 Jan 2005 10:47:4)
SAP databases/tablespaces storage parameters
(1 Jan 2005 0:32:53)

oracle lazydba home page