Product

Platform

Intel

Operating system

Windows NT/Windows 2000 Server

Error

Symptoms

Cause

3) Zip the exported file.

4) Copy it to the following location to run the export utility:

Solution

This workaround should be used only when you need to extract customer Archiver tables (dbcs_archive, dbcs_archivefile, dbcs_archivemedium) for analysis.

=================================================

FOR PRINERGY 1.1 PROCEDURE (export from 1.1 and import into 1.1 system)

To export Archiver tables from the database:

1) RCMD into the customer's system.

2) S:\>type <exp80 araxi_1_0_12/araxi> to login to export utility

Export: Release 8.0.5.1.0 - Production on Fri Mar 31 11:20:10 2000

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connected to: Oracle8 Release 8.0.5.1.1 - Production

PL/SQL Release 8.0.5.1.0 - Production

Enter array fetch buffer size: 4096 ><ENTER>

Export file: EXPDAT.DMP > D:\temp\expgiethoorn.dmp

(2)U(sers), or (3)T(ables): (2)U > T

Export table data (yes/no): yes ><ENTER>

Compress extents (yes/no): yes ><ENTER>

Export done in WE8ISO8859P1 character set and AL24UTFFSS NCHAR character set

About to export specified tables via Conventional Path ...

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archivemedium

. . exporting table DBCS_ARCHIVEMEDIUM 9 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archive

. . exporting table DBCS_ARCHIVE 133 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archivefile

. . exporting table DBCS_ARCHIVEFILE 17236 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) ><return>

Export terminated successfully without warnings.

3). Zip the exported file.

D:\>cd temp

D:\Temp>zip expgiethoorn.zip expgiethoorn.dmp

adding: expgiethoorn.dmp (deflated 84%)

4) Exit RCMD session and copy the file over.

--------------------------------------------------------------------------------------------------

Before you import the archiver tables to another database, you need to trancate all the data on the existing 3 tables. If not, it will combine the export data with the existing data.

To import the Archiver tables into another database:

1) Extract the ZIP file to d:\temp directory.

2) Go to dos prompt, type <imp80 araxi_1_0_12/araxi> to login to Import Utility

Connected to: Oracle8 Release 8.0.5.1.1 - Production

PL/SQL Release 8.0.5.1.0 - Production

Import file: EXPDAT.DMP > D:\temp\expgiethoorn.dmp

Enter array fetch buffer size: 4096 ><ENTER>

Export file created by EXPORT:V08.00.05 via conventional path

List contents of import file only <yes/no> N

Ignore create error due to object existence <yes/no> Y

Import grants <yes/no> Y

Import entire export file <Yes/No> Y

. importing ARAXI_1_0_12's objects into ARAXI_1_0_12

..importing table DBCS_ARCHIVEMEDIUM 9 rows exported

..importing table DBCS_ARCHIVE 133 rows exported

. . exporting table DBCS_ARCHIVEFILE 17236 rows exported

About to enable constraints

Import terminated successfully without warnings.

=================================================

FOR PRINERGY 2.0, (To export Archiver tables from 2.0 and import into 2.0).

1.) RCMD into the system

2.) Go to dos prompt, type <set NLS_LANG=AMERICAN_AMERICA.UTF8> and enter.

3.) Type <EXP PRINERGY/ARAXI> to login to Export Utility

Export: Release 8.1.6.1.0 - Production on Tue Oct 23 10:41:41 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Release 8.1.6.1.0 - Production

JServer Release 8.1.6.0.0 - Production

Enter array fetch buffer size: 4096 > <ENTER>

Export file: EXPDAT.DMP > D:\Temp\ARCHIVER.DMP

(2)U(sers), or (3)T(ables): (2)U > T

Export table data (yes/no): yes > <ENTER>

Compress extents (yes/no): yes > <ENTER>

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archivemedium

. . exporting table DBCS_ARCHIVEMEDIUM 15 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archive

. . exporting table DBCS_ARCHIVE 2304 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > dbcs_archivefile

. . exporting table DBCS_ARCHIVEFILE 251211 rows exported

Table(T) or Partition(T:P) to be exported: (RETURN to quit) > <RETURN>

Export terminated successfully without warnings.

4.) Zip the exported file.

D:\Temp\zip archiver.zip archiver.dmp

adding: archiver.dmp (92 bytes security) (deflated 83%)

5.) Copy the zip file over.

--------------------------------------------------------------------------------------------------

Before you import the archiver tables to another database, you need to trancate all the data on the existing 3 tables. If not, it will combine the export data with the existing data.

Use the following procedure to import the Archiver tables into another database:

1) Copy the zip file into D:\temp directory

2) Extract the ZIP file to d:\temp directory.

3) Go to dos prompt, type <set NLS_LANG=AMERICAN_AMERICA.UTF8> and enter.

4) Type <imp prinergy/araxi> to login to Import Utility

Import: Release 8.1.6.1.0 - Production on Tue Oct 23 10:44:33 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Release 8.1.6.1.0 - Production

JServer Release 8.1.6.0.0 - Production

Import file: EXPDAT.DMP > d:\Temp\archiver.dmp

Enter insert buffer size (minimum is 8192) 30720> <ENTER>

Export file created by EXPORT:V08.01.06 via conventional path

import done in UTF8 character set and UTF8 NCHAR character set

List contents of import file only (yes/no): no > <ENTER>

Ignore create error due to object existence (yes/no): no > <ENTER>

Import grants (yes/no): yes > <ENTER>

Import table data (yes/no): yes > <ENTER>

Import entire export file (yes/no): no > <YES>

Username: ENTER <prinergy>

. importing PRINERGY objects into PRINERGY

..importing table DBCS_ARCHIVEMEDIUM 15 rows exported

..importing table DBCS_ARCHIVE 2304 rows exported

. . exporting table DBCS_ARCHIVEFILE 251211 rows exported

About to enable constraints

Import terminated successfully without warnings.

Permanent fix:

See also

Keywords

archiver FAQs

Technical contact(s)

Amy Chan

Submitted by

Amy Chan

Date submitted