Home ->
Community ->
Usenet ->
c.d.o.server ->
by subject
c.d.o.server: by subject
- 'drop tablespace' produces a file/table lock??
- 'Unbreakable' marketing strategy irresponsible?
- (corrected) 2 Oracle doubts
- (long) 2 Oracle doubts
- -- parameter obsolete
- --- Oracle database server connected wioth other servers . Which version???
- --Compatibility (easy one)
- 2 Oracle doubts
- 8.1.6 to 8.1.7.4 under Solaris 8
- 8.1.7.4 + 2 patches hangs on imp, strange waits
- 817 to 920 Upgrade manually or via DUA
- 8i (8.1.7.4.2) hangs on SHUTDOWN ABORT (WIN2000,SP3)
- 8i/9i cross version sqlplus connection problem
- 9.2.0.1.0 sys login question
- 9i DB + 9iAS + 9iFS Single Machine Install
- 9iAS on Redhat 7.3
- 9iR2 (DB and AS) on Red Hat Adv Server 2.1
- [DBMS_JOB] Problem with submitting jobs
- [Oracle8i]Immediate shutdown
- [PL/SQL] Distributed transaction
- A DBA's perspective on OracleJVM security mechanisms
- A model for storing SQL critieria / business rules..?
- a select within a count ??
- About undo blocks & read consistency
- Access to DBMS_JOB Interval Parser?
- Accessing 2 tables with 1 name
- Adonis on Oracle
- Advice on migrating from 8.0.5 to 8.1.7 on Windows
- alias for long object name
- All jobs are failing with ORA-01427 (WAS: Automatic refresh of snapshot is failing)
- All jobs are failing with ORA-01427 -- solved
- Almost Duplicate Database
- alternative resource for namesini.sql ?
- AMAZING ADDICTIVE FREE RPG *NOT OUTWAR* 9116
- Annoying IMP error
- Another index question
- Any experts on constraint deferrability?
- Any reasons why not to upgrade to 9i
- anyone use BEA WebLogic or IBM Websphere against an Oracle database?
- Anyone using CA Advantage Repository?
- anyway to commit/rollback for another session?
- Are temp segments being freed automacically or not ?
- Are temp segments being freed automacically or not ? - ThanX for *these* selects !
- Are you better than...?
- audit response
- audit select statements
- Automatic refresh of snapshot is failing
- Automatized Oracle9i Database installation and Creation
- Behaviour within DBA_TAB_MODIFICATIONS
- Bending the rules using MERGE INTO
- billing cpu usage of a monthly basis
- bitmap join index error
- calculate hit ratio using v$buffer_pool_statistics
- Calculate the date + a number of working days. HOW?
- calling SQL*Loader from OCCI
- Can I use Aggregate Functions and convertion function togather?
- cannot remove trace mode
- cannot start the management service on the local computer.
- CBO cost and avg_row_len
- Circular reference with private procedures in package
- Compaq DL 380 And Smart Array
- Compaq ML 570 Server For Sale
- complete refresh of large materialized view, online or any alternatives?
- Configuring Oracle Portal and Oracle 9ias
- connect by clause
- Connect to oracle oin redhat9
- Connecting from version 9.2.0.1.0 client to version 8.0.6 server
- Connecting to Oracle7 server from Oracle 9 problems
- Conversion
- copying a database from one server to another
- counting remaining extents on tablespaces
- cursor bind
- data replication tool
- database backup
- Database Design
- Database example
- DB Auditing & Intrusion Testing Tools
- DB Create Script
- DB Help!!!!!!
- DBA task for System DBA and Application DBA
- DBCA cannot run
- dbms_alert
- dbms_lob.read errors out with ORA-21560
- DBMS_RLS: Fine-Grained Access Control - Table name substitution
- Deadlock on overflow segment !? (for experts)
- Default value for DML_LOCKS
- delete cascade & trigger
- Designer6i Repository connecting to Oracle9iDB
- Developer 2000 v 4.5 in windows 2000
- DIFFERENTIAL BACKUP QUESTION
- directio performance question
- Discoverer
- Distinct XML Retured in Stored Proc
- do not cut decimal places
- Does an ALTER SYSTEM CHKPOINT write all dirty buffers to datafiles ?
- Does Oracle Intelligent Agent 9.2.0.1.0 takes up a lot of memory?
- Does Solaris 8 Intel X86 media Kit still include Oracle 8.1.7 CD in their bonus software?
- Domain catastrophe?
- drop table very slow in busy system EE 9.2.0.3
- dropping analyze objects from data dictionary
- dynamic parameterized order by clause
- Dynamic SQL Problems
- DYNAMIC SQL SELECTION QUESTION
- Editing the SNMP_RO.ora file
- Eliminate Duplicates Using SQLLDR and/or .ctl file
- Error Loading areasQueries
- Error with sqlplus80.exe
- errors during recompilation/revalidation of SYS.CDC_CREATE_CTABLE_BEFORE
- Exception Calling EJB via IIOP from Oracle database
- executing trigger and pl/sql
- exp-00037
- export & import data base without exp.exe & imp.exe
- Export Tool
- Export/Import Using Oracle XML
- Finding what have not been backed up in RMAN
- FREE Technical Seiminar: "Oracle Maximum Availability" (Reading, UK)
- Free Webinar : Gathering Knowledge Assets Demands More than Keyword Search!
- Full import is not really "full"
- fully qualified hostname required...
- Function much slower than same statement.
- GD&R
- generic connectivity ms-sql
- getConnection() fails (Tyrex & Oracle 8.1.7)
- getting java internal version using SQL query
- getting XMLType via JDBC
- Ghost index prevents DROP USER CASCADE
- Global naming for workstation, but not the server?
- HASH JOIN ...I want to understand
- help
- Help executing trigger
- Help in granting privileges to a role and assiging this role to a user
- Help me to tune my sql
- Help with AQ Performance Problems
- Help with Oracle SDOAPI
- Help: How can I find the error in a Procedure programtically
- hi....
- High Version count in V$SQLAREA
- Hot to copy tables from one oracle user to another
- How best to move oracle9 db and binaries between similiar unix servers?
- How can I find the error in a Procedure programtically
- How can I start a client Application from a procedure?
- How can I tell if my SGA fits into the physical memory?
- How cancel query through JDBC?
- how do I rewrite this query optimized
- how does oracle apply rollback?
- How does Oracle Fast Refresh on Materizlied View for Joined Tables?
- How many records in a table can run good ?
- How many rollback segments can a transaction use?
- how to change the character set of existing DB?
- How to connect to Oracle Management Server (OMS)?
- How to Create RBS Tablespace as system tablespace ?
- How to create table by store procedure in Oracle9i
- How to create tables referenced each other
- how to dump and comprehend a rollback block
- How to get the oracle 9i client software
- How to handle temporary tablespace (locally managed) during restoration from a hot backup?
- How to insert a space after each Manager Starts.
- How to insert data using index unusable/rebuild
- How to locate the password file?
- How to programatically/dynamically update tnsnames.ora
- how to query between 2 remote databases
- How to recover a dropped table ?
- How to schedule interval events monitoring in OEM, in terms of second?
- How to select Dell based mighty server for Oracle 9i EE for Win XP?
- how to sort numbers in varchar2
- how to validate incoming pl/sql arguments for type/size?
- How-To install Oracle9i on Linux
- Howto do undo a default clause?
- HOWTO specify an interval of 1 month - 1 day ?
- HTTP Server Error
- HTTP Service auto stopping constantly
- hung up Oracle 9.2 install plsql/lib
- ignore previous posting - pluhease
- import database question
- import of LONG columns
- Import question
- Inconsistent SELECT results
- Increasing shared pool in v7.3.4 hpux 10.20
- Incremental indexing in Oracle Text
- Index organized partitioned table can't be rebuilt
- Index organized partitioned table can't be rebuilt (For experts)
- Index question
- Index unusable rebuild
- Info on RS6000
- Informatica Powercenter Number Datatype Default - It Overrides Declaration in Oracle
- Insert queries don't work!!!
- Inserting a binary file into a Long Raw column
- inserting output of xmlagg into CLOB column
- Install Oracle 8i for HP-UX PA-RISC on HP-UX Itanium?
- Install Oracle8i on Redhat 8 Problem
- install oracle9i error message: cannot execute binary file
- installation hangs
- Installation problem of Oracle 9iAS Infrastructure
- instance not started with oracle 9i and solaris 9
- Interesting speculative stuff
- Intermedia
- Intermedia Text in 8.1.7.4
- Intermittent Commits
- Interpreting AUTOEXTENSION increment in DBA_DATA_FILES and altering it.
- Is 1 x 3ghz cpu or 2 x 1.5ghz cpu system better for Oracle 9IR2 Database
- Is there something equivalent to Unix "uniq" in Oracle?
- Is this a valid use of Fine Grained Access Control (row level security)?
- Issue identifying unused indexes in Oracle 9i
- It takes all kinds...
- JDBC driver OracleStatement.creationState()
- jdbc-odbc thread problem in Oracle 9 with Apache ?
- Kill oracle session on Win2000
- Killing Queries
- killing queries - possible?
- Large Index organized tables: just a marketing feature ?! (for ex perts)
- Large Index organized tables: just a marketing feature ?! (for experts)
- Latest Study Guides for Oracle 8i 9i OCP OCA exam
- Lawson on Oracle upgrade?
- ld error relinking oracle 7.3.4 on Sun 2.5
- Licensing Query
- Linux
- linux-oracle-hyper threading
- Listener fault
- Listing all Stored Procedure in database
- load balancing on a multi-processorsysstem
- LoadJava et java stored proc
- Loadjava hangs in RedHat Linux (URGENT)
- Log switch after 3-second timout: what is it about ?
- Log writter excessive memory usage.
- looking for database journals/papers
- Lost Oracle connectivity
- Major dissapointment
- many inserts into a table
- match columns on insert sub select
- Maximum Hash Partitions 8i
- Maximum size a tablespace can grow to
- memory and oracle 9i database
- Merge rows ro remove nullvalues?
- Metalink down
- Migrate 200 Million of rows
- Minimalistic approach to Oracle on Windows
- Minimum requirements for ODBC connectivity to Oracle database
- mismatch in number of indexes in Oracle Emterprise Manager and User_Indexes Table
- Missing Component
- Monitoring question
- More allegations that RAC maybe involved in the Orbitz outage
- Moving tables/objects to a more recent version of Oracle
- MULTI_COLUMN_DATASTORE issue
- mutating table error - trigger order
- My database is too fast
- My first large table
- Mysteriously dropped connection and deciphering the trace
- Need help understanding a performance problem
- Need help writing SQL Query
- need help writing sql query...
- Need SQL Server Temp Table equivalent (challenge!)
- New in Oracle Forms
- newbie - copying from test to production
- newbie DBA - rollback segments
- Newbie help for Oracle client installation on Linux
- Newbie on SQL
- Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report
- Newbie! Need code to insert data, Oracle9ir2
- nextexent issue
- No shared memory segment for the instance
- Notification of replication error
- Number of the week TO_CHAR(DATE,'YYYY/WW')
- numbering a column according to group
- Numeric characters after alphabetic characters sorting varchar2 fields
- Object lock identification
- object naming conventions
- Object privilege at row level?
- OCI JDBC Driver - Runtime UnsatisfiedLinkError
- OCI: How to insert BLOBs with array interface?
- OCIAttrGet column names after OCIStmtExecute
- OEM for Oracle Applications 11.5.7
- OID: using the oidadmin console
- ORA - 01555 rollback segment too old
- ORA - 1401: inserted value too large for columm
- Ora 01034 -: Oracle Not Available
- ORA 1719 outer join operator (+) not allowed in operand of OR or IN
- ora 600 on linux after failed user level import
- ORA-00600 with large dataset and .net OracleClient
- ORA-00600: internal error code
- ORA-01026 multiple buffers of size > 4000 in the bind list
- ORA-01034: ORACLE not available
- ORA-01427: single-row subquery returns more than one row
- ORA-01438: value larger than specified precision allows for this column
- ORA-01450: maximum key length (3118) exceeded
- ORA-03113/7445When Accessing V$SHARED_POOL_RESERVED
- ORA-07217 error in sqlplus
- ORA-12560: TNS: Protocol Adapter Error
- ORA-12712: new character set must be a superset of old character set
- Ora-17401
- ORA-27101: shared memory realm does not exist
- ORA-27143: OS system call failure
- ORA-27146 on init.ora PROCESSES
- ORA-28660 : IOT's partition can't be moved online
- ORA-28660: Index organized partitioned table
- ORA_01001: invalid cursor Error on a CLONE Database
- Oracle 7.x client to 9i-Server
- Oracle 8.0.6 - How to reset (zero) SCN ?
- Oracle 8.1.7 on Mandrake 9.1 install problems
- Oracle 8i and AIX 5 compatibility issue
- Oracle 8i Installation Problem : Throw when ip cannot be determind
- Oracle 8i performance problem since Migration
- Oracle 8i with Forms 6i and Firewall
- Oracle 9.2.0.3
- Oracle 9i (9.2.0.1.0) statistics gathering
- Oracle 9i - 32 vs 64 bit
- oracle 9i AS and J2ME
- Oracle 9i Internet: Unable to run pre-configured database
- oracle 9i memory problem
- Oracle 9i R2 OLAP Time Dimension
- Oracle 9i rel.2 and IAS rel.2
- Oracle 9i STATSPACK Question
- Oracle 9iAS
- Oracle 9iAS + Redhat 9.0
- Oracle 9iAS infrastructure installation problem
- Oracle BAckup Failed. Urgent Please
- Oracle Books for Sale
- oracle create index
- Oracle Data Guard - Any Opinions?
- Oracle Database Corrupted during SAN switch firmware upgrade
- oracle developer 6i print white page
- oracle install
- Oracle Install Matrix
- Oracle Intelligent Agent Executable
- Oracle Inventory Infomation
- Oracle IRC Channels
- oracle loader
- Oracle newbie
- Oracle OFA, Tablespaces and Redo Logs?
- Oracle on a clustered Linux Distribution
- Oracle on Solaris-Intelx86?
- Oracle on which Linux?
- ORACLE RAC CRASHES ORBITZ
- oracle recovery from hp to windows
- oracle reports on linux
- Oracle Reports: Formula Columns ?
- Oracle RMAN (OmniBack) Backup Encryption
- oracle sqlloader
- oracle text
- oracle thesis
- Oracle Universal Installer -> java.lang.OutOfMemoryError
- Oracle version
- Oracle Webcache cannot execute on HPUX 11.11
- oracle9i and jserver
- Oracle9iAS java edition v9.0.3 installer problem on solaris
- Orbitz blames Oracle for site outage
- Orbitz dumps RAC for better reliability
- Order of fields in a table.
- Order problem
- OS_AUTHENT + LDAP
- OT - 'drop tablespace' produces a file/table lock??
- Packages, tables, inbvoker and definer - wierd problem !
- PAGING IN ORACLE
- Parallel Database Import / Export
- Parallel Database Import / Export?
- partition tables with remote ctas dblink
- passive mode database clustering
- performance of recreate oracle user Vs drop objects
- PGSQL wins Linux Journal Awards...
- Plagiarism
- plsql dynamic sql - weird error in repeated execution where contents differ in each loop
- pMB ¹ï§Ü¤£´º®ð pMB
- Populating ListBox/ComboBox (VB6, Oracle 9i)
- Presentation for Virtual Private Database?
- problem creating database link to self....
- Problem solved: 0RA-04031, memory leak 8.1.6
- Problem with a compless query on Oracle 8i..
- Problem with DBMS_JOB within a stored procedure
- problem with listener on oracle 8.1.7
- Problem with pl/sql script
- Problem with reportserver (IAS 9)
- Problems with TIMESTAMP on Oracle 9i
- Program in v$session
- published paper about indexing?
- published papers?
- qio, async_io and control files
- query with Min function
- Query XML stream and Parsing
- question for daniel morgan
- question regarding xml
- Question toad: Index utilized for xx%
- Quick check...
- RAC Training
- RAC with OCFS on normal Red Hat (not AS)
- RAID Levels
- raw data type question
- raw devices, how to?
- read consistency question
- Real Application Clusters Requirements on Windows 2000 AS
- Real reason for Oracle/Orbitz problem?
- Recording Logon and SQL
- Recreating your control files
- RedHat 7.3 Oracle 9.2
- redhat 7.3 oracle 9.2 import problem
- Refresh fast on commit not working for my MV
- Removing all datafiles doesn't bring down the database
- Removing SID?
- replication issue
- Restoring & recovering in NOARCHIVELOG
- Restoring & recovering in NOARCHIVELOG: Thank you all
- Restricting user access to a database?
- Rewriting sql queries depending on the source ip address
- RMAN duplicate and read-only tablespaces
- Rollback calls in pro c programs: Does it cause Overhead?
- Rollback writes >highwater mark size
- roumors about 8i desupport to come soon ...
- Run report in another's schema
- runInstaller error
- Running dynamically linked CGIs?
- SAN's, snapshots and online backups questions...
- Search for string in all tables in one schema
- Searching in complete DB
- segmentation fault running tkprof
- sending an email from a table trigger (before inserting row)
- sequence
- sequence and OPS
- setting NLS_DATE_FORMAT as OS environment variable
- SHUTDOWMN ABORT PROBLEM WITH 8.1.7.4.2 ON WIN2000
- SHUTDOWN PROBLEM WITH 8.1.7.4.2 ON WIN2K
- simple sql
- Simply viewing data in a database
- Slow Load Performance
- Slow response with packaged varaibles...
- small problem ...
- Soft parse & shared pool fragmentation
- Some questions on truncating a partition in Oracle
- spurious activities...
- SQL and IN
- SQL connundrum. Can it be done?
- sql joints
- sql more intelligent
- sql question
- Sql statement slow in pl/sql but ok outside
- SQLLDR - How to set value based on the infile?
- sqlldr ORA-01461
- standby database
- Standby Server (Data Guard)
- starting single sign-on and directory service
- Statistics for comp.databases.oracle.server - WE 07/06/2003
- Statistics for comp.databases.oracle.server - WE 07/13/2003
- Statistics for comp.databases.oracle.server - WE 07/20/2003
- Statistics for comp.databases.oracle.server - WE 07/27/2003
- Storing GUIDs in Oracle
- Strange problem
- Substr and remove characters from field
- Sure-fire "kill"
- sys and system in 9i
- sysadmin access
- system privilege
- TableSpace / Datafiles resize
- Temporary tables visible to all sessions
- Testing remote procedure
- TNS Protocol adapter error when connecting to a different Windows Domain
- TNS-12500
- TNS-12560:Protocol adapter error from client side only...
- Tnslistener dying with 9.2 on Win XP Pro
- TNSLSNR crashes on Windows
- to anyone who has used log miner
- To OCI developers
- Trace of ORA-01031 Insufficient Priviliges?
- Tracing levels help.
- tracing the sql that an Oracle process is executing?
- tracking changes on a table through ODBC application
- Travel reservation Web site Orbitz crashes
- Trigger creation by one user against another user's table
- Trigger on v$sql catalog table
- triggers, sequence - need advice
- Tru64 5.1 System hangs when creating Oracle data file > 1Gb - any suggestions on cause
- Tuning an in list query on a partitioned table
- Tunning Indexes
- Unexpected end of zlib input stream
- unicode searchstring, index not used.
- uninstall of 8i to re-install fresh
- Unix to Windows DBA translation
- upgrade 8.1.5 to 9i
- Upgrade database to 9i or recreate it?
- Upgrade Steps for 8.1.7.3 to 8.1.7.4 ?
- Upgrade to big SUN box or RAC for data warehouse?
- Upgrading from 11.5.1 to 11.5.8
- Urgent Help Required
- URGENT!!! FRM-40654
- URGENT: Automate an update
- Use of ROWNUM?
- user & password for oracle enterprise manager console
- Userid's/Passwords and Application Development
- using :new / :old values in a trigger (after inserting rows)
- Using Alter session enable parallel dml within a stored procedure
- Using Bind Variables with Cold Fusion and Oracle
- Using Crystal Reports to call an Oracle package?
- Using LDAP for TNSNAMES
- Using RMAN to restore a DB
- Using table pipelined functions to get rows from a table?
- UTL_FILE.put 1024 bytes limitation under Oracle 7
- utlxplan.sql
- VARRAY maximum limit
- Veritas oracle agent and oracle 9.2.0.3
- VERY FUN FREE ADDICTIVE RPG 4891
- VERY FUN FREE ADDICTIVE RPG 7234
- Very much off topic - but it is funny !
- View schema for all user objects
- Viewing an Index
- Views inside views, execution plan & external WHERE clause
- Virus designed to take down an Oracle server?
- virus-check incoming blob
- Visual C++ and Oracle - increase speed and preformance?
- VLDB Redo Log Sizing Suggestions
- VSAM files to Oracle (or other RDMS)
- Waits on library cache latches
- Wan to disable Legato Storage Server
- Wanted:PL/SQL to Disable & Enable Constraints
- What "Oracle sessions" mean?
- What *really* happens at ALTER TBSP END BKP ?
- What application code could cause an ORA-03113 error?
- What if replication time exceeds replication interval?
- What is (+) in where clause
- What is a UDT?
- What is Oracle10G?
- What is the name of the next generaltion Oracle database?
- What is the purpose of the following Oracle accounts?
- What's wrong with SQL Server?
- Where can I get a complete list of all SQL Hints?
- Where is the object (DBLINK) suffix come from?
- Which is the best choice, Oracle8i or Oracle9i for Oracle11i App?
- Who needs the quota to extend a table, user or schema ower?
- Whole database search (solution)
- Why 'Failed to archive' & 'Failed to archive TEST' appear in the alert log file?
- Why a high INSERT activity requires to set a low PCT_USED ?
- Why media recovery necessary after datafile brought offline
- Why Oracle-PeopleSoft is a lose-lose - Ray Lane Interview
- Wierd crash after SQL_TRACE=true
- Windows 2K script
- would nologging work on alter table add primary key ?
- wrong results from "Select count(*) from tbl"
- XSQL servlet & WebSphere
- your experiences to cpu-consumption on multi-cpu-hardware
- Last message date: Fri Aug 01 2003 - 00:47:45 CDT
- Archived on: Sun Jan 09 2005 - 06:25:37 CST
|