cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Creating Intralink/PDM Link 9.1 dump files

JosephCugini
1-Newbie

Creating Intralink/PDM Link 9.1 dump files

I am beginning down the path of installing Intralink 9.1 and migrating our 3.4 database. At this point I have successfully installed the all the software and started to do a bit of configuration. Before I go any further I'd like to export the database (similar to what we did in Intralink 3.4 using ilink_export.bat) so that I can revert back to a known configuration.


I've found TPI 132658 (Steps to export and import oracle dump files). It suggests performing an export of the schema using the following command:


DOS>exp system/manager@wind file=D:\ptc\pdmlink\empty_ilink_dump.dmp owner=guest log=exp.log


I have successfully executed this command and the dump file was approximately 6 Mb.


I was then working the Windchill E-Learning classes on system administration and they show how to perform an oracle schema dump using Enterprise Manager. Again, I was successful creating at the dump file but this time it was 34 Mb. To be certain, I exported the schema and not the entire database.


Can anyone explain why I'd see such a large file sizedifference using the two different methods? What steps do others follow to perform exports/imports in this new architecture?


Thank you in advance,


Joe

2 REPLIES 2

On Tue, 2011-05-03 at 10:49 -0700, Joseph Cugini wrote:
> I am beginning down the path of installing Intralink 9.1 and migrating
> our 3.4 database.  At this point I have successfully installed the all
> the software and started to do a bit of configuration.  Before I go
> any further I'd like to export the database (similar to what we did in
> Intralink 3.4 using ilink_export.bat) so that I can revert back to a
> known configuration.
>
> I've found TPI 132658 (Steps to export and import oracle dump files).
> It suggests performing an export of the schema using the following
> command:
>
> DOS>exp system/manager@wind file=D:\ptc\pdmlink\empty_ilink_dump.dmp
> owner=guest log=exp.log

As a wild guess.
Did you really use guest for your install?  I would have thought the
user would be wcadmin.

>
> I have successfully executed this command and the dump file was
> approximately 6 Mb.
>
> I was then working the Windchill E-Learning classes on system
> administration and they show how to perform an oracle schema dump
> using Enterprise Manager.  Again, I was successful creating at the
> dump file but this time it was 34 Mb.  To be certain, I exported the
> schema and not the entire database.
>
> Can anyone explain why I'd see such a large file size difference using
> the two different methods?  What steps do others follow to perform
> exports/imports in this new architecture?
>
> Thank you in advance,
>
> Joe
>
>
>
> ----------

--
Bob Lehman

Email: -
Mobile: (503)888-1471



No, I just copied that directly from the TPI. My account where the schema is created is called "oracle".
Top Tags