Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

import export dump of ASM database

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
ramavenkatesa
Asked:
ramavenkatesa
  • 2
1 Solution
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
There is nothing wrong  if u get object already exits.

finally the import should tell that

import was successful with warnings is acceptable.

0
 
ramavenkatesaAuthor Commented:
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
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now