Home : Bytes IT Community / View Full Version : Oracle
- control file heartbeat
- Need help on oracle 8i db
- UTL_FILE and Network path
- vs.net pro*c insert failed
- NEED HELP and GUIDANCE!
- TOra
- TOra - Error ORA-12705
- Some SQL Help Please
- Execution Consistency
- Fluctuating Cost with Range Scan
- Can't connect to oracle & java error
- Range Scan Cost Fluctuations
- GetString equivalent
- ORA-12560: TNS:protocol adapter error
- ORACLE Import and DISK SPACE OCCUPYING
- If exists in PL/sql
- ORACLE DBA/ CONTRACT/ IMMEDIATE
- compare many values from two tables
- escaping those darn ' in a package/procedure
- replicating a database
- Start With Connect by usage without Prior keyword
- Sorting on NUMBER or DATE
- 9.2.0.4 Linux x86-64 version OEM tools missing
- LONGs with Oracle ODBC vs MS ODBC - Strange Translations
- Rollback and Commit
- Fine Grained Acces Control & cursor
- value of last identity inserted
- Last Identity added
- Timestamps and computing aggregate time.
- Unindexed foreign keys and full table scans
- How can a 'non-owner' grant access to a table.
- creating a trigger on v$session.module
- tablespace SYSTEM used by others user, not sys. Help!
- Problem installing 10g on a laptop with DHCP
- snapshot / materialized view with column types
- Scheduling Snapshot Refreshes
- Timeout on SQL calls when using the Oracle Provider for OLEDB
- How to return a record set from a PL/SQL procedure/function?
- problem calling Stored Procedure from Access
- ORACLE Import and DISK SPACE OCCUPYING
- FGAC and EMP_BASE_TABLE
- ora-01847 when updating a record...please help
- Newbie PL/SQL Question - Inserting into a table from a stored procedure
- Variable inside a variable
- 10GAS on Linux with 10GDS on Windows XP.
- Re: Multi Threaded server not working for many inserts?
- I am using Oracle 9.2.0.4 on IBM AIX 5.1 L System. Our DB Server had IP of "100.101.102.103" and our Tomcat Application Server (IP of 200.201.202.203) used to talk to above DB onn Port 1521. The system was working great for 6 months or so.
- Why ORACLE doesn't do it?
- creating a reports servlet - error 50125
- Oracle 9iAS Administrator Position Open with Major HealthcareCompany in Atlanta, GA
- Oracle 9iAS Administrator Position Open with Major HealthcareCompany in Atlanta, GA
- Using pl/sql tables with Object types
- Career as a DBA
- SQL for Modeling Generalization Hierarchies
- Oracle Financials Proj Lead-Kingston, Jamaica-FT, bank
- FRM-10142 HTTP listener is not running question
- Moving to Visual Studio??
- Impact on Oracle8i (when upgrading HP Ux 11.0 to 11i)
- Oracle/ETL Developer - Jamaica/Canada/US-6 mths -leading bank
- Use of 10G Database and App Server
- Oracle Workflow - 6 mths - Jamaica/Canada - Bank
- OMLETv4 The Ultimate Visual Real Time Oracle Monitoring Tool
- Update rows when in other table
- Trigger to delete record from one table with check on another table.
- Any suggestions to improve this query performance
- Grant Problem?
- why RESETLOGS and NORESETLOGS
- Can NOT create Materialized View
- Question on migrating from MSSQL temp tables and remote queries
- Can NOT create Materialized View
- data integrity problem of Oracle 8.1.6 Standby Database
- IOWAIT time
- Newbie Oracle Development Question
- Host credentials?
- Oracle Connection Pooling
- SP call does not work
- Performance problems with remote queries
- top 5 ( or n) salaries in each department
- Looking for some help on a simple command....
- JDBC / Oracle : beware the bind variables ?
- Oracle DB Report Generator - beta testers needed
- storing dbl_min in Oracle 9.2
- Oracle Report Generator - beta testers needed
- How to query a remote database?
- Code for "bucket-ized" time table???
- Query Help
- db defragmentation
- store procedure from dbf file
- Audit log.
- HELP: imp error
- How to start ? client & database.
- Westell Wirespeed B90-220030-04 and Oracle Services
- Oracle Text with Numbers
- 11i Newgroups?
- PL/SQL: Exceptions & Sub-programs...
- MSCOMMLIB * - how to send & receive data via COMM PORT
- oracle 9i on debian
- Oracle Client Install
- Oracle9i: SQL Exam# 1Z0-007 wanted
- Re: 10g
- Oracle install problem
- Oracle DB features that support BI/ warehousing
- user_exit
- External Tables
- Creating a database is slow on Windows XP
- Database Report Generator - beta testers needed
- What Oracle SQL syntax does Oracle have that is not ANSI SQL ?
- finanial application....
- ORA-12224 TNS:no listener
- Read data via COMM port
- Defragmentation of Oracle 91 files on W2000 server
- creating joins between tables with "group by" clause to limit rows
- ORACLE DBA
- Finding Statement that ran on x date?
- How to find out when UTL_FILE. PATH is VALID but the directory doesn't exist
- How to set up LongReadLen and LongTruncOk?
- Need to learn Oracle
- Not Sure Which Analytic To Use
- selecting the differences between 2 large tables
- Determine underlying tables in a view
- Importing Data to DB with Added tables / columns
- ORA-06575: Package or function VALUE_1 is in an invalid state
- Strange parse counter on tkprof
- Strange parse counter on tkprof
- OraOLEDB and Inner Join
- PERL/Oracle opening (San Jose)
- http://%%20 when running Forms from Form Builder
- Query Help
- Runing oracle report in Web
- connection dropped by firewall
- SELECT DISTINCT causes ORA-03113 only on SQLPlus
- Calling VB components from PL/SQL
- Help! How to solve the ORA-03113 end-of-file on communication channel ?
- Generating XML from Oracle 8i datas
- OS username?!
- ALTER TABLE requires extra parentheses for Oracle?
- jdbc failover to standby question
- Windows v Unix Performance on Oracle 9i
- What do you think about this post ?
- copy a DB from PC1 to PC2
- Oracle View Problem
- OO4O usage in a VC++ 6 DLL ?
- Why isn't bitmap index being used in this example
- sqlplus default script directory
- Equals-Operator on RAW Columns
- Executing Multiple Scripts.
- What is use of trim
- Help on Oracle Update statement
- Bin Laden Captured - photos and video
- Client Problems
- Reestablishing a db connection after a network failure
- trying to move from reports generated in CGI mode to reports generated in Servlet mode
- Do I need to create a field type LONG?
- Creating a table with field type long. Initial storage settings?
- Conversion of Location Codes with Foreign Keys
- Uninstalling Oracle Client
- Materlized view Refresh Interval
- Master/detail in dev2000
- PL/SQL Blocks
- Odp.net and Proxy (n-tier) Authentication
- LTM
- 10g
- OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
- New to Oracle
- Create ordinary table out of XML Schema
- index statistics
- XML acceleration
- Oracle, loading a java .jar file with loadjava
- SQL to aggregate values into LIST
- Problems with Micorosft Update KB835732
- Proposing a new newsgroup
- not single- group group function
- SQL standards editor discusses SQL:2003, XQuery and APIs
- Please point us on installing Oracle 9.2 on FreeBSD
- ORA-00947: WHY!?!?!?
- Missing ora_control1 ???
- Handle count leak when connecting to Oracle via ODBC on Windows
- Hyper-threading on RH AS2.1 with 9i (Standard)
- batch loading clobs
- batch loading clobs
- oracle and SQL3
- Certification on 9i .
- 9i's runInstaller - is their a commandline or windowless version?
- Discovery of node failing ..plz help!!
- utl_file issue
- Oracle 9i Installation
- LONG RAW AND #TABLESPACE
- Function used in where clause - executed too many times
- Merge two cursors data (select from a cursor?)
- what does '1' in 'Case.. when' do
- condtional display of a page in Oracle Reports
- oracle9i on which linux distribution in production? feedback needed plz
- 9i on RedHat 9?
- Dumb story short- need to recreate foreign keys in oracle db
- procedure for numering records - no effect
- Oracle client for DOS
- Oracle Reports and Oracle installation Q's
- conditional selection of 'AND'
- Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
- count(*)
- test (please ignore)
- Oracle & WinXP Pro
- NEWBIE looking for DBA documentation
- Grid Controls in Oracle Forms 6i and Up
- Oracle inactive connections
- sqlplus "Input is too long (>2499 char)" error
- US.ORACLE.COM domain name suffix for default templates
- solution
- data base link
- Database links and US.ORACLE.COM
- Inconsistent behaviour creating java stored objects using sqlplus in Oracle 8i
- Select for Update fails
- Oracle JDeveloper 10g Goes Production
- data base link
- Multi-User Password Database (Password Storage)
- b-tree
- oracle on windows cluster
- Running a query manually when using web modules
- Privilege problem with creation
- explicitly closing cursors
- MERGE on spatial indexed tables
- dynamic tablename with %rowtype
- Development Client
- Running Oracle Trace
- JDEVELOPER/ CONTRACT/ IMMEDIATE
- to check if a table exists
- Connection Oracle - Sybase
- Convert Qualify Rank from Teradata to DB2
- Re: Securing the database from the DBA
- locking sga
- create table in a procedure
- create table in a procedure
- Does anyone know of a good location for a data set?
- user interaction in pl/sql
- ORA-00911 in Dynamic SQL
- Rollback problem
- Please help !! Oracle 9i crashes on Windows XP SP1 without reason
- Printing a File From PL/SQL In Oracle 9i
- What is the problem my standby database step?
- How to avoid duplicates here...?
- jump 2 next iteration of FOR loop
- jump 2 next iteration of FOR loop
- Converting SQL Server to Oracle
- Rollback usage query
- how to Spool results from SQL plus
- row lock contention
- Can MERGE replace UPDATE/INSERT duo on a single table?
- Which software can capture all screen shots and composit them into a demo?
- Re: Oracle Problem 1: Please Help
- Re: Oracle Problem 1: Please Help
- Oracle Problem 1: Please Help
- Oracle Gurus - Global Employment site just for Oracle
- Missing Parenthese Error: ORA-00907
- Re: Temp table in Procedure
- Mandrake Oracle 9i Installation Problems (netmgr, netca)
- Problem with DB Propagate Assistent, (can't copy table data)
- Returning Variant data from Java to PL/SQL & SQL?
- Re: XSQL:insert-request
- Marrying SQL, XML, web services, grid computing (2 audio programs)
- Re: memory statistics
- cost based optimization
- Re: bind variables with jdbc
- What's your compensation for carrying a pager???
- Create New Oracle Database in AIX box
- Rule Based Optimization
- Re: Recursive tree structure in Oracle
- Re: bind variables with jdbc
- ora04021:timeout occurred while waiting to lock object ...
- Re: Securing the database from the DBA
- Re: Estimate in Reduction of Index Size by Reorganization?
- Migrating db2 to Oracle 9i
- Setting Null values to Zero
- Help...
- Inserting an Oracle Instance into Clustered Oracle
- Bitand Question
- Custom Response File
- RAC and load-balancing a connection pool
- examining views
- Data in Text file thru Stored procedure
- How to know wich Oracle Client release is used ?
- Creating foreign keys across different tablespace
- Using reserved word "MODE" in select queries
- datablock sizing
- Re:Killing an user from the user
- Unable to revoke privileges from a user
- Next 33
- Business Intelligence - Oracle Financials 11.5.9
- is there any future to learn Oracle?
- how many tablespaces
- JAVA OCI Driver in 9.2.0.4
- BI tool users - message for u
- v$sqlarea in Oracle 9i
- A Couple of Questions on Views
- Char array not long enough: javaCharsToUtf8Bytes
- sql to find a numeric range inside another range?
- does sqlplus support :"select top 10 * from table1" syntax like MS SQL?
- Limit to number of items in a List [WHERE id IN (,,,,)]
- Help to optimize procedure (concatenation of rows)
- What is the bottom line on Oracle layout on Virtual Arrays?
- iSQL*Plus bug with substitution variable?! (9.2.0.1.0)
- using sdo_geometry
- March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
- OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
- remove character...
- insert in a string... plsql
- Where does jdbc2_0-stdext.jar come from?
- Where Clause on Nested Selects
- Statistics for comp.databases.oracle.server - WE 02/29/2004
- problem installing oracle9i on windows2003
- Need help acquiring a database PLEASE!
- Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql
- vc++ error while compiling pro*c precompiled code
- Finding first saturday of month
- stored proc returning array
- MERGE bug?
- silent install oracle 9ias
- ORA-01458 invalid length inside variable character string
- Oracle 9i Qs: URL contains extra characters and how to maximize servelet
- world atlas database
- java.lang.ArrayIndexOutOfBoundsException when i want connect me to Oracle 9i
- Oracle OCI, COM+, dblinks and Multi Threaded Server????
- Control Characters in column
- Scheduling Jobs with the OEM (Windows, 8i)
- rollup not working
- Memory leak
- Oracle 9i cannot display bfile image properly
- Sqlloader: All database in one single plain text file
- data handling issue
- OCI Tutorial needed
- Sometimes ORA-24388 problem - please advice
- ORA-24388 problem *Sometimes* - please advice
- Package compilation error
- newbie? SQL question
- Advanced replication: Setting timeout for insert transactions
- RPC_FAILED
- Mutating tables
- ORA-12571, ORA-03114 and other connection errors.
- Looking for a file
- Can I concatenate varchar2 and long datatypes together?
- sql file
- process serial number: serial# in v$process
- Calculating SUM and COUNT in one statement
- "EXEC SQL DESCRIBE SELECT LIST" returns "Specified partition does not exist"
- A design question
- under-transaction ?
- Replace LOV with Dropdown
- Oracle reports v 6 (&crm ebusiness)--sql query, of using decode
- ASP programmer looking for Oracle 9i book to get started
- tkprof output
- Installing Oracle 9 in WinXP
- Oracle 9 - tablespace default storage
- SQLPLUS command line question
- Simple SQL to display text
- using case, Valid statement?
- ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement
- Error in calling external procedure
- Views and Stored Procedures
- column name can't include character '-'
- CLOB.createTemporary throws ClassCastException - fyi
- union of tnsnames.ora
- Problem with some SQL queries
- append a table onto the end of another
- How to protect a PL/SQL proc / func from running more than oneinstance simultaenously
- scheduling a PL/SQL proc / function
- Oracle ODBC Driver
- Mutating table error
- Informix to Oracle 9i Migration No Suitable Driver error
- Traling spaces in result?
- Does Oracle Form allow Multi-thread processing ?
- Access violation in JREW.EXE while installing Oracle 8i
- Oracle patches
- VB Oracle stored procedure problem
- Io exception: The Network Adapter could not establish the connection
- Java Stored Procedures
- Basic PL/SQL script needed
- Pls save me
- Connecticut Oracle Users Group in Hartford, CT -- Meeting with Rich Niemiec from TUSC Scheuled for Thursday March 18
- ora-00600 [12700] on SYS.EXU8REF
- test this group
- Oracle locking up..?
- How to fill empty column with number sequence?
- Re: trigger puzzlement
- trigger puzzlement
- Improper result when number table is used to substitute the "IN" clause in oracle
- oracle on ultra5
- Oracle 9i
- How to test for a null value in a date column
- DBA - Oracle, Sybase, Sql Server, Informix, DB2 Jobs @ www.cvpages.com
- automatic refresh of materialized view does not work
- SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question
- Problem trying to update a record with a value returned by a function
- Efficient data model to represent range
- Protocol Violation when user password is expired
- nt.stp(905) error while installing Ora. Designer 6i
- extract numeric part from address
- Oracle Apache Session
- Agent Configuration Assistant Failed during install
- Oracle ODBC 3151 Eroor
- What is max doing across fields in a de-duplication ?
- PL/SQL trigger fires once a day
- Oracle Rman Replication
- PL/SQL question
- Nested blocks in PL/SQL
- Oracle Concepts Question
- Need to compile and execute plsql files from remote machine
- HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist
- Object Relational Feature
- tricky SQL question!
- no performance when creating or extending a tablespace
- Loading from a column
- Analytical Functions Question
- count # of unioned values
- Strange TNSNAMES.ORA problem
- Storing oracle procedures on server from inside.
- Suppressing newline during a SELECT returning multiple rows
- A Query about GRANT ALL PRIVILEGES in ORACLE
- Transactional haywire...
- Jobs Not Populating Materialized Views
- need help with net8!
- Running batch under OWF
- How can I make this trigger?
- where are the rman scripts?
- Problems installing oracle on Win2000
- snapshot
- Help
- updating all tables with a column column
- I needhelp
- Bloody OCP braindump groups - close them down!
- View for prime numbers
- Any progammers looking for a killer app to develop? How about a voice enabled forum?
- Oracle Connector for Outlook XP/2002 & HTML mail
- How can create case-insensitive database in oracle?
- SQL*Plus and Shell Programming
- Help with OCI oracle 8.1.7 compilation
- FWD: Watch this package from the M$
- Re: Passing multi values into an in clause via a parameter in a store procedure
- Passing multi values into an in clause via a parameter in a store procedure
- Oracle Java Stored Procedures Hand
- No answer for your problem ?
- Oracle Licence
- designer2000
- Handle count leak when connecting to Oracle via ODBC on Windows
- need aid with this query
- install Oracle9i on Redhat 9
- Installation problem help me plz...
- unethical spam to get certifications without studying
- Index creation too long
- -- advatage BLOB or file on file system --
- Need help with SQL Query
- Help with ORA-01830 error.
- Inserting multiple rows in sqlplus
- enqueue statspack top5 timed events
- Pass unix variable to sqlplus
- Trigger based replication
- Very strange IO problems
- iFS or Lobs + InterMEdia
- $9.95 Online Tax Filing www.MHBSgloabl.com
- Reports error in 9iAS R2
- Renaming an Oracle Server
- Oracle Client conflicts between versions
- stats pack ?/interpretation
- Migrating questions
- Install web based Oracle Discoverer
- query results slow from db
- Foreign key refer to unique constraint????
- Universal Installer 9i
- Test
- DBCA and RAW devices
- Connecting from Windows
- Oracle designer container problem, please help
- Oracle and OpenSource
- warehousebuilder deployment manager error
- How to create trigger for all user ?
- How to display Text after loggin on database
- High performance replication ?
- With grant option vs with admin option
- Oracle Warehouse Builder.........
- Final CFV: comp.databases.oracle Periodic FAQ Post
- Oracle RAC on Linux...
- view puzzle
- Where do I get JDK 1.3 that Oracle Lite 5.0.2 wants?
- how to create query ??????????
- killed session
- use of escape character in sql
- Reuse Connect dialog box on forms 6i run time to connect to another database
- SQL Commands to interact with Windows Files in 9iR2
- Oracle 9IR2 OLAP and BI Beans - How to get it working
- PL/SQL Compile Problem
- SQL question
- Help: need avg(timestamp1 - timestamp2), get type error
- I found the answer
- Open cursors
- Cannot read from sys.v_$session
- Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux
- Oracle DB Type List
- A SQL Question
- Oracle vs. MS SQL Server
- upgrade 8.1.6 clients to 8.17
- Oracle Client software for HPUX 10.20
- restrict user's view
- copy a role
- what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
- assotiating SQL text from the V$%SQL% views with sessions
- EMC SAN and refreshing snapshots
- oracle database for academic
- Urgent Query
- Perf. degradation due to TIMESTAMP WITH TZ
- How to prevent modifying oracle data through MS access or VC++ sql screen.
- Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
- Help requested..Missing Protocols Oracle 9i.
- URGENT ---------> SQLLDR ERROR
- what is SQL*Net
- Power Objects
- Format sqltext from v$sqltext
- Executing SQL via MDAC ODBC multiple statements?
- PL/SQL package gets invalidated seemingly at random
- Know whether oracle is installed or not
- meaning of TNS (Transparent Network Substrate)
- user authorazation
- check who delete the role
- Wot, me worried?
- How to sign up
- A simple newbie question with select
- Run SQL Script under SYS for other Schema
- help Jobs not running on OEM console
- INSERT Through Pro*C in UTF 8 DB
- SQL to retrieve min value of the combination
- libobk source code?
- regarding oracle 9i installation
- oracle listener
- oracle Performance decrease when number of connections increase
- DBCA fails on Windows ME
- Password question
- Regarding ORacle 9i installation
- Analyzing queries
- newby question
- basic PL/SQL questions
- HELP: create user
- ORA03113: end-of-file on communication channel
- Adding Index to Table may reduce performance of Some Select Statements ?
- Loader and dbf files
- PLS-00201 and ORA-00942 when creating a package
- Query from the Aggregated Query with different projection
- How can I check the Users who are online ?
- TNS:protocol adapter error
- TNS:protocol adapter error
- Check out this critical package for Microsoft Internet Explorer
- Watch this patch from the M$
- Information Needed Regarding Oracle Forms 6i
- TAF without RAC or OPS