create user franck identified by franck default tablespace exploit;
alter user franck quota unlimited on exploit;
grant create session to franck;
grant create table to franck;
conn franck/franck
create table fra(c1 varchar2(5), c2 varchar2(5));
insert into fra values ('AA','AA');
insert into fra values ('BB','BB');
-- on fait l'export 10G :
oracle:10.2.0.4:/home/oracle]exp system/*** owner=franck file=franck.dmp log=franck.log
Export: Release 10.2.0.4.0 - Production on Thu Feb 28 10:23:32 2013
...
Export terminated successfully without warnings.
oracle:11.2.0.3:/home/oracle]
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 28 10:27:15 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
conn /as sysdba
create user franck identified by franck default tablespace exploit;
alter user franck quota unlimited on exploit;
grant create session to franck;
grant create table to franck;
conn franck/franck
create table fra(c1 varchar2(5), c2 varchar2(5));
insert into fra values ('XX','XX');
insert into fra values ('YY','YY');
-- on fait l'import 11G :
oracle:11.2.0.3:/home/oracle]imp system/*** fromuser=franck touser=franck file=franck.dmp log=franckimp.log ignore=Y
Import: Release 11.2.0.3.0 - Production on Thu Feb 28 10:30:31 2013
...
Import terminated successfully without warnings.
SQL> select * from fra;
C1 C2
----- -----
XX XX
YY YY
AA AA
BB BB
-- on fait un export 11G :
oracle:11.2.0.3:/home/oracle]exp system/*** owner=franck file=francke11G.dmp log=francke11G.log
Export: Release 11.2.0.3.0 - Production on Thu Feb 28 10:35:03 2013
...
Export terminated successfully without warnings.
-- on teste un import 10G à partir d'un dump 11G : KO
oracle:10.2.0.4:/home/oracle]imp system/*** fromuser=franck touser=franck file=francke11G.dmp log=francki10G.log ignore=Y <
Import: Release 10.2.0.4.0 - Production on Thu Feb 28 10:36:52 2013
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
-- idem avec le binaire 11G :
oracle:10.2.0.4:/home/oracle]/opt/oracle/11.2/bin/imp system/*** fromuser=franck touser=franck file=francke11G.dmp log=francki10G.log ignore=Y <
Import: Release 11.2.0.3.0 - Production on Thu Feb 28 10:38:21 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
IMP-00058:
IMP-00000: Import terminated unsuccessfully
Partager