Database Backup and Recovery (MOSC)

MOSC Banner

Oracle 12, i do impdp

edited Feb 25, 2016 10:54AM in Database Backup and Recovery (MOSC) 18 commentsAnswered

Hello gurus,

     1 - I am in version 12.1.0.2

          When i do an impdp i have this next error : ORA-39346: data loss in character set conversion for object DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS

     2 - I would like Delete all my statistics, and statistics system.

          2-1 delete all my statistics ( All schema ) and statistics system.dbms_stats.delete_schema_stats('NOM_SCHEMA'). Correct ?

          2-2 Recreate all my statistics ( all schema, and system )

          But i have plenty of schema how is it possible drop all the statistics of the schema.

          BEGIN

             DBMS_STATS.GATHER_TABLE_STATS (

                    ownname => upper('$SCHEMA_NAME'),

                    cascade => $CASCD,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center