Oracle 12c Recover Table New Feature
SQL*Plus: Release 12.1.0.1.0 Production on 星期日 7月 21 16:07:55 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
連線到:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions
建立臨時表空間
CREATE TEMPORARY TABLESPACE scott_temp
TEMPFILE ' D:\APP\ORACLE\ORADATA\ORCL\SCOTT_TEMP.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
建立使用者表空間
CREATE TABLESPACE test
LOGGING
DATAFILE ' D:\APP\ORACLE\ORADATA\ORCL\TEST.DBF '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
建立使用者並制定表空間
CREATE USER SCOTT IDENTIFIED BY TIGER
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE SCOTT_TEMP;
第 1 行出現錯誤:
ORA-65096: 公用使用者名稱或角色名無效
CREATE USER C##SCOTT IDENTIFIED BY TIGER
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE SCOTT_TEMP;
給使用者授予許可權
grant connect,dba to c##scott;
出現ORA-065096錯誤
或者利用在建立12C資料庫的可插入資料庫進行建立
可插入資料庫
alter session set container=pdb2;
SQL> show con_name;
CON_NAME
------------------------------
pdb2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/196700/viewspace-767082/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Database 12C New FeatureOracleDatabase
- 12c new feature
- oracle 12c new feature 列不可見Oracle
- Oracle10g New Feature -- 3.Flashback TableOracle
- 12c RMAN新特性之Recover Table
- Oracle Database 12C 新功能 rman RECOVER TABLE (文件 ID 2047644.1)OracleDatabase
- new feature ——>mysql to oracle MigrationMySqlOracle
- oracle 12c R2 new feature 支援執行過的歷史命令Oracle
- oracle 12c new feature crsctl 停止資源時提供預覽確認功能Oracle
- 【12c】12c RMAN新特性之recover table(表級別恢復)
- [20130817]Oracle 12c new feature In-Database Archiving.txtOracleDatabase
- java new featureJava
- Oracle 12c: Recover tables using RMANOracle
- [20190805]Oracle 12c New Feature – Online Partitioning.txtOracle
- Oracle10g New Feature -- 6. Oracle Data PumpOracle
- oracle truncate table recover(oracle 如何拯救誤操作truncate的表)Oracle
- Oracle10g New Feature -- 8. Tablespace ManagementOracle
- Oracle10g New Feature -- 4. Flashback DatabaseOracleDatabase
- Oracle10g New Feature -- 2.Flashback RecordsOracle
- 版本新特性(new feature)
- Oracle10g New Feature -- 11. Wait InterfaceOracleAI
- Oracle10g New Feature -- 7. Rollback MonitoringOracle
- Oracle10g New Feature -- 5.Temporary Tablespace GroupOracle
- oracle10g new feature -- 1. SqlplusOracleSQL
- Oracle10g New Feature -- 14. OEM ( Oracle Enterprise Manager)Oracle
- oracle 11g ocp new feature 1z0-050Oracle
- Oracle10g New Feature:CRS(Cluster Ready Services) (zt)Oracle
- 11g New Feature: Health monitor
- Oracle10g New Feature -- 9. ASM (Automatic Storage Management)OracleASM
- oracle 12cR2 new feature dbca 命令可以建立standby 庫Oracle
- Does Goldengate Support The New Oracle 10g Flashback Feature? [ID 966212.1]GoOracle 10g
- Oracle10g New Feature -- 13. Automatic Shared Memory ManagementOracle
- Oracle10g New Feature --12. ASSM ( Automatic Segment Space Management )OracleSSM
- Oracle 12c系列(十) | 12c中的Recovering Tables and Table PartitionsOracle
- Oracle10g New Feature -- 10. AWR (Automatic Workload Repository)Oracle
- oracle10g new feature:對expdp並行方式的幾個測試Oracle並行
- oracle 12c 資料歸檔 即Using In-Database Archiving featureOracleDatabase
- oracle recover 原理概括Oracle