I have Oracle-8i database. If I make a dump file with export command option full=y, can I do:
1. Import the data for a 'particular user' from the export dump file by using fromuser=xxx touser=xxx into the existing database ( I delete the user cascade before )? Is there a way to import multiple users at the same time?
2. How can I use the export dump file and import data into a new database which creates all the stuff from the dump file? I suppose it expects to have users before hand. Can I avoid this issue?