to list the contents of the files using import oracle tool

[dngaya]

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.

[Graham Cameron_1 · Accepted solution]

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

[Joseph Loo]

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.

[Joseph Loo]

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.

[Jean-Luc Oudart]

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

[Yogeeraj_1]

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