Home ->
Community ->
Usenet ->
c.d.o.server ->
by subject
c.d.o.server: by subject
- %rowtype
- 'history' for SQL commands
- (long and boring) Any way to reduce waits over the link? (SQL*Net message from dblink)
- 2 questions, deleting a tablespace on a damaged instance and tablespace
- 64k or 128k stripe - 8k block 8 multiblock read?
- 8.1.7 Enterprise memory limit?
- 9.2.0.3 client to exp 8.1.5 DB
- 9.2.0.4 experiences
- 9.2.0.4 Patchset
- 9.2.0.4 update and event 10195
- 9i Data guard
- 9i parallel query is slower than 8i
- 9i RAC : OCFS vs Raw Devices
- 9i Standby Database & Production Online Redo
- 9iR2 on SuSE - where is oratab?
- [NOT SOLVED] performance tuning questions: replace IN (values) by JOIN
- [Oracle] "CREATE JAVA SOURCE" via ODBC?
- [PL/SQL] Objects
- [SOLVED for good] performance tuning questions: replace IN (values) by JOIN
- [SOLVED for good] performance tuning questions: replace IN (values)by JOIN
- [SOLVED for good] performance tuning questions: replace IN (values)byJOIN
- A couple of questions
- A couple of tablespace questions for the experts
- A PROBLEM: installing Oracle 9i under Linux.
- access active partitions simultaneously
- Accessing components of an object within a varray...
- Add Node in Enterprise Manager Console problem
- Administrator / domain user differences Oracle9i
- ADO & PL/SQL: Return cursor from procedure (performance question)
- Advanced SQL Programming Book Recommendation
- Allowing Oracle transactions to span client processes.
- Analyze Command and Privileges
- Any way to reduce waits over the link? (SQL*Net message from dblink)
- anyone working on Oracle E-business Suite?
- Apache binaries comes with 9i database
- ARCHIVE and NO ARCHIVE ?!?!?!?
- archive redo logfile
- authentication using x.509 certificates
- Automatic startup of multiple instances on one Win2k-Machine??
- Avoiding any locks in SQL Servers - read and understand....itsmagic.
- Avoiding ORA-4021
- backup and recovery drills
- Backup with Veritas 9.0
- BIG PROBLEM - NEED HELP
- Blocking Lock (TC) by CKPT
- Books for Oracle Exam #1Z0-147
- Buffer gets
- bug with scrollable recordsets
- calc field
- calling sqlplus from unix shell script error
- Can cursors be cached in Pro*C dynamic sql?
- Can you explain the indication of "command_type" and "open_versions" column in the v$sqlarea
- Can't log in any more - Help
- Cannot access OEM in network mode from client machine
- Cannot connect as Internal....?
- Case sensitive Tablenames
- case-insensitive foreign key
- Changing transactional capabilities of a remote HS database
- Character confusion
- CHECK Constraints
- CHECK ConstraintsQ
- Choosing between Solaris and HP-UX 11i
- Clustering
- CMAN and NAT. What's wrong?
- Commit select-statement ?
- Company thought DB2 will be better than Oracle.
- Compare Performance Monitoring Tools
- Compatible parameter 8.1 or 8.1.7
- Complex SQL performance question
- configure Oracle9ias DAD
- confused between explain plan and analyze table
- connecting to sqlplus in 9i to create db problems
- Connection between Oracle 9i Server and Oracle 8i Client using JDBC
- Connection problems with TNS Listener
- Control File problem
- Copy Table Via OCI
- Cost of Access Plan using Bitmap Indexes
- CPU Costing
- create user in PL/SQL package e.t.c.
- Creating DB Manually
- creating IFS schema via XML files & updating classdomain of attributes
- csv files
- CTIME zero in v$lock
- cursor parameters with null values
- Cursor with schema name change
- Cursors, ExecuteNonQuery and C#
- Customising portal interfaces
- Data Guard query
- Database Design on RAID-5 based storage like HDS-99xx
- Database Integration Question
- Database Modeler and Database Analyst
- Database Upgrade: 9i Or 10g
- Datafile Crash and PMON error
- Date
- DB name
- DB recovery after OS crash, ORA-01210, ORA-01251
- DB Server and Application server on Same Hardware
- DBA Book for beginners
- dbms_alert.signal triggers a memory dump? why?
- DBMS_JOB submitted, but doesn't run?
- dbms_stats.gather_system_stats...
- Default names conventions for the pfile
- Deleting v$archived_log obsolete data
- Diagnosing Transaction Enqueue (TX) Locking Issue
- difference between block changes and consistent block changes
- difference between sys and sysman
- differences between t-sql and pl-sql (SQL Server to ORACLE migration)
- Direct Path Export vs. Conventional Path Export
- Disaster Recovery with Oracle
- Do I need Oracle Intelligent Agent?
- Does Oracle 10G new database still need an DBA to manage it?
- drop user hangs
- EMCA : ora-1017 invalid username/password
- Enabling Archivelog mode, Oracle7- any issues?
- Enhancing large table performance
- Error during instalation 9.2.0.1
- Error in starting Oracle 9.2.0.1 database on Redhat9
- Error not thrown back to Java app?
- ERROR:ORA-27101 Shared memory realm does not exist
- execute immediate gives error for statement that runs fine in SQL*PLUS
- extent on W2K caused datafile to go offline
- Fastest way to export stored procedures, triggers & packages to text file
- Fed Up with being a DBA
- file 1 needs media recovery
- Frequent Checkpointing ...
- Full Export / Import headache
- Full Table Scan....?
- Generic Connectivity
- get version number with SQL query?
- global index internals
- google giving "Unable to find thread. Please recheck the URL."
- Grant permissions on views with WITH clauses
- Group with daily emails of questions ..?
- Have Oracle Connection Manager obsoleted?
- Help -- Oracle Error -6550
- Help getting past missing archivelog file
- Help on connection to Oracle with Microsoft ODBC (VB 6.0)
- Help reg.Storing picturein a table
- Help with 9i install problem on E450 running Solaris 2.8
- Help with interpreting TKPROF output
- Help witth CConverting a Query
- Holy Smoke!
- Hot backup- want to group tablespaces in script during off-hours
- How change NLS_DATE_FORMAT
- How do you relate high I/Os waits to a specific file/process ?
- how does oracle handle bit errors?
- How hard do you hit Linux with 9i RAC
- How to arganize my scripts ?
- How to change the parameter COMPATIBLE to a higher value?
- How to check number of active Oracle cluster nodes ?
- How to document a DB
- How to get decimal to date form
- How to insert BLOB?
- How to know when an index needs rebuild ?
- How to load a string with blanks into a varchar2 not null column using SQL*Loader
- how to post with a fake email address?
- How to resotre Initialization Parameters
- How to tell if bind variables are being used?
- howto detect which index is corrupted
- I don't want more choice... I just want nicer things
- I need the STS 033
- I think the worm just brought down yahoo...
- I was hoping that ORA22863 would go away in 91r2...
- I'm being subjected to a DOS attack...
- I/O performance metrics?
- Identifying a datafile
- Importing huge data
- Importing into a new tablespace with a new user DK58974
- Increase db_block_buffers causes ORA-04031 error?
- INDEX and DATA Tablespaces.....
- index not used question
- indexes
- Indexes on Global Temporary Tables
- insert user and data login in a table
- Inserting performance issue
- Install new version during production
- Installation Problem: 9.2.0.1.0 on RedHat Linux 8.0
- Installing Oracle 9i Release 2 RAC in a single node?
- installing Oracle on Slackware Linux 9.0
- installing oracle.net.ca
- Interconnect bandwith problems in RAC? Solution provided!
- Interesting DB article
- interpreting 10053 trace for hash join
- Intersolv Oracle 7 driver connecting to Oracle 9 database
- Is index used for constraint enforcement?
- Is it possible to convert tablepace from temporary to permanent?
- Is it possible to recover just one datafile/tablespace "until cancel"?
- Is Richard Niemiec Right
- Is there any hope of geting a datafile in RECOVER mode backe?
- Is this a good situation for an Index ?
- isql*plus and apacheserver problem
- Itelligent Agent doesn't start after changing hostname !!!
- java class wrapper
- Job execute problem
- kernel panic on Red Hat AS because of OCFS
- kernel upgrade on RH AS 2.1
- Label Security: Maybe I missed another naming but ...
- Large Index organized tables: just a marketing feature ?! (for experts)
- Large memory support on 9.2.0.4 / W2K Adv Svr - it works.
- Latest Oracle client version for 8i (8.1.7)
- Linked server using msdaora. from SQL server to Oracle.
- Linux filesystems & oracle performance
- listener does not start as root user
- LISTENER PROBLEMS
- LMT advice
- Loading data in DB from a variety of sources
- lock table lock release
- locks on objects that are modified (DDL) ..
- log miner end-of-file on communcation channel
- LOG_ARCHIVE_DEST to up to 90 remote locations????
- long to clob with ms_word "open quote"
- Long Type for replication
- Looking for 9iR2 Personal Edition
- Looking for SQL Trace articles
- M_IDEN, M_XDBI (what are they ?)
- Making Oracle on NAS more resilient to network failures
- Manually fix archive gaps?
- Materialized view replication and foreign keys
- Materialized View vs. Manual summary job
- Memory leak
- memory leaks with OO4O92045 Using VC6.0
- Merge System Datafile in Oracle v7.3
- Message for Connor McDonald (REF: his reply)
- migration entre server
- Missing svrmgrl
- mod_ssl with Oracle 9i Apache
- Most frquently used SQL- Set transaction isolation level
- move tables with longs
- MS Word to Blob
- Mulitple oracle home and tnsnames.ora directories
- multiple resultsets open
- Multiplexing in RAID 5
- My Agent is being Recalcitrant!!
- my function to run in Sqlplus console
- My language is broken in oracle
- Need Expert Help - dbca fails (ORA-27047) on raw vol. 9201 SuSE SLES8
- need help tuning a very large delete
- need some help with XML connections
- Net App Filer
- Net9 and OTG 4 (Informix)
- New Oracle 10G BI&DW Features
- New Oracle server installation on Windows
- New Oracle tool : Dataviewer Pro
- New Oracle tool : New Spamer
- newbie creating a database manually
- Newbie help with explain plans
- Newbie on Oracle Installation
- News from Oz
- NLS_LANG and Unicode
- NO_DATA_FOUND exception
- non-deterministic results by adding an output SELECT column...
- Not able to run Java Petstore sample with oracle
- NT-error code after using oradim to shutdown instance
- null event causing concern
- Numeric characters after alphabetic characters sorting varchar2 fields
- O9iAS Portal: Copy Page to another Page Group?
- OCFS trouble on Red Hat Advanced Server?!
- OCI DirPath
- OCI: How to insert BLOB?
- ODBC connetion lost with shared server
- ODBC drivers
- ODP.NET, stored procedures and database links
- Oemapp Dbastudio Problem
- OLTP configuration suggestions
- One Listener for two differerent oracle home
- Ongoing oracle 8i support
- OO4O sequence problem
- Optimal degree of parallelism
- Optimal degree of parallelism (long)
- ORA-00331 Error
- ORA-01031 following install of 8.1.7.4 patch
- ora-01401 error
- ORA-01417: a table may be outer joined to at most one other table
- ORA-01437: cannot have join with CONNECT BY
- ORA-03114 and Remedy
- ORA-04031 - Oracle 9.2.0.3.
- ORA-04031 Problem
- ora-12547
- ORA-12547: TNS: lost contact...? during DBCA
- ORA-12571 error
- ORA-12663 and dblinks to non-oracle table
- ORA-1652 no matter how big temp tablespace made
- ORA-24329: invalid character set identifier - Please help
- ORA-27101: shared memory realm does not exist
- ORA-28278: No domain policy registered for password based GLOBAL users.
- ORA-28576 Newbie Question
- ORA-600 Error
- Oracle 8 client usage through firewall
- Oracle 8.1.5 Database Enterprise Edition and COM+
- Oracle 8.1.7 Database Reorganisation
- Oracle 8.i --> Oracle 9i + Unicode
- Oracle 817 crashes when i change sys password.
- Oracle 8i ----> 9i Upgrade on Solaris
- Oracle 9i Installation
- Oracle 9i on Windows Server 2003 64 bit
- Oracle 9i RAC on RH Linux on HP out-of-the-box cluster
- oracle 9i replication
- Oracle 9i service on XP won't start???
- Oracle 9i: Adding Databases in the Enterprise Manager Standalone Console
- Oracle 9iAS
- Oracle and Access
- Oracle and Java
- Oracle Backup with Veritas
- Oracle can be Case Insensitive ?
- oracle crashes - ORA-07445 ORA-00601
- Oracle Database 10g release date?
- Oracle Database 10g. When ?
- Oracle DBA Job or Oracle Apps Support?
- Oracle Diagonstics Pack 2.0.4
- Oracle equival to SQL Server @@IDENTITY
- Oracle Express on Linux AS & FreeBSD
- Oracle home selector
- Oracle Intelligent Agent
- Oracle jobs not running. Help
- Oracle Net remote buffer product?
- Oracle Password Maintenance
- Oracle performance with Microsoft Project
- Oracle proc. from VB in ADO
- ORACLE requirement to implement automatic standby DB
- Oracle Software Owner WIndows 2K
- Oracle tables and ODBC field sizes..
- Oracle Users in the UK - may be interested.
- oracle8.1.6 install on aix5.1 linking error
- OT - with PL/SQL in 10G,
- OT: Interesting DB article
- Parallel thread spinning
- Partitioning and Index Question
- Patch set release 9.2.04 for Unix AIX 5.1 32 bit
- Patchset 9.2.0.4
- Pb with Oracle9i on Mandrake 9
- Performance base line
- Performance Monitoring Tools
- Performance problem with SQL query
- performance tuning questions: replace IN (values) by JOIN
- Personal Oracle 9i automatic startup
- Physical Layout of disk to use Oracle
- PL / SQL HtmlForm
- PL/SQL where clause quandary
- Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
- Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem - ANSWER
- Polling SQL Queries
- Poor Oracle performance with Solaris 8 on a Sunfire, talking to a SAN
- Preferred way to check a record exists
- Primer backup en Caliente
- Prints in bitmap mode when using designer but character when using the application
- PRKP-1011 error in RAC!!??
- Pro*C From Windows
- ProAct products
- Prob. install Oracle9iR2 with Red Hat ES 2.1
- Problem deleting records in Oracle 9i release 2 JDBC driver with JDK 1.4
- Problem with Decode fuction
- Problem with SS7(WinNT) -> O9i(Solaris) Migration
- Problems using JTA
- Problems when installing Oracle provider for OLE DB
- puzzling deadlock
- Q: How to skip data from a certain column during import
- query does not use INDEX RANGE SCAN
- Query for Top 10 Most "Expensive" Queries
- Question about NCHAR columns and Upgrade from 8i to 9.2.0.3
- question about rollback and redo
- Question of dbms_logmnr
- Question on Creating a Package
- Question to Oracle DBAs in Australia.
- Questions on External Tables
- Questions on External Tables - OOPs
- RAC & Linux
- RAC 9.2, LVM in 2 node cluster
- RAID 5 on Oracle....?
- RDMBS and Java - a "clash of civilizations" ?
- really wierd error
- reclaim space
- Red Hat Readies Enterprise Linux 3 - glad I waited
- Redirecting output from DBMS_OUTPUT
- Remote login password file questions.
- Removing cookies
- Repeat Values in query (Bug or design flaw)
- Replicating an entire schema ...
- Replication and RAC
- Replication+database links
- resolving buffer busy waits
- resuming a loop
- Retrieving output parameter from Oracle
- Return value from SSORunning function is INVALID
- RFD: comp.databases.etl
- RH Linux 8 vs Windows XP -- Question...
- RMAN scripts...
- RMAN won't write to mapped drive under Windows
- RMAN, Legato, DBMS_BACKUP_RESTORE.DEVICEALLOCATE
- rounding to 15 seconds
- runInstaller for Oracle 9.2.0.1 on Solaris doesn't start...
- SEARCHING FOR TEXT PATTERN IN "LONG" COLUMN
- Select Function Returning Results of Select on Tables
- setting the variables for oracle user
- setting uo variables when linux starts
- setting up oracle 9i server
- setting up variables
- Setup does not start
- Several instances
- Several oracle instances
- shrept.lst: what is this file?
- Shrink Temporary Tablespace
- Simple SP with Simple SELECT
- Simple Upgrade questions
- slow performance in query a view
- soft parses of recursive (system) statements
- software volume striping in WinXP
- Solved: Materialized view replication and foreign keys
- Specifying drive letter in RMAN
- SQL Approach, Multiple Tables, UNION?
- SQL hints/ways of enhancing sort/GROUP BY queries...
- SQL Server Tables to Oracle Database
- sql works in access, doesnt work in oracle
- SQL*Loader - Commit point reached - logical record count 27
- SQL*Net, overcoming NAT via CMAN?
- sqllder hangs at 99-100% CPU on select of fet$
- sqlldr locks fet$ and uet$, blocks smon, 100% cpu usage
- sqlldr locks up fet$, uet$, spins to 100% cpu
- sqlldr question?
- SQLLDR.exe
- SQLPlus & TNSListener
- sqlplus script in a pl/sql procedure?
- Standby Database
- Standby Database and Oracle Standard Edition 9i
- Standby database, and its status
- Standby recovery
- star transformation not chosen because of bind variables
- Statistics for comp.databases.oracle.server - WE 08/31/2003
- Statistics for comp.databases.oracle.server - WE 09/07/2003
- Statistics for comp.databases.oracle.server - WE 09/14/2003
- Statistics for comp.databases.oracle.server - WE 09/21/2003
- Statistics for comp.databases.oracle.server - WE 09/28/2003
- Storing PDF files on a database
- Strange Optimization in Oracle 8
- strange select issue
- Strange: after TRUNCATE I noticed the obj# differs in a segment hdr dump
- Streaming Oracle9i based RealVideo with RealServer and interMedia
- Suggestions for first exam ...
- sybase to oracle migration
- Synchronization question.
- System Change Number
- SYSTEM Tablespace is FULL
- Table cast and memory consumption
- tables with longs
- Temporary tables in memory
- temporary tablespaces
- The Age Old Unclearly Answered Question: Write-Through or Write-Back
- This small query kills oracle 9.2.0.3 (nightmare)
- timed_statistics = true and db "hangs"
- TNS Listener (9i) Uses Port 8080
- Toad Server Dump
- Tom Kyte a false idol?
- Tom kyte's New book
- tool to visual check differences in output from 2 sql queries
- Top 'N' Analysis
- Triggers and :new :old
- trouble with dbms_job...
- Tunning question
- UNion Versus Or
- Unix script to monitor iostat on AIX 4.3.3
- updating current row of cursor resultset in OCI
- Upgrade 7.3.4 to 9i: DBUA error
- Upgrade dependent on database history ?
- Upgrade from 8.1.7.0 to 8.1.7.4 on HP-UX - "smooth"?
- Upgrading a Windows 2000 server box with Oracle 8i to Windows 2003 Server with 9i
- Upgrading jre in Oracle 9idb
- URGENT: Slow Performance after migration to 9.2.0.3 from 8.1.7
- User datafiles and index on separate disks
- Using ojdbc14.jar with previous JDKs
- UTL_FILE_DIR
- Values in sys.hist_head$ table.
- Values insys.hist_head$ table.
- View creation in Oracle 8.0.5 database
- VxFS block size with db block size =16k
- W2K security for Oracle directories?
- Wait Statistics and tuning an individual query
- Website Monitoring
- What are tables and other objects with prefixes EPC_ and SMP_?
- What are the differences between Real Application Clusters, Guard I and Guard II?
- What is the difference?
- what to check before dropping a tablespace
- What's fast way to get total of records
- When and How to run dbms_stats.gather
- Where can I download JDBC-Driver 9.2.0.2?
- Where to find actual INITRANS for partitioned table.
- Which process spawns a dedicated server process?
- which SCHEMA are actually needed?
- Whither trace analyzer?
- Who's going to OracleWorld?
- why does an insert procude rollback segment data?
- Why does my Oracle instabce want an archivelog from the future?
- Why so many Gay Oracle people?
- Will Oracle 9i Release 2 be the last release for this version?
- Yahoo Group name: Oracle9iSQL
- zero filling a number
- Last message date: Wed Oct 01 2003 - 00:59:21 CDT
- Archived on: Sun Jan 09 2005 - 06:51:10 CST
|