Oracle database import / export

[fbifido]

Too many reasons.

Manual creation of a database is not rocket science but has to be done properly, please check this step-by-step guide http://www.orafaq.com/node/2015

Create all the tablespaces you need to import data - please point them to cooked file systems; I'm assuming you do not want to tackle ASM at this time.

Hope this helps.

That was not a good example, that's windows, and that look allot simpler that when don in linux.

I don't get why oracle make this thing so badly. a full export has everything in it so why don't the import software just re-create the the database and all the data?

or even better make a program that can look at the backup and produce all the needed files to create the database,users and rights and just put it in a directory so you can edit it and then do a manual or automate database creation?

or can they make a backup converter program that reads the dump file and get what version exp was use and then convert it to the version that it is been imported to and fix the file location of all the files so it match how the current oracle database is created (not sure how to say that part)?