Idiotproof guide to importing .dmp files & running scripts

[Laneyh]

Hi

I need to get up to speed with Oracle pretty quickly
Alas I know nothing !

Does anyone have any good recommended reading ?

I have a specific need to test importing dump files and
then running a series of upgraded scripts against an application which sits on Oracle.

If you think you can help I can PM more specific details of what I'm trying to do

Thank you

 

[SantaMufasa]

Laney,

Generally, you can find anything you want by Googling your topic. Just now, I Googled for "Oracle imp reference" and found only 401,000 hits. Amongst them, "

http://www.psoug.org/reference/import.html",

which seemed to be a robust online reference.

On the topic of "Running a series of upgraded scripts against an application which sits on Oracle", although you can Google for that, as well, I'll post that aspect, below. Following your successful connecting to SQL*Plus, (On Windows: Start -> Programs -> Oracle... -> Application Development -> SQL Plus), you can invoke any value script name at the SQL*Plus prompt using the "@" character:

SQL > @<drive\path\><script name>

(example)
SQL > @c:\dhunt\sqldba\tt_404

  ID NAME
---- --------------------
   1 North America
   2 South America
   3 Africa / Middle East
   4 Asia
   5 Europe

Let us know if this offers the guidance you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[SantaMufasa]

BTW, if you want "Idiotproof..." for "imp" and "exp", then at your o/s prompt, just issue the command:

imp

The result is an interactive prompting of argument values necessary to conduct an import.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]