| Importing Oracle Dump [message #72053] |
Thu, 27 February 2003 00:34  |
Elavarasan
Messages: 7
Registered: January 2002
|
Junior Member |
|
|
Hi,
We got our Oracle 8.1.7 export dump, without the export log. Now we are trying to setup the database server here with the dump. I've the following doubts in setting up the db.
1. Do we need to create the Tablespaces also? Or only creating the db name is enough?
2. The exprot was done by user DEL_ADM. So we have created the same user in our db here. What roles do we need to grant to this user, so that all the grants refering to system tables/views like v$parameter will work?
3. Some of the Snapshots in our dump is having reference to some remote databases. How to create the link? Do we need to create those link before starting the import? Or can we create those links after the import id done?
Since we are already running out of time, any immediate help on this will be greately appriciated.
Thanks in advance,
Elavarasan
|
|
|
|
| Re: Importing Oracle Dump [message #72056 is a reply to message #72053] |
Thu, 27 February 2003 06:00  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. YES.
u need to create the tablespaces, respected users
with access on the respected tablespaces etc.
2. IT is better to have DEL_ADM user replicated
(or just have all the rigths the DEL_ADM user
has in the source database).
3. I am not sure about the snapshots, any how u can recreate them later...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
