Re: how to export oracle 9i NT table to another machine?

Well, you could do an export. Something like:

c:\> exp system/manager file=mydump.dmp owner=<yourname>

That produces a dump file which can be copied to your other machine, whereat you type:

c:\> imp system/manager file=mydump.dmp

(You might want to create yourself as a user on the new machine before trying this, if you aren't already created).

That's one way. The other would be to get a bit experimental and see whether transportable tablespaces could do the job. Strictly speaking, you aren't supposed to be able to transport between non-identical operating systems, and Windows 2000 isn't Windows NT. But you could give it a whirl nonetheless. That way, you only need copy a data file (ie, a dbf) over to the new machine and plug it in -provided your six tables are all housed in the one tablespace, of course.

Traditional export and import are boring, but functional. Transportable tablespaces would be more experimental (and fun) and a learning experience.

Take your pick.

Regards
HJR <xrati> wrote in message news:s8o4fukec8q4terfrjhfnekd8n8mbpn5if_at_4ax.com...
> I've been trying to learn oracle 9i at home on a Windows 2000 setup.
> I built six tables that I set up and work great. Each table has a few
> sequences and triggers. Now, I would like to transfer these to a
> machine at work that has a oracle 9i NT setup also. So, can I just
> copy some files to a zip drive, bring them to work and load them on
> another machine? If so, how? which files am I looking for? Thanks
Received on Mon May 27 2002 - 19:02:40 CDT