Oracle

February 2005

one large DB vs several smaller DBs
(28 Feb 2005 23:30:42)
Slow login to 10g database
(28 Feb 2005 22:26:24)
Parsing
(28 Feb 2005 21:34:24)
Oracle Vulnerability Issue - URGENT
(28 Feb 2005 20:31:13)
OEM Agent-Jobs - oralogon as sysdba
(28 Feb 2005 19:58:13)
what's db_file_multiblock_read_count ?
(28 Feb 2005 17:10:31)
Re: unable to extend table
(28 Feb 2005 16:26:40)
Error while installing patch #2513629.
(28 Feb 2005 15:17:20)
Checklist for Database Health Check
(28 Feb 2005 15:16:16)
Need Solution
(28 Feb 2005 15:8:37)
aiowait and skgpspawn failed errors?
(28 Feb 2005 13:58:58)
Create Index Taking Too Long
(28 Feb 2005 12:29:31)
How to estimate what will the archivelog size for my database?
(28 Feb 2005 11:6:35)
TNS_ADMIN
(28 Feb 2005 10:58:27)
SQL to check allocated space against actual space used/required
(27 Feb 2005 9:47:8)
SAP Internals of tables growth in Oracle
(27 Feb 2005 9:42:25)
applying patch set
(27 Feb 2005 7:54:23)
Import Problem
(27 Feb 2005 3:58:27)
How to change Russian Character set
(26 Feb 2005 18:6:37)
HOW TO UPGRADE FROM 8.1.7.0.0. TO 8.1.7.4.0 IN NT
(26 Feb 2005 15:37:40)
Error on startup - HELP
(26 Feb 2005 15:1:46)
LISTOWNER- EMAIL SHIELDING
(26 Feb 2005 14:0:5)
LISTOWNER- Too Many Emails in your inbox?
(26 Feb 2005 14:0:2)
db link problem
(25 Feb 2005 22:18:23)
SQL Trace
(25 Feb 2005 21:14:38)
Order By
(25 Feb 2005 21:4:41)
Can i use commit in PL/SQL block
(25 Feb 2005 21:3:44)
webpage
(25 Feb 2005 19:8:34)
Executing Oracle Stored Procedure
(25 Feb 2005 17:48:7)
Weird issue ORA-03113:
(25 Feb 2005 16:25:50)
LONG vs CLOB
(25 Feb 2005 10:10:25)
Oracle in SINGLE USER mode
(25 Feb 2005 9:11:36)
Corrupted TEMP tablespace
(25 Feb 2005 8:54:57)
Quest-LiveReorg or DBArtisan or BRSPACE or just script it
(25 Feb 2005 8:15:30)
err 3113 and 12518
(25 Feb 2005 7:53:23)
Slow response
(25 Feb 2005 7:20:27)
Re: SFTP tool for batch download, Windows
(25 Feb 2005 7:19:49)
LONG,LONG RAW, LONG to CLOB,BLOB,LOB whatever and vice versa
(24 Feb 2005 19:52:4)
PL/SQL
(24 Feb 2005 18:44:7)
How many log switches since TIME HH24:MI:SS
(24 Feb 2005 18:20:53)
Re: XML in Oracle 9i on AIX-errors
(24 Feb 2005 18:15:35)
Oracle Application Server Logoff
(24 Feb 2005 17:12:55)
AL16UTF16 to US7ASCII
(24 Feb 2005 15:49:31)
Enterprise Manager Import Errors
(24 Feb 2005 14:52:26)
********Question Please *************
(24 Feb 2005 14:31:45)
Accepting user input from inside pl/sql block
(24 Feb 2005 13:42:51)
Tablespaces
(24 Feb 2005 13:41:7)
require a query
(24 Feb 2005 13:15:23)
default database
(24 Feb 2005 12:57:30)
very urgent
(24 Feb 2005 12:52:10)
Query
(24 Feb 2005 12:49:56)
import user's schema
(24 Feb 2005 12:48:47)
import using cmd window
(24 Feb 2005 12:44:36)
oracle managemnet server
(24 Feb 2005 12:28:47)
batch file
(24 Feb 2005 11:56:49)
How determine the hardware model - AIX?
(24 Feb 2005 11:50:21)
Upgrade Oracle 9i to 10g
(24 Feb 2005 11:48:35)
Analyze partition
(24 Feb 2005 11:27:25)
Quick Question - version support
(24 Feb 2005 11:9:51)
SQL Analyze
(24 Feb 2005 11:1:59)
Some has a metodology for desing PL/SQL PAKAGES
(24 Feb 2005 10:40:43)
Urgent help
(24 Feb 2005 8:38:11)
Oracle problems
(24 Feb 2005 7:35:0)
ORA-06413
(24 Feb 2005 7:23:54)
Oracle Redo Log Files Issue
(24 Feb 2005 7:18:49)
Text file import
(24 Feb 2005 7:7:5)
IMP-00020, long column too large for column buffer size (10)
(24 Feb 2005 5:50:48)
Solaris script for alerting on error logs
(23 Feb 2005 21:32:42)
Interesting finding about the importance of 'system' stats
(23 Feb 2005 21:30:33)
System Tablespace
(23 Feb 2005 19:52:27)
Gethitratio vs Pinhitratio
(23 Feb 2005 18:20:34)
upgrade from 8.1.7.4 to 9.2.0.5
(23 Feb 2005 15:12:17)
Oracle 817 problem
(23 Feb 2005 14:39:22)
Solaris Tunnelling
(23 Feb 2005 10:15:29)
Help Needed
(23 Feb 2005 10:10:46)
archive log
(23 Feb 2005 9:55:8)
How to replace enter ?
(23 Feb 2005 7:36:24)
Re: UPDATE DATA TYPE IN TABLE
(23 Feb 2005 7:19:53)
Will this applying of the REDO logs work? Possibly a stupid question
(23 Feb 2005 3:40:20)
How to create a default partition
(22 Feb 2005 23:48:33)
Date parameters in Reference cursor Where clause
(22 Feb 2005 20:37:13)
Maryland
(22 Feb 2005 16:12:25)
dbms_profiler
(22 Feb 2005 16:4:20)
Learning SQL / SQL +
(22 Feb 2005 16:4:20)
Oracle query takes alot longer on system tables/views unders windows
(22 Feb 2005 15:57:58)
pl/sql web toolkit
(22 Feb 2005 15:43:48)
How does using a SAN alter the allocation of disks?
(22 Feb 2005 15:28:35)
General Question about Oracle based application
(22 Feb 2005 15:4:49)
Unicode support - multiple language support in Oracle
(22 Feb 2005 15:4:38)
Re: Help on scripts
(22 Feb 2005 12:30:6)
How to use SQL Loader ?
(22 Feb 2005 12:0:17)
Makefile for Pro*C program compilation on Sun Solaris 9
(22 Feb 2005 9:22:38)
Managing password file.
(22 Feb 2005 8:19:53)
alter table ' ' move
(22 Feb 2005 7:38:53)
SGA Sizing
(22 Feb 2005 7:33:21)
Re: External Table
(22 Feb 2005 5:2:26)
Career paths.
(22 Feb 2005 0:46:41)
what does it take to run OPATCH ?
(21 Feb 2005 19:12:57)
/usr/lib/pa20_64/dld.sl: Unable to find library 'libjox8.sl'.
(21 Feb 2005 15:51:52)
Linked Servers
(21 Feb 2005 13:52:7)
replication or streams
(21 Feb 2005 13:12:43)
Function Based index
(21 Feb 2005 11:37:43)
Regds Java Source class file
(21 Feb 2005 11:12:19)
newbie update statement
(21 Feb 2005 8:1:19)
Filesystem converter program/software
(21 Feb 2005 5:14:35)
Foreign keys
(21 Feb 2005 5:10:1)
same statement parsing again??
(21 Feb 2005 4:18:32)
Moving Oracle databases from UNIX to Microsoft
(21 Feb 2005 2:4:59)
How to check which is the next archived log to apply
(21 Feb 2005 2:2:54)
System RBS too small when using UNDO
(20 Feb 2005 22:32:25)
Cold Backups
(20 Feb 2005 13:56:30)
A good (DEFINITIVE) glogin or login.sql... SQL*PLUS
(20 Feb 2005 12:20:6)
export procedure
(20 Feb 2005 9:17:20)
Implementing RMAN - Gotcha's?
(19 Feb 2005 4:37:1)
Re: Implementing RMAN
(19 Feb 2005 4:35:40)
Rollback segment too small
(19 Feb 2005 1:35:7)
I am getting errors trying to create procedures
(18 Feb 2005 18:46:7)
dbms_job error...
(18 Feb 2005 16:23:44)
Urgent - Performance Problem 8.1.7.4
(18 Feb 2005 13:55:11)
Join me
(18 Feb 2005 13:49:14)
Help to start Apache in LINUX
(18 Feb 2005 11:31:10)
Sleep function ...
(18 Feb 2005 8:11:43)
htp package
(18 Feb 2005 7:2:24)
A new machine!!!
(18 Feb 2005 6:49:54)
DBMS_JOB
(18 Feb 2005 6:33:46)
Theorotical questions
(18 Feb 2005 4:8:15)
Export Failure - please help asap
(17 Feb 2005 22:7:16)
Re: patch failure-105090
(17 Feb 2005 19:18:55)
Discoverer Plus
(17 Feb 2005 19:4:24)
Any help would be really good - ORA-121154: TNS: could not be resolve service name
(17 Feb 2005 18:28:45)
actual database usage
(17 Feb 2005 17:51:57)
Re: end-of-file on communication channel
(17 Feb 2005 17:30:45)
Suggested book
(17 Feb 2005 15:20:54)
ORA-01041:internal error,hostdef extension doesn't exist
(17 Feb 2005 11:28:45)
on startup get ora-00313 and 00312
(16 Feb 2005 23:22:22)
tablespace logging
(16 Feb 2005 22:52:16)
Oracle writing backups to attached tape drives
(16 Feb 2005 19:39:6)
Finding Unix block size in Bytes
(16 Feb 2005 19:3:53)
Index creation problem
(16 Feb 2005 17:45:6)
max length of data
(16 Feb 2005 16:49:20)
create any procedure
(16 Feb 2005 15:25:47)
URGENT!!!- PROBLEM WITH THE IMPORT TOOL!!!!!
(16 Feb 2005 15:21:14)
Still having the problem with the import tool!!
(16 Feb 2005 15:15:11)
unix/linux question
(16 Feb 2005 14:23:54)
Oracle Tools
(16 Feb 2005 13:42:33)
10g export file problem
(16 Feb 2005 13:21:51)
oracle_shutdown parameter
(16 Feb 2005 13:5:10)
Problem with database
(16 Feb 2005 11:43:20)
recovery question
(16 Feb 2005 8:43:11)
RAM and SGA size
(16 Feb 2005 7:25:48)
SQL please
(16 Feb 2005 7:11:26)
Which statement causes most redo
(16 Feb 2005 7:4:49)
to find which datafile is not having any data
(16 Feb 2005 6:31:42)
ORACLE DB AUDIT TOOLS
(16 Feb 2005 5:15:41)
How to find which datafile is not having any data?
(16 Feb 2005 5:13:15)
assigning variable in sql statement
(16 Feb 2005 3:41:29)
PL/SQL question
(15 Feb 2005 23:53:55)
move data file without dropping the DB?
(15 Feb 2005 17:27:7)
Re: component 'LOADFILEFROM'
(15 Feb 2005 16:45:36)
stubborn table
(15 Feb 2005 14:29:31)
Help Sought
(15 Feb 2005 14:3:45)
Perl DBI in multiple homes
(15 Feb 2005 13:24:58)
Drop Issue
(15 Feb 2005 13:12:31)
can't open odbc connection to alternate database
(15 Feb 2005 10:21:57)
Range selection
(15 Feb 2005 10:6:13)
Concurrency Problem - URGENT
(15 Feb 2005 6:59:19)
What's UTF8
(15 Feb 2005 5:2:59)
DB won't recover with "recover database" command
(15 Feb 2005 3:50:31)
would you backup OEM repository and Application Server
(15 Feb 2005 1:17:8)
rename a tablespace
(14 Feb 2005 23:18:15)
DBA looking
(14 Feb 2005 22:3:1)
Why is this doing a FTS? ( is this Normal?)
(14 Feb 2005 20:12:37)
incremental backup
(14 Feb 2005 18:42:34)
Re: Restore table from backup file
(14 Feb 2005 17:4:37)
Subtracting Time in using PLS/SQL
(14 Feb 2005 16:38:38)
Pl/Sql help
(14 Feb 2005 16:30:56)
Datafile Recovery
(14 Feb 2005 16:1:49)
Audit Oracle object
(14 Feb 2005 14:28:26)
incremental backup+oracle9i
(14 Feb 2005 14:24:48)
Third party tools for database reorganization
(14 Feb 2005 14:18:16)
Performanace Tuning
(14 Feb 2005 3:41:34)
Analyzing Explain Plan
(14 Feb 2005 3:35:3)
ORA-01023 ERROR
(13 Feb 2005 17:48:41)
ALTER TABLE MOVE and ALTER INDEX REBUILD
(13 Feb 2005 13:4:2)
CLOB datatype
(13 Feb 2005 10:40:47)
Queries asked in Interview
(12 Feb 2005 13:3:51)
PL/SQL Gateway
(12 Feb 2005 11:14:39)
Re: adding datafile
(11 Feb 2005 23:41:28)
Script to Compare Data in Two Oracle Databases
(11 Feb 2005 20:54:45)
Plan stability with rule based optimzier
(11 Feb 2005 20:18:46)
SQL Statement Error
(11 Feb 2005 15:10:44)
ora-12154 error
(11 Feb 2005 14:36:8)
Oracle Cube Viewer
(11 Feb 2005 14:34:10)
Finding which column of table is indexed
(11 Feb 2005 11:19:39)
help with ora-04021 and dba_internal_locks
(11 Feb 2005 11:14:33)
Help with this query
(11 Feb 2005 10:40:2)
Single Record Lock
(11 Feb 2005 10:10:33)
Shedule a stored procedure.
(11 Feb 2005 9:58:26)
Graceful failure on insert trigger if destination table is not found?
(11 Feb 2005 9:48:33)
Error ORA-12540
(11 Feb 2005 5:18:38)
Solaris Kernal Changes
(10 Feb 2005 23:36:55)
SQL*Plus spooling
(10 Feb 2005 22:50:11)
Shutdown DB via Enterprise Management Console
(10 Feb 2005 22:7:38)
Enabling SQL_TRACE for system wide on Oracle 9i
(10 Feb 2005 21:22:34)
MATERIALIZED VIEWs on ALTER TABLE
(10 Feb 2005 21:21:31)
Materialized View error ( new version )
(10 Feb 2005 18:30:0)
Materialized View Error
(10 Feb 2005 18:15:52)
ORA-00997 ; illegal use of LONG DATATYPE
(10 Feb 2005 15:0:57)
Migrating/moving tables with LONG and LONG RAW columns frm DMT to LMT
(10 Feb 2005 14:42:44)
stored outline for a 3rd party application
(10 Feb 2005 13:43:24)
Restore question
(10 Feb 2005 13:35:4)
Export File Size
(10 Feb 2005 11:13:15)
Migrating database from one linux server to another
(10 Feb 2005 11:10:6)
Running an Oracle script on Linux
(10 Feb 2005 10:34:49)
Exam 1Z0-036: Managing Oracle9i on Linux
(10 Feb 2005 7:52:13)
Some questions on Accounts and Oracle Client
(10 Feb 2005 4:55:10)
dbstart, dbshut under Linux
(9 Feb 2005 22:42:39)
Translate function.
(9 Feb 2005 21:48:32)
Oracle to Sybase connectivity options
(9 Feb 2005 21:39:17)
Portal Self Registration
(9 Feb 2005 20:49:22)
SQL Question
(9 Feb 2005 18:54:50)
SQL Loader Question
(9 Feb 2005 18:11:51)
HasIndex function
(9 Feb 2005 16:26:23)
Set IP and Host name
(9 Feb 2005 15:49:4)
Restrict a user from taking export his own tables.....
(9 Feb 2005 14:5:0)
Mv command
(9 Feb 2005 14:3:8)
Re: UNIX question
(9 Feb 2005 12:49:30)
DatGuard
(9 Feb 2005 11:33:59)
Oracle 8i on redhat linux advanced server
(9 Feb 2005 11:30:8)
No of concurrent users
(9 Feb 2005 11:16:48)
Replacing multiple spaces with one space
(9 Feb 2005 10:16:0)
Composite data type
(9 Feb 2005 9:20:24)
Ignoring Tablespace Sizings that Can Autoextend
(9 Feb 2005 8:35:50)
Character set of a string
(9 Feb 2005 5:5:15)
SORTING DATES of the format DD-MON-YYY HH24:MI:SS
(9 Feb 2005 0:19:32)
Offline/Offsite Database Synchro Solutions
(8 Feb 2005 22:48:33)
Moving entire database
(8 Feb 2005 21:16:47)
Improving performance on V$ & DBA queries
(8 Feb 2005 15:48:51)
How to use Scanner in Developer 9i and save the picture in DB
(8 Feb 2005 12:16:53)
STATUS of ROLLBACK SEGMENT
(8 Feb 2005 7:17:0)
Orphaned sessions on Web server.
(8 Feb 2005 6:23:43)
best disk config on Solaris V880
(7 Feb 2005 22:37:15)
Grants
(7 Feb 2005 21:3:37)
Maintaing VLDB
(7 Feb 2005 19:3:52)
ORA-03113
(7 Feb 2005 14:34:23)
sufficient next extent space
(7 Feb 2005 14:21:12)
Converting this Oracle update Statement to SQLserver update
(7 Feb 2005 3:8:53)
Connection Questions: Pro C and Standard Oracle Client
(6 Feb 2005 22:16:34)
OT - Belkin/FC2
(6 Feb 2005 15:40:22)
tricky sql report...
(5 Feb 2005 21:44:52)
Migrating DMTs to LMTs using third-party tools to reorg database
(5 Feb 2005 8:22:22)
A challange for the experienced.... or not....
(5 Feb 2005 5:1:21)
Want SQL to be echoed prior to execution
(4 Feb 2005 13:53:22)
Desc in 9i
(4 Feb 2005 8:48:11)
how long after terminated session?
(4 Feb 2005 0:50:29)
Script to create parfile for export
(3 Feb 2005 19:27:59)
db character set
(3 Feb 2005 18:27:11)
Oracle designer objects
(3 Feb 2005 18:5:14)
Can clients coexist
(3 Feb 2005 15:13:15)
ORA-12638
(3 Feb 2005 13:6:38)
How to retrive top N rows?
(3 Feb 2005 5:41:47)
Invalid data being entered.
(3 Feb 2005 2:20:54)
Discoverer error
(2 Feb 2005 22:40:51)
utl_file error
(2 Feb 2005 21:19:5)
Monitoring for long running SQL statements (8i)
(2 Feb 2005 20:44:17)
Trying to extract the most current record
(2 Feb 2005 17:27:47)
block corruption!! urgent
(2 Feb 2005 14:41:18)
Enforcing date only values entered and not time
(2 Feb 2005 13:42:38)
date time conversion 12 months out
(2 Feb 2005 13:35:13)
Retrieve varchar column's from db2 using HSODBC
(2 Feb 2005 13:26:40)
SQL Loader Help
(2 Feb 2005 13:8:12)
Time upto Nanoseconds
(2 Feb 2005 12:22:40)
change the sort order
(2 Feb 2005 12:20:59)
Queries
(2 Feb 2005 11:59:16)
Urgent Help Needed
(2 Feb 2005 11:9:34)
rman question
(2 Feb 2005 10:41:57)
How To Create Job ?
(2 Feb 2005 6:3:56)
Oracle 10gAS Infrastructure install errors
(1 Feb 2005 21:13:46)
Patch analysis
(1 Feb 2005 21:2:22)
Email from Forms
(1 Feb 2005 19:10:58)
Request takes too much time! Please need a help
(1 Feb 2005 19:4:57)
Compare two tables
(1 Feb 2005 14:21:8)
Finding triggers/procedures names populating a table
(1 Feb 2005 13:50:29)
Finding table and column name that holds a given value
(1 Feb 2005 13:45:33)
another upgrade question....
(1 Feb 2005 12:53:35)
Middle Tier Process Manager Fails to Start
(1 Feb 2005 12:3:30)
stored procedure help
(1 Feb 2005 10:57:55)
Recreate UTL_FILE package and package Body
(1 Feb 2005 10:23:36)
Oracle 9i Databse export on Tape
(1 Feb 2005 10:4:44)
Discoverer 10g
(1 Feb 2005 10:3:57)
date coversion as interval - 12 months
(1 Feb 2005 7:30:23)
Query help!!
(1 Feb 2005 7:19:42)
Date issue
(1 Feb 2005 3:55:49)
Scenario case
(1 Feb 2005 3:52:0)
oracle lazydba home page