View Full Version : Oracle
- Table partitioning
- Query performing good in 9i but very very slow in 10g
- How to get the data from the first one?
- coding help
- Synchronizing tool
- common table expression (With statement)
- Startup trigger to execute dbms_job.run
- Suddenly cannot connect. Listener problem.
- dilemma regarding function based indexes
- a table may be outer joined to at most one other table in CASE statement
- DELETING COLUMN from a table
- Help required for calling an SP from a scheduled job
- General Question about Oracle 10g
- ORA-07445: exception encountered: core dump FFFFFFFF7E98B7F0]
- sqlplus problem with a procedure
- ORA-01407: cannot update ("MY_TABLE"."BA") to NULL
- ORA-28547 error for the second connection
- Quad-CPU database server running at 100% - any pointers?
- Oracle Grid Control
- Porting data from Oracle8i to XML and from XML to Oracle 10g
- can i imp a dmp file which exp from 9i into 10g ?
- oracle express
- Oracle login
- Oracle 7 on UNIX
- Performance Question
- Custom format number
- Find time offset from GMT using time zone
- Oracle with Unix or Linux
- Oracle 9I, HASH_JOIN_ENABLED
- create a delete script with a quoted literal (was "simple question")
- Import table from Control File
- Parallel Processing in Oracle Using Pragma/DBMS_JOB?
- Any known issues with porting of Pro*c programs during Cross platform migration ?
- Structures inside $ORACLE_HOME/bin
- Auditing a program,also
- Trying to construct code to provide chinese year
- Online replication of tables
- Decode with OR conditions
- data model for event calendar
- How to retrieve all the previous sql statements ?senthil
- column length consistency in tables
- are objects owned by schemas or users in oracle?
- unexplainable auto generated object names
- Import XML-tables in Oracle
- mviews
- imp / exp on oracle 10g XE ( migration )
- Using Cognos 7.0 with Oracle 10.2 on a 64bit PC
- will rman try to backup offline datafile?
- Referencing foriegn table
- Error number -9
- Install Oracle 9i after having Oracle 10g installed
- Stop SQL query in Stored Procedure
- reducing the size
- Translating MS Access queries to Oracle
- SELECT Translate
- Delete old Rman Catalog Info ?
- newbie help with form builder triggers
- ctx-index problem
- Personnel 10Gon Notebook, can I access it from another PC
- 9i, OCCI, passing an array to a PL/SQL procedure
- Max Value in a Select Statement
- How to query Roles and privs assigned to a user
- Problem with privileges
- sqlcx2t ???
- To be or not to be !
- Where can I find documentation for the exp/imp utilities?
- Nested Loop or Hash Join
- Exporting an Oracle7 DB to Microsoft SQL
- Problem with character sets
- Creating event
- Axis in Oracle 9i
- Significant virtual memory paging was detected on the host operating system.
- Spool Pipe Delimiter Does Not Work Sometimes
- Creating A User Using Os Authentication
- exporting oracle tables from unix to windows microsoft access
- removal of blank line from delimited output generated from oracle reports 10
- how do i install oracle ODBC driver
- out of reference error
- 10g OEM Administrator's Guide
- How to execute classes that reside in different user's schema
- SQL Loader question: How to use two WHEN clauses for a single table
- EXplain Plan
- detecting wrapped code
- looking for beta testers for sqlspec
- refreshing materialized view
- replication vs standby in oracle
- shared server
- pl/sql(help me please)
- RMAN Backup to remote disk
- ORA-02291: integrity constraint
- Job Scheduling
- Failue with Installation Oracle Forms Server
- Oracle 9.2.0.1 Install - please help...
- database health overview chart - web page
- synonyms
- pl/sql
- Subquery error on creating Mat. View
- moving tables
- Dbms_mview.explain_rewrite
- Can I insert ignore unique into a table?
- Ask about Oracle XE?
- How to create multi rows from a single row
- Unable to connect to 10g
- Tuning Join Condition in Query
- need to get grants on sequence
- PL/SQL update with inner join
- 9i install takes too long
- using RMAN for recovery
- How to create nested select in PL/SQL
- 10g host login problems
- Define default column values on existing FK
- Pass a table name to a function?
- Record count
- Index problem
- record count
- Oracle and MSSQL
- Function to get the QUARTER of a year
- oracle 9i odbc driver install
- ORA-12053: this is not a valid nested materialized view
- Oracleora92ManagementServer sERVICE ERROR
- Any dictionary view for SProc params, like ALL_TAB_COLUMNS gives info on tables cols?
- Finding the latest records using SQL
- SQLServer features in Oracle?
- Oracle Certified Associate (OCA)
- Finding which responsibility a request set is assigned to.
- Oracle Streams 'ORA-25215: user_data type and queue type do not match'
- oracle.jdbc.driver.OracleDriver not found
- V$session is accessed from schema but from procedure not
- How to create a flat file?
- Problem in integration shell script with HP-omniback
- Oracle XE ubuntu sqlplus help
- hardware for running oracle
- New to Oracle: running string as query
- SQL exec time
- how to set ORACLE_HOME
- Oracle 10g on HP-UX 11.0??
- Updation problem in forms 6.0a
- ORA-12054 when creating materialized view
- ORA-00911: invalid character when using X-path in XSQL
- email validation
- Etl
- Message from Oracle to .Net
- DB versioning, change management
- Table Reorganization
- Date Format
- encryption of data in a field
- Downgrading from 10g to 9i
- numeric funtion in oracle.
- Omp?
- Temporary Tablespace
- Time of Restoration of Database Dump
- Tables Mirroring
- After Update Trigger Question
- Er can you incorporate "BREAK ON" in an SQL statement?
- export/import
- Daylight Savings
- convert columns to rows (was "Urgen Question")
- how many managers are there? how many jobs? (was "query help")
- procedure,trigger,cursor problem in oracle 10 G Express Edition
- Installation Problem
- About Installation
- out of temp space
- Oracle & Vista
- Small lookup tables
- Finding the charecters query
- Subquery join using concatenation
- Forms not starting!
- attaining user quota via data dict or V$ views
- Pls help me with this query...
- Stored Procs & Ref Cursors
- count(*) vs count(column)
- Dummy Data
- OLAP time dimension
- How to selectively load records that i need?
- Temporary table in package.
- functio concat help
- Want to return an Outer join row
- Case function
- Date funtion query
- How to avoid errors or ignore errors during LOAD DATA INFILE / sqlldr
- Large_pool_size
- Configuring Oracle to authenticate users with Active Directory
- Getting started
- How to File distribution?
- TO_DATE with DY parameter in SELECT
- Oracle Doc is Now Google-Friendly
- PLSQL Stored Procedures Vs PLSQL functions?
- How to Queue a LOB with Advanced Queueing
- Single row subquery returns multiple rows
- Please help me.....PLSQL procedure
- 'DIGITS' function in Oracle
- Bulk Collect
- * create a database with the charset called “SF8ISO8859P1”
- Please could someone help me with this case statement
- needs help in designing a very simple database
- expdp help
- Is_dba
- Download Oracle 8.1.x for Solaris (SPARC)
- expdp
- GZIP flat file after creating it using utl_file in a procedure in a package
- access to public synonyms(SYSDBA & SYSOPER)
- sqlloader
- Brain dump for certification
- Temprary table in procedure
- Oracle DB Connection and spool data in text file
- Partitioning in Oracle
- where is a field used
- sequencial jobs
- Trigger Check?
- trigger
- focus on item
- transaction throughput
- Oracle and Excel dates
- require help to solve jre11.ins error
- Oracle availabilty
- space problem
- SQL Crosstab query
- numbet to string
- Fetching TABLE_NAME
- ORDER SIBLINGS BY not working properly with BULK COLLECT
- TABLE function
- ORA-12154: TNS could not resolve the connect identifier
- OCA Certification
- Oracle 10g how to run Enterprise Manager Console?
- Database general optimizations
- Report 6i to 9i
- read xmlelement with oraoledb
- Pro*C dynamic sql, ORA-22806 error on PREPARE
- Oracle & .NET
- Delete the 10 last records(lines)
- How to use CPU_TIME in v$SQL
- Relocating Oracle DB
- dump file
- OCIDescribeAny with Database Alias
- remedial variable question
- Help with Relationship
- Oracle 10g
- OLAP in 10g
- To avoid aborting of transaction, on failure of trigger in Oracle
- Help on button Trigger for Query
- JSP or PHP for connecting to Oracle
- reports builder
- Problem with newline character
- Enough of ORA-12640. Please help.
- Questions re: Oracle 8i Standby Server
- How to mount another database.
- Newbie need help on tables
- Newbie having problems with concat
- data dictionary views using datalink
- Concatenating multiple rows to a single string.
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.