Sunday, November 11, 2012

IMP-00031 fromuser touser


import and export from original schema to another dedicated schema. Often, I have no idea what people gave me. I was asking for datapump and what I got was something else with no export log.


imp SRM1/passwordfile=/backup/srmadmin.exp full=n buffer=2000000 commit=y ignore=y log=/backup/srmadmin.log


Import: Release 11.2.0.1.0 - Production on Tue Nov 11 09:23:37 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
IMP-00000: Import terminated unsuccessfully

imp SRM1/password file=/backup/srmadmin.exp full=n buffer=2000000 commit=y ignore=y log=/backup/srmadmin.log fromuser=SRMADMIN touser=SRM1

No comments:

Post a Comment