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_at_reading.news.pipex.net>
Date: Fri, 17 Jan 2003 08:52:46 -0000
Message-ID: <3e27c45e$0$240$ed9e5944_at_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...Received on Fri Jan 17 2003 - 09:52:46 CET
> 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
>
>