drdb2
作者drdb2·2012-05-23 11:06
系统工程师·se

create an oracle-compatible DB2 sample database

字数 14659阅读 2132评论 0赞 0
Just installed DB2 version 10.
Practice creating an oracle-compatible database:

$db2set DB2_COMPATIBILITY_VECTOR=ora
$db2stop force
05/22/2012 21:44:21     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
$db2start
05/22/2012 21:44:33     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
$db2sampl -name osample
  Creating database "osample"...
  Connecting to database "osample"...
  Creating tables and data in schema "DB2ADMIN"...
  Creating tables with XML columns and XML data in schema "DB2ADMIN"...
  'db2sampl' processing complete.

$db2 +o connect to osample
$db2 -x "select 1 from dual"
          1
$db2 list tables for SYSTEM | grep DBA_
DBA_ALL_TABLES                  SYSIBMADM       V     2012-05-22-22.00.47.959006
DBA_ARGUMENTS                   SYSIBMADM       V     2012-05-22-22.00.44.054001
DBA_CATALOG                     SYSIBMADM       V     2012-05-22-22.00.44.391002
DBA_COL_COMMENTS                SYSIBMADM       V     2012-05-22-22.00.44.659001
DBA_CONSTRAINTS                 SYSIBMADM       V     2012-05-22-22.00.44.929001
DBA_CONS_COLUMNS                SYSIBMADM       V     2012-05-22-22.00.44.778008
DBA_DEPENDENCIES                SYSIBMADM       V     2012-05-22-22.00.45.054001
DBA_ERRORS                      SYSIBMADM       V     2012-05-22-22.00.45.272005
DBA_INDEXES                     SYSIBMADM       V     2012-05-22-22.00.45.625001
DBA_IND_COLUMNS                 SYSIBMADM       V     2012-05-22-22.00.45.423001
DBA_IND_PARTITIONS              SYSIBMADM       V     2012-05-22-22.00.45.515001
DBA_OBJECTS                     SYSIBMADM       V     2012-05-22-22.00.45.707002
DBA_PART_INDEXES                SYSIBMADM       V     2012-05-22-22.00.45.807001
DBA_PART_KEY_COLUMNS            SYSIBMADM       V     2012-05-22-22.00.45.940006
DBA_PART_TABLES                 SYSIBMADM       V     2012-05-22-22.00.46.007004
DBA_PROCEDURES                  SYSIBMADM       V     2012-05-22-22.00.46.091005
DBA_ROLES                       SYSIBMADM       V     2012-05-22-22.00.48.646006
DBA_ROLE_PRIVS                  SYSIBMADM       V     2012-05-22-22.00.46.224005
DBA_SEQUENCES                   SYSIBMADM       V     2012-05-22-22.00.46.299008
DBA_SOURCE                      SYSIBMADM       V     2012-05-22-22.00.46.475001
DBA_SYNONYMS                    SYSIBMADM       V     2012-05-22-22.00.46.592000
DBA_SYS_PRIVS                   SYSIBMADM       V     2012-05-22-22.00.46.750004
DBA_TABLES                      SYSIBMADM       V     2012-05-22-22.00.47.910004
DBA_TABLESPACES                 SYSIBMADM       V     2012-05-22-22.00.48.236001
DBA_TAB_COLUMNS                 SYSIBMADM       V     2012-05-22-22.00.47.159003
DBA_TAB_COL_STATISTICS          SYSIBMADM       V     2012-05-22-22.00.46.934001
DBA_TAB_COMMENTS                SYSIBMADM       V     2012-05-22-22.00.47.301006
DBA_TAB_PARTITIONS              SYSIBMADM       V     2012-05-22-22.00.47.401006
DBA_TAB_PRIVS                   SYSIBMADM       V     2012-05-22-22.00.47.526002
DBA_TRIGGERS                    SYSIBMADM       V     2012-05-22-22.00.48.571004
DBA_VIEWS                       SYSIBMADM       V     2012-05-22-22.00.48.479008
DBA_VIEW_COLUMNS                SYSIBMADM       V     2012-05-22-22.00.48.327001
DBA_ALL_TABLES                  SYSPUBLIC       A     2012-05-22-22.00.47.992003
DBA_ARGUMENTS                   SYSPUBLIC       A     2012-05-22-22.00.44.128000
DBA_CATALOG                     SYSPUBLIC       A     2012-05-22-22.00.44.444003
DBA_COL_COMMENTS                SYSPUBLIC       A     2012-05-22-22.00.44.678003
DBA_CONSTRAINTS                 SYSPUBLIC       A     2012-05-22-22.00.44.970003
DBA_CONS_COLUMNS                SYSPUBLIC       A     2012-05-22-22.00.44.870001
DBA_DEPENDENCIES                SYSPUBLIC       A     2012-05-22-22.00.45.111003
DBA_ERRORS                      SYSPUBLIC       A     2012-05-22-22.00.45.339003
DBA_INDEXES                     SYSPUBLIC       A     2012-05-22-22.00.45.648000
DBA_IND_COLUMNS                 SYSPUBLIC       A     2012-05-22-22.00.45.455003
DBA_IND_PARTITIONS              SYSPUBLIC       A     2012-05-22-22.00.45.539003
DBA_OBJECTS                     SYSPUBLIC       A     2012-05-22-22.00.45.739003
DBA_PART_INDEXES                SYSPUBLIC       A     2012-05-22-22.00.45.831003
DBA_PART_KEY_COLUMNS            SYSPUBLIC       A     2012-05-22-22.00.45.964003
DBA_PART_TABLES                 SYSPUBLIC       A     2012-05-22-22.00.46.042003
DBA_PROCEDURES                  SYSPUBLIC       A     2012-05-22-22.00.46.131003
DBA_ROLES                       SYSPUBLIC       A     2012-05-22-22.00.48.671001
DBA_ROLE_PRIVS                  SYSPUBLIC       A     2012-05-22-22.00.46.233002
DBA_SEQUENCES                   SYSPUBLIC       A     2012-05-22-22.00.46.358002
DBA_SOURCE                      SYSPUBLIC       A     2012-05-22-22.00.46.508003
DBA_SYNONYMS                    SYSPUBLIC       A     2012-05-22-22.00.46.632003
DBA_SYS_PRIVS                   SYSPUBLIC       A     2012-05-22-22.00.46.783003
DBA_TABLES                      SYSPUBLIC       A     2012-05-22-22.00.47.959003
DBA_TABLESPACES                 SYSPUBLIC       A     2012-05-22-22.00.48.284003
DBA_TAB_COLUMNS                 SYSPUBLIC       A     2012-05-22-22.00.47.199003
DBA_TAB_COL_STATISTICS          SYSPUBLIC       A     2012-05-22-22.00.46.975003
DBA_TAB_COMMENTS                SYSPUBLIC       A     2012-05-22-22.00.47.350000
DBA_TAB_PARTITIONS              SYSPUBLIC       A     2012-05-22-22.00.47.442003
DBA_TAB_PRIVS                   SYSPUBLIC       A     2012-05-22-22.00.47.583003
DBA_TRIGGERS                    SYSPUBLIC       A     2012-05-22-22.00.48.592003
DBA_VIEWS                       SYSPUBLIC       A     2012-05-22-22.00.48.515003
DBA_VIEW_COLUMNS                SYSPUBLIC       A     2012-05-22-22.00.48.368002

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关资料

X社区推广