Re: Export/Import

On NT, run the import with show=y full=y log=<filename> This will dump all create statements to the log file. The create tablespace statements will be first. Isolate them to a separate file and edit them, changing the filenames. Run the .sql script you now have (provided you have created a second rollback segment in the system tablespace first) Run the import again, ignoring any errors that may arise.

Hth,
Sybrand Bakker, Oracle DBA

"Tim" <who_at_at_my-deja.com> wrote in message news:2y%h5.6827$hg1.482284_at_news-west.usenetserver.com...
> 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 Thu Aug 03 2000 - 00:00:00 CDT