By Robert G. Freeman
This booklet offers a superb assessment of the alterations in Oracle 10g. It doesn't drill down into aspect, that's left for different courses, yet is a straightforward start line for a DBA emigrate from prior types of Oracle.The booklet is simple to learn and the diagrams are transparent and upload to the textual content.
Read Online or Download Oracle Database 10g New Features PDF
Best oracle books
Oracle Database 11g New Features
FOREWORD through Tom Kyte Your Must-Have advisor to every little thing New in Oracle Database 11gRealize the complete capability of Oracle Database 11g with aid from the specialists. Written through Robert G. Freeman, and with insightful remark all through from Arup Nanda, this Oracle Press consultant deals complete info at the architectural adjustments, database management improvements, availability and restoration revisions, safeguard improvements, and programming recommendations.
Oracle Database 10g, A Beginner's Guide
Presents starting DBAs and builders with an excellent origin within the database management and programming fundamentals had to embark on an Oracle profession. the point of interest is on Oracle Database 10g, yet you’ll get the basics acceptable to all Oracle database releases.
Pro Oracle Database 12c Administration
Seasoned Oracle Database 12c management is a e-book fascinated about effects. writer Darl Kuhn attracts from a good of expertise over a decade deep to put out real-world suggestions that result in luck as an Oracle Database administrator. He offers transparent factors on how one can practice severe initiatives. He weaves in concept the place helpful with no bogging you down in unneeded aspect.
Oracle Application Express for Mobile Web Applications
Oracle software show is celebrated within the Oracle group as a useful tool for developing internet purposes appropriate for machine browsers. gains have now been additional to open up the realm of cellular shopping, bringing the simplicity and expressiveness of Appliction exhibit to undergo in constructing purposes to run with an almost-native feel and appear on systems akin to iOS, Android, and home windows mobilephone.
- SQL Plus quick reference
- Oracle Distributed Systems
- Oracle Information Integration, Migration, and Consolidation
- Perl for Oracle DBAs
Additional info for Oracle Database 10g New Features
Sample text
What if, instead, we could just flash back our table to the point in time we are interested in. Well, with Oracle Database 10g we can! Now, with the flashback table command, you can flash back an Oracle Database 10g table based on timestamp or database SCN. All flashback table operations must be at the beginning of any transaction, and flashback table operations are not supported for the SYS user. Here is an example: SQL> Commit; SQL> Flashback table emp SQL> flashback table emp to_timestamp('2003-09-30 'YYYY-MM-DD to SCN 220360; to TIMESTAMP 09:00:00', HH:MI:SS'); To be able to flash back a table, the table must have row movement enabled via the alter table enable row movement command (row movement is disabled by default).
This makes the process much more efficient, since only referenced attributes are computed and set. Integration with the Extensible Optimizer helps produce better query plans. Support for anonymous return types for the AnyDataSet table functions. The describe procedure (ODCITableDescribe) now can build and return a transient anonymous type using the AnyType interfaces, such as AnyDataSet. These AnyType interfaces are generic collection types that have APIs available for both PL/SQL and C. New Connect String Format If you are running on a TCP/IP network, you can take advantage of a new connect string format when using Oracle Database 10g Oracle clients such as SQL*Plus.
This chapter discusses several new and enhanced features, including: Oracle Data Pump (previously exp and imp) Bigfile tablespaces Cross-platform transportable tablespaces External table unload Enhanced table functions Enhanced merge functionality Materialized view and query rewrite changes Partitioning new features Oracle Data Pump Oracle Database 10g offers new and improved support for logical extracts of data in the form of Oracle Data Pump. This section introduces several topics related to Oracle Data Pump: 34 35 The Oracle Data Pump architecture The data dictionary views associated with Oracle Data Pump The new interactive mode available with Oracle Data Pump The Oracle Data Pump API Oracle Data Pump Export and Import Oracle Data Pump Architecture Oracle Database 10g introduces the new Data Pump infrastructure.