Posted on | In | Visitors

Oracle提供了命令行工具导出（exp）和导入（imp），可以仅导出或导入数据结构（包含表、视图、sequence、索引等数据库对象）或数据结构和数据一起，可以按用户导入导入，也可以仅导出导入特定表。命令的详细参数可以通过exp help=y或imp help=y查看。

Read more »

Posted on | In | Visitors

user for DDL

1
2
3
4
5
6
7
8
9
10
11
12
13
-- Create the user
create user UMDB_DEV identified by "UMDB_DEV_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to UMDB_DEV;
grant resource to UMDB_DEV;
-- Grant/Revoke system privileges
grant create any sequence to UMDB_DEV;
grant create any table to UMDB_DEV;
grant create any view to UMDB_DEV;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to UMDB_DEV;

user for DML

1
2
3
4
5
6
7
8
9
10
-- Create the user
create user umdb_dev_dml identified by "umdb_dev_dml_2014"
  default tablespace DATSPACE
  temporary tablespace TEMP;
-- Grant/Revoke role privileges
grant connect to umdb_dev_dml;
-- Grant/Revoke system privileges
grant create any synonym to umdb_dev_dml;
-- Grant/Revoke tablespace privileges
grant unlimited tablespace to umdb_dev_dml;
Read more »