Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing

Re: Importing

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 17 Jan 2003 08:52:46 -0000
Message-ID: <3e27c45e$0$240$ed9e5944@reading.news.pipex.net>


imp show=y Is I think what you are after, you want to pipe output to a file that you can then edit.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"James" <james.varga_at_mindsweep.net> wrote in message
news:v2fgs3pcjne5b9_at_corp.supernews.com...

> Can anyone tell me what the command line option is for creating a file of
> the table/etc. creation steps when importing a file. I am cloning a
database
> through Imp/Exp and I need to be able to create the new tablespaces/etc.
> first prior to the import. I know this can be done because I have done it
> before but I can't remember how (or find it in any documentation). Thanks,
>
> James
>
>
Received on Fri Jan 17 2003 - 02:52:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US