Database Utilities (MOSC)

MOSC Banner

Imp Transport tablespace :datafile incorrect version error

edited Nov 30, 2009 10:06PM in Database Utilities (MOSC) 2 commentsAnswered
 Dear all,
I do EXP , IMP transport tablespace on Database 11g same HOST.

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for 64-bit Windows: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Step of implement :

1.alter tablepspase readonly
2.do EXP

Exp script:

USERID='sys/sys@twctest AS SYSDBA' 
TRANSPORT_TABLESPACE=y 
TABLESPACES=INDX,TOOLS,TWI,TWI_ARC,TWI_IDX,TWI_MESS,TWI_MESS_IDX,TWI_TRAN,TWI_TRAN_IDX  
FILE=F:\all.dmp

3. Create user.
4. Copy data file
5. do IMP
Imp script :

USERID='sys/sys@twctest2 AS SYSDBA' 
TRANSPORT_TABLESPACE=y 
        DATAFILES='F:\Oracle\ORADATA\TWCTEST2\TWCTEST2\INDX01.DBF',

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