We have an old DB server, running Oracle 11g on Solaris.
We also have a new DB server, also running Oracle 11g, but on RHEL.
We want to move a schema to the new db - but we need everything it refers to moved too. The data /tables can be moved easily enough, but then there's sequences, stored procedures, db types, views and maybe other things I'm not aware of yet.
The original schema contains different objects assigned to specific tablespaces and we need the same assignments in the destination server too.
What's the best way to accomplish this?
It looks like expdp/impdp can export and import other object types, but I can't find a list of the types to include, or how to say "everything".
Also DBMS_METADATA.GET_DDL looks useful, but again I can only find examples for specific object types and I want "everything in the schema", ideally.