RE: export and import advise

Yes, U r right. This method is used basically for migration. I was asked in an interview as to how I will do migration. I said, Export - Create DDL in Ora * - and import.

The guy at the other end was a jerk - he says - why do u need to do a DDL? We need to do a DDL to take care of storage params.

Correct me if I am wrong.

Raj

-----Original Message-----
From: Mohammad Rafiq [SMTP:rafiq9857_at_hotmail.com] Sent: Saturday, May 05, 2001 12:35 AM

To:     Multiple recipients of list ORACLE-L
Subject:        Re: export and import advise

If you want to say that export dmp is under 7.3.4 to be imported in 8.1.7 database, You can import it without running any thing. If different operating systems like NT/UNIX, ftp file with binary option.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 03 May 2001 20:46:15 -0800

hi Gurus,
One of myclients wants a import file (version 7.3.4) but our database is ver 8.1.7 . I know that for doing this I have to run expcat7.sql file against 8.1.7 database
and run exp/imp utility on client database agianst our database .... using sql*net .
But the problem here is ....the client is no way connected to our database. earlier before we upgrade both databases are at same level so there was no problems.
has any one got other ideas.

rgs
> narender.akula
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Narender Akula
   INET: narender.akula_at_terralinkltd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: rajaram_k_at_netzero.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).