Non Schema Object 的取得

Non Schema Object就是数据库在移行的时候，下面的对象是不包含在dmp文件里面的。需要用sql取出然后登录到新的库里。

＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊

connect system/manager@pxs11
show user
select instance_name from v$instance;

SET ECHO OFF
SET COLSEP ','
SET LINESIZE 8000
SET TRIMSPOOL ON
SET HEADING ON
SET UNDERLINE '-'
SET NEWPAGE NONE
SET FEED OFF
SPOOL &1 REPLACE
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（インスタンス）' from dual;
select '#   v$instance' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from v$instance;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（データベース）' from dual;
select '#   v$database' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from v$database;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（バージョン）' from dual;
select '#   v$version' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from v$version order by banner;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（データベースオプション）' from dual;
select '#   v$option' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from v$option order by parameter;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（SGA）' from dual;
select '#   v$sga' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from v$sga order by name;
SET PAGESIZE 0
select '##################################################' from dual;
select '# 初期化パラメータ' from dual;
select '#   v$system_parameter' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select name,value from v$system_parameter order by name;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（NLS）' from dual;
select '#   nls_instance_parameters' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from nls_instance_parameters order by parameter;
SET PAGESIZE 0
select '##################################################' from dual;
select '# DB作成パラメータ（オプティマイザ）' from dual;
select '#   v$sys_optimizer_env' from dual;
select '##################################################' from dual;
SET PAGESIZE 1000
select * from V$sys_optimizer_env;
exit