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 126.96.36.199.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 188.8.131.52.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?
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.