Intralink 3.3 M022 to Intralink 3.4 M012

[TimMcGee]

I am trying to import a dump file from Intralink 3.3 M022 to Intralink M012, but when I run ilink_import I get these results

Removing invalid jobs if they exist ... OK
Removing existing Data Server information:
- PDM schema
- PDM_PWD schema
- PDM_REPL_SVC schema

Import Dump Type : Regular Tablespaces
Importing contents of "D:\ptc\Dump\ILINKEXPORT.DMP" ... List of error messages:

IMP-00017: following statement failed with ORACLE error 1659:

[RandyJones]

On 10/25/10 10:26, Tim McGee wrote:
> I am trying to import a dump file from Intralink 3.3 M022 to Intralink M012, but
> when I run ilink_import I get these results
>
> Removing invalid jobs if they exist ... OK
> Removing existing Data Server information:
> - PDM schema
> - PDM_PWD schema
> - PDM_REPL_SVC schema
>
> Import Dump Type : Regular Tablespaces
> Importing contents of "D:\ptc\Dump\ILINKEXPORT.DMP" ... List of error messages:
>
> IMP-00017: following statement failed with ORACLE error 1659:
> IMP-00003: ORACLE error 1659 encountered
> ORA-01659: unable to allocate MINEXTENTS beyond 94 in tablespace PDM_TABLE
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 1652:
> IMP-00003: ORACLE error 1652 encountered
> ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 942:
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
> IMP-00017: following statement failed with ORACLE error 2430:
>
> Errors description:
>
> ptc_oerr: data for IMP-00017: was not found.
> ptc_oerr: data for IMP-00003: was not found.
> ptc_oerr: data for ORA-01659: was not found.
> ptc_oerr: data for ORA-01652: was not found.
> ptc_oerr: data for ORA-00942: was not found.:ImportRegular
> while executing
> "ImportRegular ${impFileName} $IgnoreErrors"
> (procedure "importDB" line 85)
> invoked from within
> "importDB $impFileName"
> (file "ilink_import.tcl" line 109)


Either you ran out of disk space or you are attempting to put more data in
your oracle tables than you have space allocated for. Most likely the latter.

I almost always turn autoextend on when importing an intralink dump file:

Autoextend on for data files
sqlplus system/manager
col file_name format a60;
select file_name, autoextensible from dba_data_files;
alter database datafile 'file name goes here' autoextend on;
repeat above statement for all files where aut = NO

Autoextend on for temp files
sqlplus system/manager
col file_name format a60;
select file_name, autoextensible from dba_temp_files;
alter database tempfile 'file name goes here' autoextend on;
repeat above statement for all files where aut = NO

Perform import

Turn autoextend off for data files that were previously off
sqlplus system/manager
col file_name format a60;
select file_name, autoextensible from dba_data_files;
alter database datafile 'file name goes here' autoextend off;
repeat above statement for all files where aut = NO above

Turn autoextend off for temp files that were previously off
sqlplus system/manager
col file_name format a60;
select file_name, autoextensible from dba_temp_files;
alter database tempfile 'file name goes here' autoextend off;
repeat above statement for all files where aut = NO above


So the procedure is:
autoextend on
import
autoextend off (for all files that were off before)

--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
Fax: 785-667-2695
------------------------------------------------------------------------