NEWBI imp Oracle 7.3.4 on DEC

From: Scot Needy <scotrn_at_pilot.infi.net>
Date: 11 Sep 1999 06:13:13 GMT
Message-ID: <8E3E156F7sneedyinfinet@news.infi.net>

Hi;

Sorry if this is a baisc question but I have a DEC Unix 7.3.4 database I need to try and get to Solaris 8i the schema is pretty basic so I am going to give it a go. Here is what I got for the exp and imp

Export options
full=y direct=y

Import system/"passwd" parfile = SID.param

SID.param -------------------------- FILE = REW.exp.199909092300 LOG = REW-199909092300.log FROMUSER = (user1, user2, user3,...)

Any clues on exactly what this means other than what oerr has to say? The online docs jump around so much it makes it har to learn.

Data imported ok but I got these errors.

---------------- imp.log --------------------------------
IMP-00041: Warning: object created with compilation warnings


 "CREATE FORCE VIEW "INDEPENDENT"."SMP_SERVICE_GROUP_DEFN"              "

" ("OWNER","GROUP_NAME","GROUP_TYPE") AS "
"select OWNER, GROUP_NAME, GROUP_TYPE from SMP_SERVICE_GROUP_DEFN_ "
" where USER = OWNER"
" with check option CONSTRAINT "SMP_SERVICE_GROUP_DEFN_CNST""

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "INDEPENDENT"."SMP_JOB" ("ID","OWNER""
","NAME","TYPE","SERVICE_ID","SCHEDULE","MACHINE_NAME","READONLY","JOB_DE
SCR"
"IPTION","FIXEDIT","LIBRARY","JOB_TMPSCRIPTFILE") AS "
"select id, owner, name, type, service_id, schedule, machine_name,
readonly,"
" job_description, fixedit, library, JOB_TMPSCRIPTFILE from SMP_JOB_ "
" where user = owner WITH CHECK OPTION"

TIA Scot (Yes with one T) Received on Sat Sep 11 1999 - 01:13:13 CDT

NEWBI imp Oracle 7.3.4 on DEC - > 8i Solaris