- #ORACLE 10G SUPPORT END DATE UPGRADE#
- #ORACLE 10G SUPPORT END DATE CODE#
The issue is only with Linux and with that line mentioned above. Set_application_property(BUILTIN_DATE_FORMAT,v_date_format) įorms_ddl('ALTER_SESSION SET NLS_DATE_FORMAT = '''||v_date_format||'''') Tool_env.getvar('NLS_DATE_FORMAT',v_date_format) -> If this line is commented, no errors are seen
#ORACLE 10G SUPPORT END DATE CODE#
Information in this document applies to any platform.įRM-93652 after upgrading from 10g to 12c -only when using following code in a Program Unit is being called: Oracle Forms - Version 12.2.1.4.0 and later
#ORACLE 10G SUPPORT END DATE UPGRADE#
Function based indexes - NLS, case insensitive, descending, based on user defined function, etc.FRM-93652 with TOOL_ENV and NLS_DATE_FORMAT After Upgrade To 12c Form 10g Forms. Progress Monitor to track long running DML, DDL. DBMS_DEBUG PL/SQL package, DBMS_SQL replaced by new EXECUTE IMMEDIATE statement. Locally managed tablespaces - automatic sizing of extents, elimination of tablespace fragmentation, tablespace information managed in tablespace (i.e moved from data dictionary) improving tablespace reliability. 
Transportable tablespaces, copy tablespaces with datafiles between databases. Net8 support for SSL, HTTP, HOP protocols. 
Temporary tables supported (Tables that will be truncated at the end of a transaction or session). Enterprise Manager v2 delivered - completely rewritten in Java. Read Only queries on standby database allowed. Standby Database - Auto shipping and application of redo logs. Copy optimizer statistics across databases to ensure same access paths across different environments. New partitioning features: merge partitions into one, updatable partition keys (allow movement of rows between partitions), can use LOBS in partitioned tables. Hash partitioning and Composite partitioning. Resource Management using priorities - resource classes. Integrated Object Request Broker for standard CORBA communications between applications and the database. JSQL: a specification for Java-based SQL database statements. Integrated support for EJB (Enterprise JavaBeans). Integrated JavaVM (called Aurora) in the database kernel allowing one to execute Java stored procedures. 
User Security Improvements - more centralisation, single enterprise user, users/roles across multiple databases. Advanced Queueing improvements (security, performance, OO4O support. OPS Cache Fusion introduced avoiding disk I/O during cross-node communication. Log Miner introduced - Allows on-line or archived redo logs to be viewed via SQL. Reorganize indexes/index only tables which users accessing data - Online index rebuilds. Fast Start recovery - Checkpoint rate auto-adjusted to meet roll forward criteria. CURSOR_SHARING parameter - optimize SHARED POOL for applications that do not use bind variables. New SQL*Plus command line options: sqlplus -MARKUP and -RESTRICT. New CASE statement in SQL similar to the Decode() function. JServer Accelerator (Native Java compiler for each platform), Java programs can run as machine code, not interpreted as with 8.1.5. New PL/SQL encrypt/decrypt package introduced. Checksums always ON for SYSTEM tablespace allowing many possible corruptions to be fixed before writing to disk (DB_BLOCK_CHECKING). 
ALTER FREELISTS command (previously done by DROP/CREATE TABLE).Many new SQL analytical functions like lag, lead and rank.Statspack - used for performance monitoring (much better that UTLBSTAT/UTLESTAT).New Database Character Set Migration utility included.Enterprise Manager Enhancements - including new HTML based reporting and Advanced Replication functionality included.PLSQL Gateway introduced for deploying PL/SQL based solutions on the Web.OIS - Oracle Integration Server introduced.MemStat - A new utility for analyzing Java Memory footprints.JVM Accelerator to improve performance of Java code.The following new features were introduced with Oracle 8i: Error Correction Support (ECS): 31-DEC- 2003.
0 kommentar(er)
