i want to export a database (full schema) so that I can import the database to a windows 2000 server. The database is sitting on a unix-sun solaris box ver 8.. What are the commands...
I am a bit rusty at unix at the moment!
Cheers
E
Hi,
The exp and imp commands are pretty much the same on unix or windows...
To do a full export:
( the user can be any user with DBA role )
exp SYSTEM/passwd FULL=y FILE=database_export.dmp GRANTS=y ROWS=y
hiya
thanks, I thought as much,....
Also how to copy the file from the unix box onto my c drive?
I have created a test.dmp file and I can see it on the /home/oradev directory....
I would like tocopy it to a network drive? is this possible?
Cheers
E
You can share the /home/oradev directory using samba... or, more easily, just activate the FTP server on the unix machine ( see /etc/inetd.conf ) and transfer the file, using an ftp client on the windows machine...
Thanks a million, already feeling an expert.....
what do you do ?
E