摘要：以Oracle中sottt用户下的数据为例，PPAS 中scott用户下面的数据由Oracle迁移而来 1 查询emp表中的数据 Oracle [root@test03 ~]# su - oracle [oracle@test03 ~]$ sqlplus / as sysdba SQL*Plus: 阅读全文
<<卸甲笔记>>-Oracle线下迁移到PPAS
2016-06-20 12:37 by DataBases, 451 阅读, 0 推荐, 收藏,
摘要：迁移原则 1、尽量保持Oracle与PPAS一致，这会使得日后应用程序迁移更为简单 2、迁移前检查PPAS中是否有同名帐号及同名的Schema a）如果有，建议考虑删除或改名 b）如果没有，先手工建立与Oracle同名的帐号及Schema 3、用MTK迁移时，配置文件中目标数据库建议使用与Oracl 阅读全文
How to use PEM of PPAS
2016-06-15 13:49 by DataBases, 187 阅读, 0 推荐, 收藏,
摘要：-bash-4.1$ pwd/opt/PostgresPlus/9.3AS/client-v4/scripts -bash-4.1$ lsclient launchPEMClient.sh -bash-4.1$ ./launchPEMClient.sh click Connect && enter 阅读全文
PPAS Migration Toolkit document
2016-06-14 14:13 by DataBases, 762 阅读, 0 推荐, 收藏,
摘要：Migration Toolkit Migration Toolkit is a command line utility that imports data or schema objectdefinitions immediately, or generates scripts that can 阅读全文
PostgreSQL中数据库，表，等对象的oid与对象名的对应关系
2016-06-12 14:55 by DataBases, 2482 阅读, 0 推荐, 收藏,
摘要：-bash-4.1$ oid2name Password: All databases: Oid Database Name Tablespace 16394 benchmarksql pg_default 16459 pg_monitor pg_default 13241 postgres pg_ 阅读全文
使用pgstatspack分析PostgreSQL数据库性能
2016-06-12 14:23 by DataBases, 1302 阅读, 0 推荐, 收藏,
摘要：pgstatspack [root@test01 soft]# wget http://pgfoundry.org/frs/download.php/3151/pgstatspack_version_2.3.1.tar.gz --2016-06-12 21:16:11-- http://pgfoun 阅读全文
Postgres Plus Advanced Server installation
2016-06-07 09:05 by DataBases, 1112 阅读, 0 推荐, 收藏,
摘要：# setenforce Permissive # ./ppasmeta-9.3.1.3-linux-x64.run --mode text Installation Directory [/opt/PostgresPlus/9.3AS]: Select the components you wan 阅读全文
Ways to access Oracle Database in PostgreSQL
2016-06-05 19:32 by DataBases, 540 阅读, 0 推荐, 收藏,
摘要：Today, organizations stores information(data) in different database systems. Each database system has a set of applications that run against it. This 阅读全文
Some settings of PostgreSQL
2016-06-05 19:28 by DataBases, 353 阅读, 0 推荐, 收藏,
摘要：Here are some setting recommendations about checkpoints, some values to set in postgresql.conf. A checkpoint consists of a complete flush of dirty buf 阅读全文
WAL
2016-05-30 13:47 by DataBases, 323 阅读, 0 推荐, 收藏,
摘要：WAL record format typedef struct XLogRecord{pg_crc32 xl_crc; /* CRC for this record */XLogRecPtr xl_prev; /* ptr to previous record in log */Transacti 阅读全文
浙公网安备 33010602011771号