Database Utilities (MOSC)

MOSC Banner

Insufficient priviledges (ora-1031) while trying to import a dmp file (11.2.0.4) to a 12.1.0.2 datab

edited Oct 10, 2016 10:47AM in Database Utilities (MOSC) 10 commentsAnswered ✓

Hi,

I'm trying to import a dmp file generated with a DB 11.2.0.4 (source) with the option fromuser/touser to a 12c (12.1.0.2 - target) and got priviledge errors ??

\ymoricea\cit\Programmes>imp system@titan file=svd200316.dmp fromuser=gesci to

user=gesci

Import: Release 12.1.0.2.0 - Production on Lun. Mars 28 16:18:32 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Mot de passe :

ConnectΘ α : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit P

roduction

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

ions

Fichier d'export crΘΘ par EXPORT:V11.02.00 via le chemin classique

import effectuΘ dans le jeu de caractΦres WE8MSWIN1252 et le jeu NCHAR AL16UTF16

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