ORACLE DB : What to do with this dump file

I was asked in short notice to check the dump file received from third party can be converted in any meaningful data? The

only information I was given a location of file.

There was no more information available and no contact to get more information.

Here how I proceed:

Check the file type

% type webconfig.dmp

webconfig.dmp: ascii.text

% head webconfig.dmp

UWEBCONFIG
RUSERS
1024
0
28
0
#G#A°#G#A°#CREATE SEQUENCE "SEQ_GUIBASECONFIGTABLE" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 226 CACHE

3 NOORDER NOCYCLE
CREATE SEQUENCE "SEQ_GUIFEATURETABLE" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 921 CACHE 4

NOORDER NOCYCLE

%

This give me that this a oracle dump file from my past experience. Also I know that this is created for user level and the

schema name is WEBCONFIG

Now I have to find a working oracle database to find more information. I use my test database and perform following



$ imp system/***** show=y FILE=webconfig.dmp FULL=Y

Import: Release 9.2.0.1.0 - Production on Wed Jun 28 21:25:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by WEBCONFIG, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)

. importing WEBCONFIG's objects into SYSTEM
"CREATE TABLE "ATATTRIBUTETYPE" ("NAME" VARCHAR2(80) NOT NULL ENABLE, "DESCR"
"IPTION" VARCHAR2(80) NOT NULL ENABLE, "DATATYPE" NUMBER(10, 0) NOT NULL ENA"
"BLE, "ISSUMMABLE" NUMBER(1, 0) NOT NULL ENABLE, "STATUS" VARCHAR2(1) NOT NU"
"LL ENABLE, "LAST_UPDATED_BY" VARCHAR2(30) NOT NULL ENABLE, "TIME_STAMP" DAT"
"E) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 4"
"0960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREEL"
"IST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "WEBCONFIG_DATA""
. . skipping table "ATATTRIBUTETYPE"


The outcome is truncated

From the above outcome I search for TABLESPACE and find out what tablespace are needed to make it successful load and the

character set information.

Now I have information to proceed. I created the required tablespaces and created a new user let’s call it CWP with connect

and resource role.

% imp system/****** FILE=webconfig.dmp FROMUSER=WEBCONFIG TOUSER=NEWUSER

The import terminated successfully without warnings.

One less thinng to worry about.