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

Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import

Re: Export/Import

From: Tim <who_at_at_my-deja.com>
Date: 2000/08/02
Message-ID: <2y%h5.6827$hg1.482284@news-west.usenetserver.com>#1/1

The FTP in binary mode fixed my problem, but now I have a new problem. When I try to import I get error messages stating that it cannot create the database files and tablespaces. It is trying to use the AIX directory structure. What do I need to do so that it will successfully import into my production NT 4 box?

Regards,
Tim

Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid> wrote in message news:1734f17d.8e8e938c_at_usw-ex0105-037.remarq.com...
> Tim..this is actually a pretty common problem, if you search
> deja.com archives you may find more than I can tell you. You
> will also find docs on this at metalink and maybe technet.
> Anyway most of the time the solution is to use the 8.1.6 export
> utility to export your data from the 7.3 database and the import
> it. My memory is a little weak here but i think you need to add
> a entry to your tnsnames file that points to the 7.3 instance
> then you can connect to it from the 8.1.6 export utility as
> follows
>
> exp user/pass_at_Instance file=........
>
> Make sure you find some more info to back this up before you try
> it but pretty sure that is the problem. Also make sure you ftp
> in binary mode.
>
> -Ethan
> http://www.gnumetrics.com (Free Web Based Performance Monitoring
> Tool)
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Wed Aug 02 2000 - 00:00:00 CDT

Original text of this message

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