| oracle [message #70732] |
Thu, 18 July 2002 11:23  |
Hyma
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
|
how to copy a table in oracle along with its contents to a floppy
|
|
|
|
|
|
| Re: oracle [message #70754 is a reply to message #70732] |
Sat, 20 July 2002 01:39  |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
you can't store the table into the floppy directly, for this first you have to export the table
exp sunil@sunil buffer=10000000 owner=sunil tables=sunil1 consistent=y
then copy the .dmp into the floppy
if you want to access that table from other computer first copy the file from floppy to harddisk where you want to access the table and than run..
but before the sames user (sunil) must be exists in the other computer where you want to copy that table
imp sunil@sunil fromuser=sunil touser=sunil tables=sunil1
hope it will help you!..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
