Solved

import export dump of ASM database

Posted on 2010-11-12
3
983 Views
Last Modified: 2012-06-27
I have a database test1 (10.2.0.3). ASM version is 10.2.0.4

I am building a new server.
-- i have installed the software & ASM version 10.2.0.3
-- i have created a database called test2

I tried to take export of test1 & import in test2. I have got lot of errors.

then I tried, creating DDL's of tablesspaces & users in test1 -- I created them in test2

when I am trying to import the export dump.I am getting lot of errors like object already exists.

am i doing anything wrong here?  can anybody point me to links ??

0
Comment
Question by:ramavenkatesa
  • 2
3 Comments
 
LVL 12

Expert Comment

by:praveencpk
ID: 34126570
There is nothing wrong  if u get object already exits.

finally the import should tell that

import was successful with warnings is acceptable.

0
 

Author Comment

by:ramavenkatesa
ID: 34135440
can i be assured that i have all the data in the database?? how can I ensure all the data is there in the target db?
0
 
LVL 12

Accepted Solution

by:
praveencpk earned 500 total points
ID: 34142492
you can check total number of tables got imported...

if you are created a log file at the time of import you can check the log file, it gives you all the details....
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question