Oracle

March 2008

TNSNAMES
(31 Mar 2008 20:3:45)
comparison between Linux and Windows
(31 Mar 2008 19:50:33)
ORA-01552 in a 10gr2
(31 Mar 2008 19:43:57)
ORA-22992; cannot use LOB locators selected from remote tables
(31 Mar 2008 19:41:30)
Installing Forms 10g
(31 Mar 2008 17:53:40)
Re: Enterprise Manager 10G and dataguard
(31 Mar 2008 17:10:10)
external tables -> find "directory"
(31 Mar 2008 16:25:40)
is there any way to find the minimum value from non numeric column in Oracle?
(31 Mar 2008 15:39:16)
CHECKPOINT
(31 Mar 2008 15:0:50)
is there any way to pass the UNIX variable to SQL *Loader.
(31 Mar 2008 14:39:38)
Finding the nth row
(31 Mar 2008 14:37:29)
Re: snapshot too old
(31 Mar 2008 13:55:10)
Update issue!
(31 Mar 2008 13:22:17)
How to tell if indexes are being used for a table
(31 Mar 2008 13:4:34)
Deleting a datafile from a tablespace.
(31 Mar 2008 12:41:31)
types of Migration
(31 Mar 2008 12:41:20)
Error ORA-00979
(31 Mar 2008 10:57:12)
which way to go drop and create or rebuild the indexes
(31 Mar 2008 10:1:26)
Is there a way within sqlldr to delete any duplicates found during the load
(31 Mar 2008 9:33:25)
Extracting data based on foreign key relationships only
(31 Mar 2008 7:50:56)
export and import tablespace
(31 Mar 2008 7:47:0)
time format help
(31 Mar 2008 7:31:22)
difference between Explain Plan and Analyze Table?
(31 Mar 2008 7:29:18)
different between Instance and Database
(31 Mar 2008 7:19:41)
rename user
(31 Mar 2008 6:35:4)
AIX 6 C++ Compiler?
(31 Mar 2008 4:59:23)
LISTOWNER- EMAIL SHIELDING
(29 Mar 2008 14:0:2)
NEED HELP URGENT
(29 Mar 2008 7:59:47)
trouble with pics in long raw fields
(28 Mar 2008 22:27:46)
Advice on Oracle Date and Time manipulation
(28 Mar 2008 20:32:54)
Hot Site Questions
(28 Mar 2008 20:20:51)
change data type
(28 Mar 2008 19:53:43)
error in trace file
(28 Mar 2008 17:3:47)
all_ data dictionary views select privileges needed
(28 Mar 2008 14:53:56)
slow speed
(28 Mar 2008 14:29:55)
Rebuild index
(28 Mar 2008 14:26:51)
import issue..
(28 Mar 2008 14:21:36)
export data file
(28 Mar 2008 13:45:34)
how to check space used by a database.
(28 Mar 2008 13:32:10)
use of lock in oracle
(28 Mar 2008 13:18:23)
Load 60 gb of table important
(28 Mar 2008 11:47:48)
Re: Limit the number of sessions concurrently connected to a database
(28 Mar 2008 10:10:36)
substitute of dynamic properties task in ssis
(28 Mar 2008 10:9:41)
xml validation in 10g (architecture question)
(28 Mar 2008 9:52:55)
Oracle on EMT64bit
(28 Mar 2008 7:21:30)
database script
(28 Mar 2008 7:18:28)
AutoBackup Schedule
(28 Mar 2008 6:0:0)
DEADLOCK / revoking privileges from pubulic group
(28 Mar 2008 5:50:5)
Problem on PLSQL statement (Merge statement)
(28 Mar 2008 4:30:30)
Strategy Questions
(27 Mar 2008 22:4:33)
can you change an oracle home name after installation
(27 Mar 2008 16:56:29)
ora-00600 error
(27 Mar 2008 16:55:46)
10g_RAC issues
(27 Mar 2008 16:52:39)
LOB to CHAR conversion
(27 Mar 2008 15:30:53)
How to rebuild to index of type IOT-TOP on INDEX ORAGANIZED TABLE
(27 Mar 2008 14:9:3)
ERROR: ORA-06502: PL/SQL: numeric or value error: number precision too large'
(27 Mar 2008 14:6:15)
Error while inserting records!
(27 Mar 2008 13:57:5)
May i know is there any sql statement or table to check lock?
(27 Mar 2008 12:34:31)
low buffer hit
(27 Mar 2008 10:29:58)
how to set patches for oracle in windows
(27 Mar 2008 6:58:6)
Encrypting Sql2000 database
(27 Mar 2008 6:20:23)
How to know what the object is
(27 Mar 2008 6:13:47)
Re: Cannot access NLS data files or invalid environment specified
(27 Mar 2008 2:15:56)
RMAN duplicate
(26 Mar 2008 19:11:55)
10g Upgrade in Place from 8.1.7.2
(26 Mar 2008 18:24:11)
Table Analyzer
(26 Mar 2008 18:1:37)
Re: OEM Intelligent Agent download
(26 Mar 2008 17:7:30)
Password Handling in oracle
(26 Mar 2008 16:51:3)
Excel with Oracle
(26 Mar 2008 16:37:15)
Re: Tables
(26 Mar 2008 16:35:10)
multiple condition in like operator(very urgent)
(26 Mar 2008 14:47:25)
Dropping a schema
(26 Mar 2008 14:22:47)
Cleanup of Archive Logs Files on Disk in Windows 2003 Server
(26 Mar 2008 13:55:25)
Oracledbconsole10g not starting
(26 Mar 2008 13:49:50)
pls merge two query
(26 Mar 2008 11:53:54)
Agent is Unreachable
(26 Mar 2008 10:59:47)
Re: RAM size
(26 Mar 2008 6:20:16)
Oracle Home Disk Placement
(25 Mar 2008 20:24:51)
CBO question
(25 Mar 2008 20:20:44)
SQL Statement (PL/SQL) won't work? (UNCLASSIFIED)
(25 Mar 2008 20:17:37)
RMAN delete not removing file
(25 Mar 2008 16:35:57)
EM Question
(25 Mar 2008 15:47:9)
Oracle 10g Issues with CPU usage - especially with snapshots/materalized views
(25 Mar 2008 14:48:22)
Oracle RAC?????
(25 Mar 2008 14:39:24)
Index Hit Ratio is very Low !!!
(25 Mar 2008 13:44:16)
Discoverer reports
(25 Mar 2008 13:2:22)
Help regarding 1Z0-031 Certification
(25 Mar 2008 11:46:44)
error while creating db
(25 Mar 2008 10:48:59)
OCA 9i or 10g
(25 Mar 2008 9:30:47)
BACKUP GURUS IMP /RMAN compress on the fly?
(25 Mar 2008 1:17:24)
Private Interconnects on Windows 2003
(24 Mar 2008 23:37:25)
create a user with the same objects and privileges as existing user
(24 Mar 2008 21:35:13)
INDEXING or VIEWS
(24 Mar 2008 17:4:39)
error in shutdown database
(24 Mar 2008 15:10:12)
Questions to ask client if you are their DBA
(24 Mar 2008 13:56:55)
hi
(24 Mar 2008 11:42:26)
Differences between DECODE, REPLACE, TRANSLATE
(24 Mar 2008 10:26:14)
data guard docs
(24 Mar 2008 9:49:22)
CASCADE
(23 Mar 2008 17:45:46)
10g OCA
(23 Mar 2008 2:39:11)
Extracting Database script from Existing Database
(23 Mar 2008 2:24:49)
create standby database [Virus checked]
(23 Mar 2008 0:12:7)
Drop Data File
(22 Mar 2008 18:23:53)
Help - down in oracle
(22 Mar 2008 4:38:57)
Re: ora-00472 fix
(21 Mar 2008 19:8:16)
Oracle Stuff
(21 Mar 2008 19:5:14)
Moving LOB column to a new tablespace
(21 Mar 2008 19:2:10)
Foreign characters not properly downloaded or stored from D&B
(21 Mar 2008 16:22:36)
Latency in Purchasing Data from D&B via Oracle Customers Online
(21 Mar 2008 16:14:6)
ORA-01732
(21 Mar 2008 15:31:52)
No space left on device
(21 Mar 2008 14:12:14)
Oracle DBMS_XMLGEN and Oracle WITH Clause (Display the 5 Largest Databases in an Oracle Schema)
(21 Mar 2008 13:16:4)
Rman connection Problem Help !
(21 Mar 2008 11:35:1)
Report writer
(21 Mar 2008 9:30:47)
Oracle DBMS_XMLGEN
(20 Mar 2008 22:8:13)
table partitioning
(20 Mar 2008 22:7:44)
UNIX on Quad core machine
(20 Mar 2008 18:3:54)
RMAN Problem (Please, help)
(20 Mar 2008 17:38:59)
imp touser user defined types
(20 Mar 2008 16:31:5)
ORA-12560 TNS: protocol adapter error
(20 Mar 2008 16:7:29)
dbms_jobs Help
(20 Mar 2008 14:17:18)
exporting sample data from schema
(20 Mar 2008 13:56:20)
imp touser LOBs
(20 Mar 2008 13:50:5)
The datafile of system01.dbf lost!
(20 Mar 2008 12:12:47)
Columns to rows convert Sql
(20 Mar 2008 10:50:57)
User logon time
(20 Mar 2008 8:21:29)
ora-00600
(20 Mar 2008 8:10:56)
to make query simple
(20 Mar 2008 6:19:59)
Dynamic partition
(19 Mar 2008 21:9:18)
YTD calculation in Pl/SQl
(19 Mar 2008 20:37:49)
data pump export of partitioned table using NETWORK_LINK
(19 Mar 2008 20:4:9)
Re: Printer error in oracle apps
(19 Mar 2008 17:18:52)
Undo Management - longest running query
(19 Mar 2008 17:13:2)
Read only access of package, procedure, table
(19 Mar 2008 17:0:15)
dbms_profiler
(19 Mar 2008 14:38:56)
Used procedures in a database instance
(19 Mar 2008 14:36:13)
Startup fails
(19 Mar 2008 14:31:40)
add instance name into listener.ora autamatically
(19 Mar 2008 14:16:45)
Archived filled up is NOT frozen
(19 Mar 2008 14:3:43)
increase db_file_multiblock_read_count
(19 Mar 2008 13:27:53)
Oracle REGEXP_LIKE (Oracle 10G)
(19 Mar 2008 12:17:21)
How can use UTL_SMTP in procedure.............
(19 Mar 2008 8:27:38)
problem while upgading db from 9i t0 10g
(19 Mar 2008 6:15:48)
Why this happens .
(19 Mar 2008 5:53:52)
Result set of 1 to 1000 numbers with Standard SQL statement.
(19 Mar 2008 0:3:20)
undo retention???
(18 Mar 2008 21:11:44)
OAS SSO/SSL Configuration
(18 Mar 2008 20:19:53)
Model Clause
(18 Mar 2008 18:12:52)
set kernel parameters
(18 Mar 2008 17:29:16)
upgrade from 9204 to 10.2.0.1
(18 Mar 2008 16:35:7)
Script to Create Oracle Tablespaces
(18 Mar 2008 16:35:7)
Update query Performance issue
(18 Mar 2008 15:12:30)
Oracle WITH Clause
(18 Mar 2008 14:27:16)
Does oracle has isnumber function?
(18 Mar 2008 14:12:25)
Blobs question
(18 Mar 2008 13:18:57)
Divice busy
(18 Mar 2008 11:52:51)
Difference between BACKUP SPFILE: and BACKUP CURRENT CONTROLFILE;
(18 Mar 2008 11:18:57)
calling dbms_lock.sleep from a procedure
(18 Mar 2008 11:3:0)
Procedure executing parallel in Oracle 9
(18 Mar 2008 10:57:5)
Can we schedule backup Jobs in Oracle9i?
(18 Mar 2008 10:27:39)
create a sequnce.....
(18 Mar 2008 7:44:5)
IMPORT Error
(18 Mar 2008 7:26:1)
Re: TNS:listener could not hand off client connection
(18 Mar 2008 6:39:9)
Patches for oracle 10g std edition
(18 Mar 2008 5:58:41)
Calculate the table row size growth
(17 Mar 2008 22:16:37)
How to export schema from Oracle 7?
(17 Mar 2008 14:17:41)
Database import - New Oracle installation --
(17 Mar 2008 14:10:49)
rman issues ...
(17 Mar 2008 12:33:5)
Record counts of the first 5 largest tables
(17 Mar 2008 11:38:52)
Re: RPAD Function
(17 Mar 2008 11:6:45)
pfile spfile question
(17 Mar 2008 5:31:8)
Replication Server
(17 Mar 2008 0:48:8)
RMAN vs HOT BACK UP
(17 Mar 2008 0:39:44)
[SPAM] RPAD Function
(17 Mar 2008 0:37:41)
setting a unix variable from sqlplus
(17 Mar 2008 0:34:39)
Count of records updated in current session
(16 Mar 2008 18:50:0)
Compression affecting my ability to connect?
(15 Mar 2008 17:57:41)
Shrinking the temp table space?
(15 Mar 2008 6:20:13)
Network Message
(14 Mar 2008 23:30:31)
find last patch in oracle8174
(14 Mar 2008 22:24:31)
Re: export/import
(14 Mar 2008 21:34:8)
Order by (once again)
(14 Mar 2008 20:34:46)
DUAL table
(14 Mar 2008 19:50:8)
ODBC Driver for AS/400
(14 Mar 2008 18:21:48)
Sizo of a table
(14 Mar 2008 14:46:27)
Re: Taking backup of a table in to flat file
(14 Mar 2008 14:37:12)
How do I recover database with database files
(14 Mar 2008 14:22:17)
recovery question
(14 Mar 2008 14:10:58)
Moving the system tablespace into ASM
(14 Mar 2008 14:7:32)
Why doesn't sysdate return the time
(14 Mar 2008 13:53:29)
query to find the locks !!!!
(14 Mar 2008 13:16:26)
Trend Calculation
(14 Mar 2008 12:42:33)
Memory threshhold???
(13 Mar 2008 22:33:47)
If any interest
(13 Mar 2008 21:14:9)
Host name change in oracle 10g
(13 Mar 2008 19:40:31)
RAC Issue
(13 Mar 2008 18:49:28)
PLSQL dbms_lob package problem
(13 Mar 2008 16:31:36)
Users in oracle
(13 Mar 2008 16:0:18)
import excell file into oracle
(13 Mar 2008 15:16:4)
Select distinct
(13 Mar 2008 14:29:13)
Heap Size Issue?
(13 Mar 2008 14:21:10)
Insert Script
(13 Mar 2008 10:46:29)
Table privileges history or log
(13 Mar 2008 9:32:28)
Notepad issue
(13 Mar 2008 6:45:21)
Migration of DB2 database to Oracle 10g
(12 Mar 2008 23:18:46)
PLEASE PLEASE PLEASE start a new thread!!!
(12 Mar 2008 17:6:17)
not able to see the table
(12 Mar 2008 16:37:42)
sql SCRIPT > count the number of tables in a database
(12 Mar 2008 16:33:54)
impdp errors
(12 Mar 2008 16:24:51)
A question...? (no it's not Friday)
(12 Mar 2008 16:23:15)
Control file Issue in SQLLoader
(12 Mar 2008 15:3:6)
Full table scan problem
(12 Mar 2008 14:47:15)
reg. info.
(12 Mar 2008 10:55:41)
Re: How do I find out the last patch installed - CHANGE TITLE
(12 Mar 2008 10:28:34)
update qurery
(12 Mar 2008 10:5:53)
How do I find out the last patch installed
(12 Mar 2008 9:40:32)
CREATE DATABASE
(12 Mar 2008 4:10:44)
ORA-01001 and ORA-00600 when trying to drop a role and a user
(11 Mar 2008 21:6:58)
v$sqlarea column object_status
(11 Mar 2008 17:5:10)
Re: TNS:listener
(11 Mar 2008 17:5:5)
make a RAC
(11 Mar 2008 15:51:19)
Re: RE : snapshot log
(11 Mar 2008 15:45:20)
Data gurad (same host, same oracle home)
(11 Mar 2008 14:52:2)
snapshot log
(11 Mar 2008 14:45:30)
migrate DB 9204 to 10g release 2
(11 Mar 2008 13:40:17)
Oracle RAC
(11 Mar 2008 13:29:26)
stop trace
(11 Mar 2008 13:7:30)
Connection error
(11 Mar 2008 11:42:11)
RECOVER
(11 Mar 2008 10:46:10)
REP-56048 error - cache?
(11 Mar 2008 10:26:51)
Join Vs Subqueries
(11 Mar 2008 10:2:4)
Re: Need Help On Replication on Table Level
(11 Mar 2008 9:47:55)
V$access and v$locked_object
(11 Mar 2008 9:40:6)
Session Information in DB
(11 Mar 2008 8:38:24)
Apex
(11 Mar 2008 8:33:40)
Re: db file sequential read
(11 Mar 2008 8:32:22)
Oracle 9i and 10g MSI packages
(11 Mar 2008 5:50:16)
window script
(11 Mar 2008 3:51:59)
Moving a Production DB with minimal downtime?
(10 Mar 2008 23:46:1)
Oracle on Windows OFA
(10 Mar 2008 20:35:54)
OCP Certificate Upgrade from 8i to 10g
(10 Mar 2008 20:27:47)
ASM anyone?
(10 Mar 2008 18:14:19)
Statspack
(10 Mar 2008 17:3:28)
recover database
(10 Mar 2008 16:3:40)
how to install 9i and 10 g on same linux machine
(10 Mar 2008 16:1:54)
tablespace info in data dictionary
(10 Mar 2008 15:16:51)
installation and upgrade to oracle 10g from oracle9i
(10 Mar 2008 14:38:36)
PL/SQL: numeric or value error
(10 Mar 2008 14:16:5)
Standby & dataguard (same host) i really give up (please please help)
(10 Mar 2008 13:11:52)
upggrading legacy application
(10 Mar 2008 11:46:26)
update query
(10 Mar 2008 7:38:44)
Upgrade OCP certifications from 9i to 10g
(10 Mar 2008 7:17:14)
alter temporary tablespace of a user
(10 Mar 2008 6:23:8)
Opatch issues
(9 Mar 2008 6:52:13)
number format in xml
(8 Mar 2008 10:35:34)
Friday Questions (very challenging)
(8 Mar 2008 8:27:7)
Regarding database updation
(8 Mar 2008 7:53:33)
Report in XML format
(7 Mar 2008 22:43:58)
PL/SQL (I need your help)
(7 Mar 2008 21:49:56)
Toad tutorials
(7 Mar 2008 15:30:21)
Oracle (Converting Rows to One Column)
(7 Mar 2008 15:19:47)
Help regarding Sql Performance Tuning
(7 Mar 2008 15:8:53)
skip update statement with row-id in logical stand database
(7 Mar 2008 14:47:10)
desformat=xml view with excel
(7 Mar 2008 13:54:56)
RAC book
(7 Mar 2008 13:1:52)
Oracle Enterprise Manager 10g on Windows installation guide
(7 Mar 2008 12:32:38)
Need help troubleshooting login and db start problems
(7 Mar 2008 11:14:17)
Undo tablespace issue
(7 Mar 2008 9:35:25)
promlem in opening sqlplus
(7 Mar 2008 6:9:1)
Oracle 10g Express monitoring
(6 Mar 2008 20:57:43)
Expdp with Archivelog ON
(6 Mar 2008 18:55:26)
syn of logical to primary error
(6 Mar 2008 17:40:59)
Oracle 11g Startup & shutdown Script on IBM AIX
(6 Mar 2008 17:37:14)
run explain plan of Toad
(6 Mar 2008 17:3:38)
can Opatch do not match the version of database?
(6 Mar 2008 17:0:8)
determining memory usage
(6 Mar 2008 16:38:42)
move tablespace
(6 Mar 2008 15:38:50)
Error While starting Database --vineet
(6 Mar 2008 14:25:2)
Problems with upgrades from 9204 to 9208
(6 Mar 2008 13:39:48)

oracle lazydba home page