Newbie Oracle DBA question - Why CREATE ANY VIEW not shown

I am just starting out as Oracle DBA, been on other RDBMS. I finished exp/imp a schema from from another oracle instance. Everything looked good except:

 select dbms_metadata.get_granted_ddl ('SYSTEM_GRANT','XXXX') from dual;

DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','XXXX')

  GRANT SELECT ANY DICTIONARY TO "XXXX"   GRANT CREATE ANY SNAPSHOT TO "XXXX" on my target db, and from the original db, I got:

SQL> select dbms_metadata.get_granted_ddl ('SYSTEM_GRANT','XXXX') from dual;

DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','XXXX')

  GRANT SELECT ANY DICTIONARY TO "XXXX"   GRANT CREATE ANY SNAPSHOT TO "XXXX"   GRANT CREATE ANY VIEW TO "XXXX"   GRANT UNLIMITED TABLESPACE TO "XXXX" Before I started the import (with fromuser=XXXX touser=XXXX) , I granted (from sys as sysdba I think),

  GRANT SELECT ANY DICTIONARY TO "XXXX";   GRANT CREATE ANY SNAPSHOT TO "XXXX";
  GRANT UNLIMITED TABLESPACE TO "XXXX";
  grant select any dictionary to "XXXX";

and was succesfully granted. I didnt run the dbms-get-ddl immediately.

Why "CREATE ANY VIEW" and "UNLIMITED TABLESPACE" not shown up ?

• part 2

  ---

By the way data compared with source looked good after imp. Same counts and everything although I didnt check every user tables. I did get this on the log output of imp:

IMP-00017: following statement failed with ORACLE error 20001:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '30383131';
SREC.MAX"
"VAL := '796E69656C73656E'; SREC.EAVS := 0; SREC.CHVALS := NULL;
SREC.NOVALS"
" :=

DBMS_STATS.NUMARRAY(250369961492205000000000000000000000,63050733528527"


 "5000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1);

IMP-00003: ORACLE error 20001 encountered
ORA-20001: Invalid or inconsistent input values
ORA-06512: at "SYS.DBMS_STATS", line 3425
ORA-06512: at line 1

About to enable constraints...
Import terminated successfully with warnings.

Is it only bad statistics ? nothing to worry about right and I can run compute statistics on the user tables to fix ? The export run did say something about "questionable statistics".

Your answer is most appreciated. --Richard Received on Thu Jul 24 2008 - 19:12:40 CDT