oracle迁移至gaussdb,GaussDB T 导入Oracle兼容系统视图

把软件包DIALECT-SCRIPT-GaussDB_100_1.0.1.tar.gz上传到GausDB服务器并置于/opt/software/gaussdb/目录下.

以root身份登陆服务器,执行如下命令.

cd /opt/software/gaussdb/

tar -xvzf DIALECT-SCRIPT-GaussDB_100_1.0.1.tar.gz

chown omn:dbgrp /opt/software/gaussdb/DIALECT-SCRIPT-GaussDB_100_1.0.1/

chown omn:dbgrp /opt/software/gaussdb/DIALECT-SCRIPT-GaussDB_100_1.0.1/ora-dialect.sql

转用omn用户并执行如下命令:

su - omn

zsql sys/Changeme_123@127.0.0.1:1888 as sysdba -q

@/opt/software/gaussdb/DIALECT-SCRIPT-GaussDB_100_1.0.1/ora-dialect.sql

其中Changeme_123为GausDB T默认的口令,需要结合实际情况改成当前有效的sys用户口令.

zsql登陆数据库后执行如下语句:

SQL> select name,dbid,status,open_status,database_role from v$database;

NAME DBID STATUS OPEN_STATUS DATABASE_ROLE

GAUSS 1419523799 OPEN READ WRITE PRIMARY