Copying a user from one database to another

I need to copy a user and everything that user owns, including data, from one database to another. The amount of data is limited to 100MB and less than 100 tables.

The old database is an ORCL standard db, the new one is customized. I have both SIDs running at the same time, at the same NT box. Must customers are running 8.0.5, some 8.0.4

I need to copy all data, tables, constraints, views, procedures, triggers, sequences etc.

In the new db data must go into the new tablespaces.

Can I do this with exp80? What parameters do I need? Anything else I need to remember?

My procedure for creating the new db is this:   Create services using oradim80
  Create database
  Run catalog and catproc
  Create tablespaces
  Create user

Thanks
Peter Received on Tue May 04 1999 - 06:56:48 CDT