- "RETURNING...BULK COLLECT" - code check
- "Sub Routine" Functionality Within Oracle
- - NEEDS_COMPILE Problem
- - refresh problem
- 10g / CBO stat problems
- 10G Grid Control Email Alerts
- 10g recyclebin with 9i SQL*Plus clients
- 23,000 Tables?
- 8i hash update parallel query
- 9i serially_reusable packages; 'call to the server is done'
- [MATERILZED VIEW] - NEEDS_COMPILE Problem
- [MV] - refresh problem
- [OCI] [ORA-00600] stored procedures with index-by table parameters
- [ORA-00600] stored procedures with index-by table parameters
- A query to return row counts of all tables in cat
- Access and Filter
- Access based on IP Address and Username
- adding column to table
- Advanced Oracle SQL Book ? (was: Reading column into a string variable)
- Advice on Date Range Partitioned Table
- After Update Trigger
- AIX ASM and raw disk...big hassle....need help
- AIX RAC and ASM....
- alter table X move tablespace Y. what happens if error?
- ANTs, Ouch!
- Any ideas if oracle development is reading and following up on Mr. Lewis's new book
- ASM -- Is it Mirrored Stripes or Striped Mirrors
- ASM and 4-way replication?
- Auditing Stored Procedures
- Best setup, given the resources....
- BLOB Storage Issue
- Block Header Size Confusion
- Bottleneck?, Insert and select on the same table.....
- BULK bound inserts are very slow
- Calling function from select statement is slower then using subselect in select
- calling java jar file from within a trigger
- Can't start Oracle 10g on FC4
- Cannot change pctused
- Cartesian join: What is this BUFFER SORT accomplishing?
- changing service name
- Checkpoint duration
- Clearing out grid controller/agent
- Column length question.
- Competition for OraPerf
- Compilation error in old code migration
- Composite index is not used for concatnated Date & Time fields?
- Compuware ServerVantage?
- concatenating with oracle output
- Concurrent/Parallel Execution
- conditional cursor that will start fetching data from where it stopped in last execution
- connect by: last row duplicated
- Conversion from 8i Manual Undo Management to 10g Automatic Undo Management
- Converting many rows to single row.
- Copy data from one database instance to another on the same server
- couldn't drop a rollback segment
- Create object in other schemas?
- Creating schema in oracle10g express edition
- Database Link::ORA-12154: TNS:could not resolve........
- datapump, expdp, is very slow
- db file sequential read, where does it read to?
- DB_FILE_MULTIBLOCK_READ_COUNT
- DBMS_JOB.SUBMIT ?
- DBMS_SCHEDULER external jobs failing but status of SUCCEEDED?!?!
- dbms_stats - GATHER AUTO option - ORA-00933 ?
- deadlock problem
- decimal formatting in file output
- Decode equivalent within pl/sql?
- default column value in view while inserting.
- DELAY not working with Queues??
- Delete of mirrored rows
- Design question : Nullable FK & FK To Unique Key
- Designer 6i Sequence generation problem
- detecting chained rows and other stats stuff
- Different explain plans for a query on SQL Plus and PL/SQL
- Distributing TNS with NIS
- Do 'sort key too long' error depends on values supplied to query?
- Does anyone know about Package Initialization Blocks?
- Does NOT automatically cause a full table scan? 9.2.0.5
- Drop a table via synonym
- Drop constraints CASCADE not working on 10g Express
- Efficient query for this year/last year/two years ago
- em use by 10.g
- Enough of doing just a JOB - Openings @ Ampere
- Error 45 Initializing SQL * PLUS
- Error in xml functions
- Exception in In-Line Function
- Export/Import oracle 10g db to another machine
- extracting minutes from interval in user_jobs
- Failed Install Question
- FAL_server performance when recovering
- finding default connection type....
- Flashback User
- Free Gmail with yourname@oraclelinux.org address
- Free Linux to run Oracle
- Freezing database statistics
- Function to remove spaces/carriage returns from text
- GATHER_SCHEMA_STATS always gathers histograms..!
- Gathering Statistics / preventing timeouts
- Get all schemas
- Get Data from SqlServer via HTTP
- Get Left characters from a field
- getting RMAN to mark and delete obsolete
- Give user index grants Oracle 8/9i
- Grid Control email notification peculiarities
- Grid control users
- Group Multiple Jobs in Oracle Scheduler
- Hard disk configuration for fast write (Insert)
- Help Dumping a Block
- Help required - running 2 instances with the same name on a single server
- help with ora-3313 ora-3114....
- Help with understanding why shutdown "hangs" ...
- Help!! Even stranger query...
- Help: How do I group them together
- High RBS usage during INSERT operation.
- how bad are these vulnerabilities?
- How can I delete one of two instances?
- How can I prevent ORA-01779 Error:cannot modify a column which maps to a non-key-preserved table
- How can I run many scripts under a path with SQL*PLUS?
- how do I call a package through a dblink?
- How to assign values to a table of Record Type
- How to connect with a Java JMS server from Oracle ?
- How to find International Characters in a column?
- How to import a text file
- how to install 9i rac on fedora core 4
- how to loop table every 1 second for no more than 4 seconds
- How to Run this PLSQL Block.
- how to use count(*) in "group by" queries
- I don't understand the results of my hierarchical query
- imp.exe crash on windows xp (Oracle ver. 9.2.0.8)
- Import /Export Errors Coredump with fatal error
- import selectively transportable tablespaces
- Impossible to move tempfile
- IN Clause limitations
- Insert BLOB into a BLOB column
- inserting null in XMLType
- Installing 10g using a shell script.....
- insufficient privileges
- interested in wombats
- Intermittent connection problems from web servers to DB server
- is it really true that the new unbreakable linux has an app menu that doesn't work?
- Java stored procedure call error: ORA-06576
- Like Operator with CLOB datatype
- Limitation of Oracle XE
- Linking with Oracle 9i and Oracle 10g
- Listener for dataguard config, how?
- Looking for Teradata Professionals
- Lunching Oracle instance at the starting of the OS
- make love not war?
- Materialized View FAST refreshing
- max_dump_file_size for session
- Maximum Redo Log Groups
- MemoDepot: build YOUR OWN online notes library - anything, anytime, anywhere
- Mig from DMTS to LMTS
- Monthly maintenance
- more efficient sql
- move database to new server/directory
- Moving backups to / from ASM
- multi core processors
- Multi Master Detail form in Oracle Applications
- Multiple triggers on the same event
- Need help
- Need to replicate a table with long column
- newbie oracle functions
- nvl returns strange value
- ocfs2 hearbeat
- OEM blackout
- On AIX, blocksize an DataWarehouses
- open read ony and start a standby
- Operating system backup script
- ORA -12154 error message
- ora 12015 numpty question
- ORA-00001 on non-unique index!
- ora-00354 on standby site on physical database
- ORA-01034: ORACLE not available
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- ORA-12535 Problem
- Oracle 10 + Sun App Server 7: Unique Constraint Violation?!?
- ORACLE 10 G 2 Win32 and WampServer
- Oracle 10g Express client problem
- Oracle 10g on HP blade server
- Oracle 10g on Linux
- Oracle 10g RAC Windows
- Oracle 8.0.6 Database Process Dump
- Oracle 8.0.6 Server Process Dump
- oracle 8i backup to 9i environment
- oracle 8i communicate with oracle 9i
- Oracle 8i Enterprise for Windows - need a copy
- Oracle and Sun T2000 Servers
- Oracle Careers in Scotland
- oracle code to display sum
- ORACLE DESIGNER 10 G 2 TextBook?
- Oracle Discoverer 3.1 won't connect on Windows XP
- Oracle exp imp
- oracle installation on laptop with 232MB RAM
- oracle installation on linux laptop with < 256MB RAM
- Oracle Listener failure
- Oracle Menu - my lifes work and gift to you all, well hours at least
- oracle server mode
- Oracle Suggested Backup
- Oracle Text question
- Oracle version detail
- Oracle Won't use INLIST ITERATOR in simple case
- Oracle's Linux Distro
- Oracle's update statement
- OracleXE is garbage
- OS memory near 100% full
- Outer Join
- Parallel DML and parallel clause in 10g R2
- Partitioned Tables and Storage Clause Question
- Patching Oracle without shutting down the database
- PCCW Solutionx¤»¼Ó - Lawrence Chan (Âq¤H)
- Performance and Security
- Performance Issue
- Performance of Create table vs. Create materialized view ?
- PGA & Open_Cursors
- PL/SQL timing problem
- PL/SQL: dynamically determining parameter names and values
- Privs of RESOURCE role not showing up
- problem export in oracle 10g
- Problem with nested table function parameters
- Problem with Unicode
- problem: insert into remote table (dblink) hangs after migration 8.0.6 to 9.2.0
- Problems with imp
- Procedure hang, session still there
- Proving or Debunking the need for rebuilding
- Query Date by Time
- Query problem (Need workaround)
- query run successfully in sql*plus but return 0 records affected in vb6
- Query takes too long to execute
- Question on Oracle Server 10g Install (.../oracle/oracle/.....
- Question: Book recommendation - Memory usage on UNIX vs Win2K3
- Read-Only Table : DISABLE VALIDATE ?
- Reading column into a string variable
- Rebuild an instance
- Recommended Linux for Installing Oracle E-Business Suite.
- Recompile any PL/SQL object: worry about app, server jdbc cache ??
- recovery issue...
- recovery without restoring backup
- Recruiting Consultants - Allied Solutions Group Inc
- Redo log buffer size
- Refreshing Materialized view
- report server problem
- reqfoo is garbage
- Restrict data acces by period
- Restrict View data access to some users only.
- Return limited rows from a table
- Risky enable star transformations and trusted Query Rewrites?
- RMAN Backup. restore to other machine
- RMAN on AIX
- RMAN Restore
- RMAN-00600 when create standby DB with readonly table spaces
- Securing a Shrink Wrapped application using Oracle XE
- select data from different database
- serializable isolation level behavior question
- Sessionns blocked by library cache lock
- SHAD process
- Shell Script Heros
- Shutdown/Restart ORA-01033 and IO Errors
- SID enumeration help
- Similar De-Install Issue
- sipping lightly or drinking deeply from the ASM koolaid?
- Size of an archive log file for dataguard
- Some Data from SServer to Oracle - Options ?
- some interestings posts after oracle open world
- Sounds good in theory, but will it work?
- spool data into file without the select consult showing?
- SQL - Oracle Error
- sql question - distinct
- sql statements missing in continued tracefile
- SQL Tunning techniques
- SQL: How Many Diff JOBs for each ENAME
- Standby database for standard edition 10GR2 on windows
- start the countdown till the impeachment hearings begin
- Startup problem
- statistics_level parameter --- performance impact
- Steps to apply a one-off patch for bug:4658188 for 9.2.0.7
- Strange query - Oracle Text problems?
- Strange results
- Student question about Oracle backup and recovery
- Sun solaris sparc 10 local harddisks performance
- Survey...Please help and respond!!
- switching tablespaces...
- Table function parameters don't seem to be working
- The 5-minute interval in sys.smon_scn_time table
- The need to 'get around' the 4000 character limit in varchar2
- this insert is not working .....
- Times do not add up in 10046 trace file
- TNS could not resolve the connect identifier
- Tnsnames
- To get delayed data?
- Tom Kyte's book "EO Database Architecture"
- Trace Files and Alert Logs Filling Up Hard Drive
- track user's select statements
- Transfer XML schema to XML document in PL/SQL
- trigger
- Trigger problem ADO to ORACLE 8
- Triggers
- Tuning case studies
- tuning NFS for large backups
- Unindexed FK and DW
- Update Query
- update statment from sybase to oracle
- upgrade 9.2 to 10.2
- upgrade from solaris 8 to solaris 10 with Oracle 9i database
- Urgent requirements for J2EE, .Net, Siebel-CRM, Oracle Apps, SAP ERP, Mainframe, C++, Unix Professional on H1 Transfer in Bay Area.
- Use Inserted Script Values
- Using backup files with new DB
- Using bitmap indexes
- Using REF cursor in method 4 of dynamic SQL
- UTL_FILE and locking
- V$DATABASE column PROTECTION_MODE on Standby db in 10g
- V$SESSION_LONGOPS sofar/totalwork *always* = 1 in 10g ?
- Verify JVM
- Very high 'log file sync' wait time with no 'log file parallel write' wait time
- viewing user sessions from con
- VT-2018 error - what is so important about this intelligent agent?
- What is different b/w exp tablespace and exp user
- What is the best approach to process data on row by row basis ?
- What's the alternative of "MERGE w/ INSERT ALL"?
- what's wrong with the result of the query on v$sql
- When I COMMIT....
- when I uninstall the oracle9i and the reinstall oracle9.2 ,I cant start instance
- When/from which script SERVICE$ is created in 10g ?
- Why does Oracle buffer the result from the select for a parallel INSERT INTO SELECT FROM?
- Why Oracle Enforce Name Uniquness ???!!!
- Windows 2003 x64 connect to Oracle 8
- Yabba dabba dooo!
- Yet Another Partitioned Table Question ... Example Included
- Last message date: Thu Nov 30 2006 - 22:48:53 CST
- Archived on: Mon Nov 03 2008 - 14:21:38 CST
|
