Building new version of an application and its DB.
Old version is 184.108.40.206, new version will be 220.127.116.11.0
I'll create a target DB in the 9R2 system. New scripts will be run to create new versions of existing (8i) tables - the new tables have additional columns etc.
I want to export one schema only (so USER=username is in the parameter file). A user specific export does not export User definitions, according to the docs.
When I import into my target database will I have to manually recreate all the Oracle user accounts of the users, and grant all the privileges to them all over again?
I don't want to use a FULL=Yes parameter as I'm creating new tablespaces for the tables in my 9R2 scripts (and the table structures differ too of course).