Unable to import SCRAMBLE.dmp into SCRAMBLE database

Document ID : KB000015033
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This knowledge base article covers a question on installing CA Test Data Manager's sample data into an Oracle schema without using our install script. We supply scripts in our DB Install Kit for importing data into both Oracle and Microsoft SQL Server. It's always recommended to use our scripts for the installation of the data. If you need to change the scripts to tailor to your environment, you should consult your DBA before making your changes.

Question:

I tried to install the Scramble database with the following command.

imp SCRAMBLE/scramble@myServer:1521/GTREP FILE=scramble.dmp FROMUSER=SCRAMBLE TOUSER=SCRAMBLE 

 

And this is the result that returns from the import command.

 

Import: Release 11.2.0.1.0 - Production on Fri Jun 30 11:10:33 2017 

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit  Production 

With the Partitioning, OLAP, Data Mining and Real Application Testing options 

 

IMP-00010: not a valid export file, header failed verification 

IMP-00000: Import terminated unsuccessfully 

 

Is there a way to import the Scramble database into Oracle without having to run the supplied scripts?

Environment:
CA Test Data Manager (TDM)- Datamaker
Answer:

For our Scramble database, we use a dump file for storing the data in our installer, so imp is not the right Oracle tool to use for importing this schema.

Here is the command as it appears in our scramble.bat file (located in \DB-install-kit-3.x.x\Oracle_Install_Kit\Databases\Scramble)

 

impdp '"%GT_SYS_USER%/%GT_SYS_PASSWORD%%GT_TNS%"' remap_schema=scramble:%DB_USER% directory=SCRMBLPUMP dumpfile=scramble.dmp logfile=import.log version=11.1 

 

If you need further assistance with the Oracle command of impdp,  please reach out to your Oracle DBA.

It is highly recommended that you use our scripts for importing our repository, scramble and test schemas. Making custom changes to these scripts or using impdp and expdp directly is not supported.