A simple backup method to restore the blank PDMLink 8.0  (Pro/INTRALINK 8.0)
after having populated it with data from a first migration attempt
(export/import of an oracle dumpfile).
 
When performing a data migration, you will repeat the migration procedure a
number of times to rehearse the process.  Each migration attempt results in
data being migrated into the target system.  In order to perform subsequent
migrations, this migrated data will need to be removed from the target system,
otherwise duplicate object conflicts would occur for every object in the
system.  

The simplest way to reset the system to a pre-migration state, is to import an
Oracle Dumpfile "snapshot".  Creating the snapshot should be done immediately
before a migration attempt begins, at the point where the Windchill 8.0
system, including the Data Migrator, has been completely installed,
configured, and validated.  This "snapshot" of the Oracle database will act as
the waypoint that can be returned to easily, by importing the dumpfile into 
Oracle.  

The following procedures should be followed for creation of the shapshot
before migration (Steps 1-3), dropping the PDMLink schema user, recreating
the user and Importing the dumpfile to reset the system (Step 4), and
recompiling packages that might have been invalidated (Step 5).
 
1. After a successful  Pro/INTRALINK 8.0 and Pro/INTRALINK Data Migrator
installation login to Pro/INTRALINK 8.0 as local admin (wcadmin/wcadmin),
configure and validate  the external vaults, create the IBA organizer
(TestOrganizer) and the libraries and products.
 
2. Run "ildataloader Mapping" and select option 1 (test connection). If
this test is successful exit out of the dataloader and follow the step below
to create a pdmlink dumpfile.
 
3. Create a pdmlink dumpfile:
 
DOS>exp system/manager@wind file=D:\ptc\pdmlink\empty_ilink8_M10_dump.dmp owner=guest log=exp.log
 
where: "wind" is the Pro/INTRALINK 8.0 service name  and "guest" is the owner
of Pro/INTRALINK 8.0 schema. These names can be different depending on what
you chose during the installation procedure.
 
4. After the dumpfile is created, proceed with the migration steps and run 
all the migration loaders including the filetransfer. When the time comes
that you want to run the migration a second time around, all you need to do
is drop the PDMLink schema user, 

run the script <pdmlink loadpoint>\db\sql\create_user.sql and import the
dumpfile you created in the previous step as illustrated in the example below:
 
DOS> sqlplus system/manager@wind
SQL> drop user guest cascade;
SQL>@<pdmlink loadpoint>\db\sql\create_user.sql
Enter username: guest
Enter temporary tablespace: TEMP
Enter users tablespace: USERS
SQL>exit
 
DOS>imp system/manager@wind file=D:\ptc\pdmlink\empty_ilink8_M10_dump.dmp full=y ignore=y log=import_log.lst
 
5. Follow instructions of TPI 128926 to identify and re-compile any packages
that might have been invalidated.