关于元数据采集管理的数据库方案

create user metadata
  identified by password
  default tablespace USERASPACE
  temporary tablespace USERTEMP;
Grant connect,resource to metadata;
Grant create session to metadata;
Grant select any table to metadata;
Grant execute any procedure to metadata;

select  * from all_objects;
select  * from all_tables;
select  * from all_cons_columns;
select  * from all_tab_comments;
select  * from all_col_comments;
select  * from all_tab_columns;
select  * from all_source;
select  * from all_constraints;
select  * from user_objects;
select  * from user_source;

create user metadata
  identified by password
  default tablespace USERASPACE
  temporary tablespace USERTEMP;