Re: export/import
Date: Thu, 25 Oct 2001 10:56:50 +0200
Message-ID: <3bd7d3cf$1_at_news.vogel.pl>
Użytkownik "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> napisał w wiadomości
news:9r7v18$19aj$1_at_as201.hinet.hr...
> I created dump full exporting Oracle 7.3.4 database using:
>
> > exp73 FILE=abc.dmp LOG=abc.log FULL=y INCTYPE=complete
>
> after that I dropped some tables (i.e. T1,T2) and tried to import only
> those tables using:
>
> > imp73 FILE=abc.dmp TABLES=(T1,T2)
>
> Imp73 said everything was done fine but T1 and T2 waren't imported at
> all.
>
> Does import of separate tables work?
yes, it does.
> Stjepan Brbot [Stjepan.Brbot_at_ZG.HiNet.HR]
>
Not sure about imp73, but try:
imp73 FILE=abc.dmp TABLES=(T1,T2) FULL='Y'
(once i had to add 'full=y' while import w/o this it refused to import a single table ).
ps. im using imp80, but with oracle 8.1.7 i've noticed just imp.exe. Received on Thu Oct 25 2001 - 10:56:50 CEST