自己手動創建一個測試的表空間名字為testSQLcreatetablespacetestdatafile/u01/app/oracle/oradata/orcl/test01.dbfsize10M;Tablespacecreat..

自己手動創建一個測試的表空間名字為test

如何查看oracle表空間的創建時間呢？

查看下數據庫當前的時間

通過以上查詢可以看出，test1表空間是我剛剛創建的，美國服務器，可數據庫也是剛才安裝上的，雖然默認的表空間如system表空間等，應該創建時間也都是今天，但是為什么都是2005年06月30日？

如何查看數據庫版本呢？

可以看出我的數據庫版本是Oracle 10g，10.2.0.1.0版本，那么這些會與表空間的時間有什么關系呢？

查看一下Oracle各個版本的發行時間和版本特性簡介的英文資料不難看出:Oracle 10g Release 2 (10.2.0)正式發布時間是2005年09月，而我的數據庫是10.2.0.1.0版本，表空間的創建時間是2005年8月15日，服務器空間，也就是Oracle發布10gR2版本的日期之前，應該是產品生產包裝完后再正式發布銷售的！不然發布了有人買，沒東西賣哈~原來默認表空間的創建時間是這樣來的。我在Oracle11gR2上測試也是這樣，大家不妨可以試試哦~

以下是Oracle各個版本的發行時間和版本特性簡介：

1979年的夏季，RSI（Oracle公司的前身，Relational Software，Inc）發布了Oracle第二版。

1983年3月，RSI發布了Oracle第三版。從現在起Oracle產品有了一個關鍵的特性--可移植性。

1984年10月，Oracle（RSI更名為Oracle）發布了第4版產品。這一版增加了讀一致性這個重要特性。

1985年，Oracle發布了5.0版。這個版本是Oracle數據庫較為穩定的版本。并實現了C/S模式工作。

1986年，Oracle發布了5.1版。該版本開始支持分布式查詢。

1988年，Oracle發布了第6版。該版本中引入了行級鎖特性，同時還引入了聯機熱備份功能。

1992年6月，虛擬主機，Oracle發布了第7版。該版本增加了包括分布式事務處理功能、用于應用程序開發的新工具及安全性方法等功能。

1997年6月，Oracle第8版發布。Oracle8支持面向對象的開發及新的多媒體應用。

1998年9月，Oracle公司正式發布Oracle 8i。正是因為該版本對Internet的支持，所以，在版本號之后，添加了標識i。

2001年6月，Oracle發布了Oracle 9i。

2003年9月，Oracle發布了Oracle 10g。這一版的最大特性就是加入了網格計算的功能，因此版本號之后的標識使用了字母g，代表Grid--網格。

2007年7月11日，Oracle發布了Oracle 11g。Oracle 11g實現了信息生命周期管（Information Lifecycle Management）等多項創新。

英文介紹:
Oracle 2 - 1979
First public release
Basic SQL functionality, queries and joins
CONNECT BY queries
Written in pdp-11 assembly language, ran on vax/vms in compatibility mode

Oracle 3 - 1981
Atomic execution of SQL statements and transactions (COMMIT and ROLLBACK of transactions)
Nonblocking queries (no more read locks)
Re-written in the C-programming language

Oracle 4 - 1984
Read consistency
First interoperability between PC and database server
Database ported to several platforms

Oracle 5.1 - 1986
Distributed queries

Oracle 5.0 - 1985
Supporting for the Client-Server model - PC's can access the DB on remote host

Oracle 6.2
Oracle Parallel Server Option (later renamed to Real Application Clusters)

Oracle 6.1
There was never an Oracle 6.1 production release. However, a 6.1 version was made available to selected beta customers running on clustered hardware. Apparently the database was so busy checking block status's between the machines that it killed the systems it ran on.

Oracle 6 - July 1988
OLTP performance enhancements
Row-level locking
On-line database backups (alter tablespace begin/end backup)
New Procedural Option (TPO) - PL/SQL in the database (*)
B*Tree indexes implemented
Rollback Segments introduced
Concept of tablespaces introduced
(*) Functions, Procedures, Packages and Triggers were not available until Oracle 7.

Oracle 7.3 - February 1996
Partitioned Views
Bitmapped Indexes
Asynchronous read ahead for table scans
Standby Database
Deferred transaction recovery on instance startup
Updatable Join Views (with restrictions)
SQL*DBA no longer shipped.
Index rebuilds
db_verify utility introduced
Context Option
Spatial Data Option
Tablespaces changes - Coalesce, Temporary/ Permanent,
Trigger compilation, debug
Unlimited extents on STORAGE clause.
Some init.ora parameters modifiable - TIMED_STATISTICS
Hash Joins, Antijoins
Histograms
Dependencies
Oracle Trace
Advanced Replication Object Groups
PL/SQL - UTL_FILE

Oracle 7.2 - May 1995
Resizable, autoextend data files
Shrink Rollback Segments manually
Create table, index UNRECOVERABLE
Subquery in FROM clause (Inline view)
PL/SQL wrapper
PL/SQL Cursor variables
Checksums - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM
Parallel Create Table As (CTAS)
Job Queues - DBMS_JOB
DBMS_SPACE and DBMS_APPLICATION_INFO packages
Sorting Improvements - SORT_DIRECT_WRITES

Oracle 7.1 - May 1994
ANSI/ISO SQL92 Entry Level
Oracle Advanced Replication - Symmetric Data replication
Snapshot Refresh Groups
Parallel Recovery
Dynamic SQL - DBMS_SQL
Parallel Query Options - query, index creation, data loading
Server Manager introduced
Read Only tablespaces

Oracle 7.0 - June 1992
Database Integrity Constraints (primary keys, foreign keys, check constraints, default values)
Stored procedures and functions, procedure packages
Database Triggers
View compilation
User defined SQL functions
Role based security
Multiple Redo members - mirrored online redo log files
Resource Limits - Profiles
Much enhanced Auditing
Enhanced Distributed database functionality: INSERTS, UPDATES, DELETES, 2PC
Incomplete database recovery (e.g. SCN based recovery)
Cost Based Optimizer
TRUNCATE tables
Datatype changes (i.e VARCHAR2, CHAR, VARCHAR)
SQL*Net v2, MTS
Checkpoint process (CKPT)
Data replication - Snapshots

Oracle 8 - 1997
Object Relational database (ORDBMS) features
Object types (not just date, character, number as in v7)
SQL3 standard
Call external procedures
LOB >1 per table
Partitioned Tables and Indexes (new partitioning option)
partitions in multiple tablespaces
export/import individual partitions
Online/offline, backup/recover individual partitions
merge/balance partitions
Advanced Queuing for message handling
Many performance improvements to SQL/PLSQL/OCI making more efficient use of CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes VARCHAR2)
Parallel DML statements (UPDATE and DELETE)
Connection Pooling (uses the physical connection for idle users and transparently re-establishes the connection when needed) to support more concurrent users.
Improved "STAR" Query optimizer
Integrated Distributed Lock Manager in Oracle PS (as opposed to Operating system DLM in v7).
Performance improvements in OPS - global V$ views introduced across all instances, transparent failover to a new node
Data Cartridges introduced on database (e.g. image, video, context, time, spatial)
Backup/Recovery improvements - Tablespace point in time recovery, incremental backups, parallel backup/recovery. Recovery manager introduced (see RMAN)
Security Server introduced for central user administration. User password expiry, password profiles, allow custom password scheme. Privileged database links (no need for password to be stored)
Fast Refresh for complex snapshots, parallel replication, PL/SQL replication code moved in to Oracle kernel. Replication manager introduced.
Index Organized tables (IOTs)
Deferred integrity constraint checking (deferred until end of transaction instead of end of statement).
SQL*Net replaced by Net8
Reverse Key indexes
Any VIEW updateable (INSTEAD OF triggers on views)
New ROWID format

Oracle 8i (8.1.7) - August 2000
Static HTTP server included (Apache)
JVM Accelerator to improve performance of Java code
Java Server Pages (JSP) engine
MemStat - A new utility for analyzing Java Memory footprints
OIS - Oracle Integration Server introduced.
PLSQL Gateway introduced for deploying PL/SQL based solutions on the Web
Enterprise Manager Enhancements - including new HTML based reporting and Advanced Replication functionality included.
New Database Character Set Migration utility included.

Oracle 8i (8.1.6) - November 1999
PL/SQL Server Pages (PSP's)
DBA Studio Introduced
Statspack - used for performance monitoring (much better that UTLBSTAT/UTLESTAT)
Many new SQL analytical functions like lag, lead and rank
ALTER FREELISTS command (previously done by DROP/CREATE TABLE)
Checksums always ON for SYSTEM tablespace allowing many possible corruptions to be fixed before writing to disk (DB_BLOCK_CHECKING).
XML Parser for Java
New PL/SQL encrypt/decrypt package introduced
JServer Accelerator (Native Java compiler for each platform), Java programs can run as machine code, not interpreted as with 8.1.5
Native support for Java2
New CASE statement in SQL similar to the Decode() function
New SQL*Plus command line options: sqlplus -MARKUP [HTML...] and -RESTRICT
User and Schemas separated
CURSOR_SHARING parameter - optimize SHARED POOL for applications that do not use bind variables
Numerous Performance Enhancements

Oracle 8i (8.1.5) - February 1999
Fast Start recovery - Checkpoint rate auto-adjusted to meet roll forward criteria
Reorganize indexes/index only tables which users accessing data - Online index rebuilds
Log Miner introduced - Allows on-line or archived redo logs to be viewed via SQL
OPS Cache Fusion introduced avoiding disk I/O during cross-node communication
Advanced Queueing improvements (security, performance, OO4O support
User Security Improvements - more centralisation, single enterprise user, users/roles across multiple databases.
Virtual Private Database (VPD)
Integrated JavaVM (called Aurora) in the database kernel allowing one to execute Java stored procedures
Integrated support for EJB (Enterprise JavaBeans)
JSQL: a specification for Java-based SQL database statements
Integrated Object Request Broker for standard CORBA communications between applications and the database
Oracle iFS (Internet File System)
Resource Management using priorities - resource classes
Hash partitioning and Composite partitioning
New partitioning features: merge partitions into one, updatable partition keys (allow movement of rows between partitions), can use LOBS in partitioned tables
Single table hash clusters
SQL*Loader direct load API
Copy optimizer statistics across databases to ensure same access paths across different environments.
Standby Database - Auto shipping and application of redo logs. Read Only queries on standby database allowed.
Enterprise Manager v2 delivered - completely rewritten in Java
NLS - Euro Symbol supported
Analyze tables in parallel.
Temporary tables supported (Tables that will be truncated at the end of a transaction or session).
Net8 support for SSL, HTTP, HOP protocols
Transportable tablespaces, copy tablespaces with datafiles between databases
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
Drop column on table (finally!!!!!)
DBMS_DEBUG PL/SQL package, DBMS_SQL replaced by new EXECUTE IMMEDIATE statement
Progress Monitor to track long running DML, DDL
Function based indexes - NLS, case insensitive, descending, based on user defined function, etc.
Index key compression: duplicate keys are combined to save space

Oracle 9i Release 2 (9.2.0) - May 2002
Locally Managed SYSTEM tablespaces
Oracle Streams - new data sharing/replication feature (can potentially replace Oracle Advance Replication and Standby Databases)
XML DB (Oracle is now a standards compliant XML database)
Data segment compression (compress keys in tables - only when loading data)
Cluster file system for Windows and Linux (raw devices are no longer required).
Create logical standby databases with Data Guard
Java JDK 1.3 used inside the database (JVM)
Oracle Data Guard Enhancements (SQL Apply mode - logical copy of primary database, automatic failover
Security Improvements - Default Install Accounts locked, VPD on synonyms, AES, Migrate Users to Directory

Oracle 9i Release 1 (9.0.1) - June 2001
Traditional Rollback Segments (RBS) are still available, but can be replaced with automated System Managed Undo (SMU). Using SMU, Oracle will create it's own "Rollback Segments" and size them automatically without any DBA involvement.
Flashback query (dbms_flashback.enable) - one can query data as it looked at some point in the past. This feature will allow users to correct wrongly committed transactions without contacting the DBA to do a database restore.
Use Oracle Ultra Search for searching databases, file systems, etc. The UltraSearch crawler fetch data and hand it to Oracle Text to be indexed.
Oracle Nameserver is still available, but deprecate in favour of LDAP Naming (using the Oracle Internet Directory Server). A nameserver proxy is provided for backwards compatibility as pre-8i client cannot resolve names from an LDAP server.
Oracle Parallel Server's (OPS) scalability was improved - now called Real Application Clusters (RAC). Full Cache Fusion implemented. Any application can scale in a database cluster. Applications doesn't need to be cluster aware anymore.
The Oracle Standby DB feature renamed to Oracle Data Guard. New Logical Standby databases replay SQL on standby site allowing the database to be used for normal read write operations. The Data Guard Broker allows single step fail-over when disaster strikes.
Scrolling cursor support. Oracle9i allows fetching backwards in a result set.
Dynamic Memory Management - Buffer Pools and shared pool can be resized on-the-fly. This eliminates the need to restart the database each time parameter changes were made.
On-line table and index reorganization.
VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster.
Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ.
Cost Based Optimizer now also consider memory and CPU, not only disk access cost as before.
PL/SQL programs can be natively compiled to binaries.
Deep data protection - fine grained security and auditing. Put security on DB level. SQL access do not mean unrestricted access.
Resumable backups and statements - suspend statement instead of rolling back immediately.
List partitioning - partitioning on a list of values.
ETL (eXtract, transformation, load) Operations - with external tables and pipelining.
Oracle OLAP - Express functionality included in the DB.
Data Mining - Oracle Darwin's features included in the DB.

Oracle 10g Release 1 (10.1.0) - January 2004
Grid computing - an extension of the clustering feature (Real Application Clusters)
Manageability improvements (self-tuning features)
Performance and scalability improvements
Automated Storage Management (ASM)
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Flashback operations available on row, transaction, table or database level
Ability to UNDROP a table using a recycle bin
Ability to rename tablespaces
Ability to transport tablespaces across machine types (E.g Windows to Unix)
New 'drop database' statement
New database scheduler - DBMS_SCHEDULER
DBMS_FILE_TRANSFER Package
Support for bigfile tablespaces that are up to 8 Exabytes in size
Datapump - faster data movement with expdp and impdp
SYSAUX tablespace has been introduced
NID utility has been introduced to change the database name and/or id.

Oracle 10g Release 2 (10.2.0) - September 2005
Transparent Data Encryption
Async COMMITs
The CONNECT ROLE can now only connect (CREATE privs removed)
Passwords for DB Links are encrypted
New asmcmd utility for managing ASM storage
Support for regular expressions in SQL and PL/SQL

Oracle 11g - September 2009
New options: Oracle RAC One Node, solution for consolidating less mission critical databases on the grid with most of the redundancy and availability provided by RAC. An Omotion utility is provided to migrate One Node instances to other nodes in the cluster without any downtime to the application.
New features:
Some of the new features include:
Improved data compression ratios (up to 20x).
Ability to upgrade database applications while users remain online.
New ease-of-use features that make Grid computing more accessible.
Automation of key systems management activities.

希望大家留言提出自己的見解，共同討論，謝謝！

本文出自 “老徐的私房菜” 博客，謝絕轉載！

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com