Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

to list the contents of the files using import oracle tool

SOLVED
Go to solution
dngaya
Advisor

to list the contents of the files using import oracle tool

hello,
I come from to install again my base oracle 7.3.4 on HP following a problem materiel. the problem is that I have the export of the base but I do not know any more the owners tables I test to take the option show=y of import oracle tool by doing this:
imp system/motdepasse file=t log=test.log show=y
but nothing execute. how to do it?. thank you for your assistance.


5 REPLIES
Graham Cameron_1
Honored Contributor
Solution

Re: to list the contents of the files using import oracle tool

Add "FULL=Y to your option list.

ie
imp system/xxx file=t log=test.log show=y full=y

BTW "t" is an odd (but legal) name for an export file, are you sure that's what it really is ?

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Joseph Loo
Honored Contributor

Re: to list the contents of the files using import oracle tool

Hi,

make sure t.dmp is under the directory you are typing the import command, the syntax should be:

imp username/password file=t.dmp show=yes log=imp.log

regards.
what you do not see does not mean you should not believe
Joseph Loo
Honored Contributor

Re: to list the contents of the files using import oracle tool

by the way, if you have multiple database instances, i.e. ORACLE_SID in the same server, this syntax should work.

# imp username/password@ORACLE_SID file=t.dmp show=yes log=imp.log

in fact, show=y and show=yes are the same.

by the way, when you type command imp, what is the output? it should be "Import: Release 7.3.x.x.x - Production ..."

regards.
what you do not see does not mean you should not believe
Jean-Luc Oudart
Honored Contributor

Re: to list the contents of the files using import oracle tool

Hi,

unless you use buffer and commit=y, you wil require a large rollback segment (depending on the size of the biggest object to import).

If you decide to commit after every array insert, you better of re-size the buffer

example :
commit=y buffer=16000000

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=88845

Regards,
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: to list the contents of the files using import oracle tool

hi,

am sure that you already have $ORACLE_HOME/bin in your PATH.

You can have more details about IMP options by typing:

imp help=yes

and on Unix, you should "escape" the "/"
so:

imp system/\motdepasse file=t log=test.log show=y


hope this helps too!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)