When I do a import from another database have I need the same estruture of the source database in the target database?

For example, if my source database use ASM and my target database no, what have I to do before to make the import?

  • What happened when you try? – Michael Kutz Nov 5 '19 at 17:28
  • In the last time I received an error during the import. The error was about the creation of a tablespace and the datafiles. The erro said that the path of the datafile does not exist. For this problem I used the remap_datafile. But I wonder if is there another way to do it without this parameters. Mainly if there are several datafiles. – Danilo Neto Nov 5 '19 at 17:37
  • But in the last time I don't used ASM, it was file system of different machines. It was just a example. – Danilo Neto Nov 5 '19 at 17:40
  • 1
    There are several types of exports and imports used for different purposes (i.e. are we talking about a full database export? A table-level export? Something else?) so it is helpful to provide a bit more context. If you're trying to do an ad hoc copy of a table from one instance to another, I'd generally find it easier to pre-create the table on the destination database (making whatever DDL changes are appropriate to map to a different physical structure, character set, etc) and just import the data. But that answer likely changes if you're trying to pull in thousands of tables. – Justin Cave Nov 5 '19 at 19:00
  • Sorry, I forgot to say, but my scenery is a full export and import – Danilo Neto Nov 5 '19 at 21:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.