Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export Question (Newbe)
Tim,
Are the database versions the same? If not make sure that you are going from a lower version to a higher one or at least one that is comparable. There may be objects in the one database that do not apply in the other. Most times migrations are going into a higher rev of the DB so this is not a problem.
Also file size of the dmp output is a concern. You can send the export
output through a compression stream so the file is smaller and easier to
move around.
In UNIX it would go like this:
mknod export.dmp p
compress <export.dmp >export.dmp.Z &
exp user/passwd file=export.dmp
Dennis
Tim Evans wrote:
>
> I'm faced with the task of exporting a 2Gb database from my Unix system
> ( digital ) to an NT Intel system. I was wondering if there was any
> major issues I should be aware of, and any reference material that might
> prove helpful.
>
> Any help would be greatfully recieved.
>
> Thanks in advance
>
> Tim
Received on Tue Jan 13 1998 - 00:00:00 CST