Oracle Import/Export

[ddd]

Hi all..

I have a question. I want to export entire database from remote server
and import it to a local one. But remote Oracle database runs on Unix
server and local is NT. Can it be done? What about table space that
export extracts in this format on Unix /directory/directory/users.dbf
where as in NT it is C:/directory/directory/users.dbf What are my
options?

[Pat Boivin]

Just ensure you are exporting in conventional mode, not in direct mode.

Also, keep in mind the size of the db you are exporting, if it is larger
than your local one your local one must have room to accommodate all the
data.

Regards,

Pat.

[Darren Eccles]

We've had relatively few problems with export.import between Oracle8.0 on
Solaris and NT. One thing we noticed is that LOBs cause a problem - this may
be something to do with the LOB locator still pointing to the original
storage on the remote drive rather than the local though not entirely sure.
Creating the LOB tables first on the local drive solves the problem although
this is a bit of a cludge. Also, beware of what versions of export/import
you use - I wouldn't be entirely sure that they are backwards compatible -
does anyone know?

ddd <win...@mails.idatanet.com> wrote in message
news:390A40C9...@mails.idatanet.com...

[Andrew Williamson]

Just create your tablespaces manually under NT (with same tablespace name,
different datafile naming obviously) and when the import runs, it will
ignore the CREATE TABLESPACE (with unix names) commands as they already
exist and then it will carry on and import into those newly created
tablespaces. If you know what I mean...

[Cherk]

Before import on NT, create tablespaces.
Import will be done with warnings, but all data will be imported !