ORACLE数据库用户的备份:
UPDATE USER$ SET NAME='DATABASE_BAK' WHERE NAME='DATABASE';
commit;
ALTER SYSTEM CHECKPOINT;
//将ORACLE中用户DATABASE更新为DATABASE_BAK;
alter user DATABASE_BAK identified by database_bak ;
//跟新DATABASE_BAK用户的密码为:database_bak
drop schema database_1 cascade;
//删除database_1库
alter schema database_1 rename to database_1_bak;
//重命名(备份用)database_1库为 database_1_bak
vertica导入:登陆到一台服务器01环境上,将数据从01上面导入到02服务器环境上
CONNECT TO VERTICA data USER dbadmin PASSWORD 'data' ON '192.168.1.1',5433;
export TO VERTICA data.database_1.table1 FROM database_1_bak.table1;
UPDATE USER$ SET NAME='DATABASE_BAK' WHERE NAME='DATABASE';
commit;
ALTER SYSTEM CHECKPOINT;
//将ORACLE中用户DATABASE更新为DATABASE_BAK;
alter user DATABASE_BAK identified by database_bak ;
//跟新DATABASE_BAK用户的密码为:database_bak
oracle导入:数据从一台服务器上导入到另一台服务器环境上:
可以先建立dblink连接,如:
-- Create database link
create database link date_101
connect to dbname
using 'ORCL_101';
然后再通过编写的 Procedures脚本运行,达到数据导入的目的。
drop schema database_1 cascade;
//删除database_1库
alter schema database_1 rename to database_1_bak;
//重命名(备份用)database_1库为 database_1_bak
vertica导入:登陆到一台服务器01环境上,将数据从01上面导入到02服务器环境上
CONNECT TO VERTICA data USER dbadmin PASSWORD 'data' ON '192.168.1.1',5433;
export TO VERTICA data.database_1.table1 FROM database_1_bak.table1;