Solved

import export dump of ASM database

Posted on 2010-11-12
3
974 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

774 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