OraFAQ Forum: Server Utilities » Importing Oracle Dump

Home » RDBMS Server » Server Utilities » Importing Oracle Dump

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Code: [Select all] [Show/ hide]

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...

Report message to a moderator

Previous Topic:	Creating new table
Next Topic:	field length issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 14:10:06 CDT 2025