oracle 12c 导入10g,Oracle导入导出之大字段从10g导出并导入11g

[

oracle

@

rhel

-

ORCL

dump

]

$

imp hr

/

hr

file

=

/

home

/

oracle

/

dump

/

ora10gCLOB

.

dmp

log

=

ora10gCLOB

.

log

REMAP_SCHEMA

=

hr

:

oe REMAP_TABLESPACE

=

users

:

testlob ignore

=

y

LRM

-

00101

:

unknown parameter name

'REMAP_SCHEMA'

IMP

-

00022

:

failed

to

process parameters

,

type

'IMP HELP=Y'

for

help

IMP

-

00000

:

Import terminated unsuccessfully

[

oracle

@

rhel

-

ORCL

dump

]

$

imp hr

/

hr

file

=

/

home

/

oracle

/

dump

/

ora10gCLOB

.

dmp

log

=

ora10gCLOB

.

log

fromuser

=

hr touser

=

oe tablespaces

=

testlob ignore

=

y

Import

:

Release

11

.

2

.

.

3

.

0

-

Production

on

Wed Jan 24 16

:

50

:

42 2018

Copyright

(

c

)

1982

,

2011

,

Oracle

and

/

or

its affiliates

.

All

rights reserved

.

Connected

to

:

Oracle

Database

11g Enterprise Edition

Release

11

.

2

.

.

3

.

0

-

Production

With

the Partitioning

,

OLAP

,

Data

Mining

and

Real

Application Testing options

Export

file

created

by

EXPORT

:

V10

.

02

.

01 via conventional path

import done

in

US7ASCII character

set

and

AL16UTF16 NCHAR character

set

import server uses AL32UTF8 character

set

(

possible charset conversion

)

IMP

-

00007

:

must be a DBA

to

import objects

to

another

user

's account

IMP-00000: Import terminated unsuccessfully

[oracle@rhel-ORCL dump]$imp system/oracle file=/home/oracle/dump/ora10gCLOB.dmp log=ora10gCLOB.log fromuser=hr touser=oe tablespaces=testlob ignore=y

Import: Release 11.2.0.3.0 - Production on Wed Jan 24 16:51:16 2018

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

IMP-00058: ORACLE error 28002 encountered

ORA-28002: the password will expire within 7 days

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by HR, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

. importing HR's objects

into

OE

.

.

importing

table

"MA_LOB_DUMP"

4

rows

imported

Import terminated successfully

with

warnings

.