| How can i copy tables !!! [message #373411] |
Mon, 16 April 2001 08:42  |
Akif Rehmani
Messages: 3
Registered: April 2001
|
Junior Member |
|
|
Hi,
I want to know how i can export and import an oracle table. The thing is that i have created some tables in my home Pc and i want to have them
in my university as well. Since its a time consuming time to create and enter records again
and again, Therefore tell me the best option.
As i am designing a database for a company i
also have to take copy those table there.
How is it possible.
Some say it is worth while trying export and import command
|
|
|
|
| Re: How can i copy tables !!! [message #373412 is a reply to message #373411] |
Mon, 16 April 2001 08:55  |
Krishnan
Messages: 18
Registered: October 2000
|
Junior Member |
|
|
(1) Export the relevant tables and remember the user name
(2) Copy that Export file into a disk for copying it inot another system
(3) use Import in the other system use fromuser ans touser clause of import.
As such you need to remember the username(schema) with which you exported and you must know the username(Schema) where the new table is going to reside. Before starting ensure that you have given DBA previlages to the Imported user then revoke the DBA previlages after the import is over and give the resource prevelage back to the importer.
-- Krishnan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
