HELP!!!
I am an ORACLE newbie(and that's putting it mildly). This is going to be a long one, and I've researched for days and am no closer to a solution to get this done. Here goes:
Here’s the situation in a nutshell. We received from one of our clients ORACLE dmp files, which as you know are ORACLE proprietary binary format files intended to be re-imported to an ORACLE database. We are a MS-SQLServer Shop and I have no experience with ORACLE.(until now).I downloaded the 18c express version of ORACLE, but this comes with no technical support.
and created a pluggable database(I’ll figure that out later what that means). I tried using DataPump to import the DMP files but was given a message indicating that DP could NOT import, and that the original IMP/EXP utility should be used. OK, so I figured out what that was(all with no technical support) and began the experience of importing the DMP files to my SYSTEM table space. It worked well up to a point. It showed me the SQL to recreate the table(I cut and pasted because it was not able to create the table itself) and created the table using SQLDeveloper. I also manually created the ALTER Database script as that was not executed from the DMP file within the IMP utility.
So essentially I have the table created, but now I need to import the data ONLY from this DMP file and I need the correct IMP syntax in order to do so.
I’m using the IMP syntax at the command line(as administrator), logging in as ‘SYSTEM’, which the correct password. Here is the command line from the export, sent to us, I guess
to help us:
for CUST
exp ar/live file=/gers/live/tmp/CUST_190312.dmp tables=cust query=\" where acct_opn_dt between \'01-JAN-98\' and sysdate-1\" record=n buffer=250000 statistics=none indexes=n triggers=n grants=n
So what’s the import syntax that I can do all at once, rather than piece meal, which is what I’m getting now(I have to type in IMP and then validate my credentials), followed by a series of
questions….which do not work.
What am I missing here. Any help is greatly appreciated!!!
Thanks AJVINKLES(My display name does not work either....)