You might also want to try SQL*Copy (if it is available in V6) or use DB links from 6 to 8.
michael smith

-----Original Message-----
From: Michael Holstead
[mailto:oracledba-ezmlmshield-x30983751.[Email address protected]
Sent: Friday, June 09, 2006 4:10 AM
To: LazyDBA Discussion
Subject: RE: Query


Hi,
Generally an export .dmp file taken by a "higher/newer" version of the
database cannot be read by an earlier version of imp. So I would expect
a dmp file create by version 8 cannot be read by version 6 import.

However, It would be worth trying to see if the Version 6 exp utility
can read the 8 database.

Regards,

Mick Holstead
IT Development
Weatherbys Ventures LTD
Sanders Road
Wellingborough
NN8 4BX

Tel: 01933 440077 ext 2817
E-Mail: [Email address protected]
-----Original Message-----
From: VIDYADHAR M AGATE
[mailto:oracledba-ezmlmshield-x63477176.[Email address protected]
Sent: 09 June 2006 07:49
To: LazyDBA Discussion
Subject: Query

Hi DBA's

I know , what I am asking, but it is the need of time,

Could I do the import of oracle 8.0.4.4.0 table data in oracle 6
version. If so , how ?

If not thru export/import what are the possible alternate ways ?


Thanks in Advance

VMA


DISCLAIMER:
This message,including any attachments contains confidential and
privileged information for the sole use of the intended recipient(s),
and is protected by law. If you are not the intended recipient, please
destroy all copies of the original message. Any unauthorized review,
use, disclosure, dissemination, forwarding, printing or copying of this
email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Bajaj Auto reserves the right to record, monitor, and inspect all email
communications through its internal and external networks. Your messages
shall be subject to such lawful supervision as Bajaj Auto deems
necessary in order to protect its information, interests and reputation.
Bajaj Auto prohibits and takes steps to prevent its information systems
from being used to view, store or forward offensive or discriminatory
material. If this message contains such material, please report it to
[Email address protected]


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page