Unable to import SCRAMBLE.dmp into SCRAMBLE database

book

Article ID: 15033

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/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.



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

imp SCRAMBLE/[email protected]: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

Resolution

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.