Home » RDBMS Server » Server Administration » How import using transport tablespace??
| How import using transport tablespace?? [message #116648] |
Thu, 21 April 2005 02:28  |
ardi_nug
Messages: 2
Registered: April 2005
Location: jakarta
|
Junior Member |
|
|
Anyone can help me??
i have a problem when import using transport tablespace in oracle 9.2.
when i submit the import script then got this error :
Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
About to import transportable tablespace(s) metadata...
import done in UTF8 character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 19722:
"BEGIN sys.dbms_plugts.checkDatafile(NULL,4275407957,18,256128,19,18,10241"
"28,12800,48457,19875492482,1,75497474,NULL,NULL,NULL); END;"
IMP-00003: ORACLE error 19722 encountered
ORA-19722: datafile /dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_01.dbf is an incorrect version
ORA-06512: at "SYS.DBMS_PLUGTS", line 1733
ORA-06512: at line 1
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
AL 52428800 FREELISTS 8 FREELIST GROUPS 1), SUBPARTITION "SYS_SUBP354" TABLESPACE "RPT_DSCQ02_TS" STORAGE(SEG_FILE 19 SEG_BLOCK 256110 OBJNO_REUSE 267796 INITIAL 52428800 FREELISTS 8 FREELIST GROUPS 1), SUBPARTITION "SYS_SUBP355" TABLESPACE "RPT_DSCQ0...
Import terminated successfully with warnings.
my machine has 1 oracle and 2 intance, and i export from 1 instance and import to another instance.
thanks.
|
|
|
|
|
|
| Re: How import using transport tablespace?? [message #117092 is a reply to message #116703] |
Sun, 24 April 2005 20:27  |
ardi_nug
Messages: 2
Registered: April 2005
Location: jakarta
|
Junior Member |
|
|
yes right....
i use oracle 9.2
in this case, i have 4 tablespace and 37 datafiles that i want to import.
Large 37 files is 390 Gb.
isn't large file effect to import, especially in buffer system??
this is export log :
Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
Export done in UTF8 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
Note: grants on tables/views/sequences/roles will not be exported
About to export transportable tablespace metadata...
For tablespace RPT_DSCQ01_TS ...
. exporting cluster definitions
. exporting table definitions
. . exporting table DWH_DSC_QUE
For tablespace RPT_DSCQ02_TS ...
. exporting cluster definitions
. exporting table definitions
For tablespace RPT_DSCQ03_TS ...
. exporting cluster definitions
. exporting table definitions
For tablespace RPT_DSCQ04_TS ...
. exporting cluster definitions
. exporting table definitions
. exporting referential integrity constraints
. end transportable tablespace metadata export
Export terminated successfully without warnings.
and i use this script to import transport tablespace :
/app/rdbms/oracle/product/9.2.0/bin/imp transport_tablespace=y tablespaces=\(RPT_DSCQ01_TS,RPT_DSCQ02_TS,RPT_DSCQ03_TS,RPT_DSCQ04_TS\) datafiles=\(/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_01.dbf,/datarestore/backup/backup_dsc/export_20050413/rpt_dscq_02_i brs_01.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_01.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_01.dbf, /dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_02.dbf,/datarestore/backup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_02.dbf,/ dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_02.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_03.dbf,/datarestore /backup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_03.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_03.dbf,/dataCDR1/bac kup_dsc/export_20050413/rpt_dscq_04_ibrs_03.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_04.dbf,/datarestore/backup/back up_dsc/export_20050413/rpt_dscq_02_ibrs_04.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_04.dbf,/dataCDR1/backup_dsc/expo rt_20050413/rpt_dscq_04_ibrs_04.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_05.dbf,/datarestore/backup/backup_dsc/expor t_20050413/rpt_dscq_02_ibrs_05.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_05.dbf,/dataCDR1/backup_dsc/export_20050413/ rpt_dscq_04_ibrs_05.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_06.dbf,/datarestore/backup/backup_dsc/export_20050413/r pt_dscq_02_ibrs_06.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_06.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ ibrs_06.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_01_ibrs_07.dbf,/datarestore/backup/backup_dsc/export_20050413/rpt_dscq_02_i brs_07.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_07.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_07.dbf, /datarestore/backup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_08.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_08.dbf,/ dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_08.dbf,/datarestore/backup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_09.dbf,/d ataCDR1/backup_dsc/export_20050413/rpt_dscq_03_ibrs_09.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_09.dbf,/datarestore/ backup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_10.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_10.dbf,/datarestore/b ackup/backup_dsc/export_20050413/rpt_dscq_02_ibrs_11.dbf,/dataCDR1/backup_dsc/export_20050413/rpt_dscq_04_ibrs_11.dbf\) tts_owners=RPT fromuser=RPT touser=RPT file=/dataCDR1/backup_dsc/export_20050413/exp_20050413.dmp log=/dataCDR1/backup_dsc/export_20050413/import_20050418.log
anything wrong with my script??
i hope u can solve my problem..
thanks.
[Updated on: Sun, 24 April 2005 23:06] Report message to a moderator |
|
|
|
Goto Forum:
Current Time: Sun Jan 26 04:32:19 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
