This content has been marked as final. Show 1 reply
That's a bit tricky. Installer has a seed database, but touching that would be outside the scope of the license agreement.
There is probably a way to use rman, others would have to contribute on that method I've not used it much.
But I have done quite a few tablespace transports, the process is straight forward as long as all the requirements are met.
Set up a new tablespace, set up your schema user(s) defaulted to that tablespace, do the DDLs for tables, indexes, sqlloader or insert SQLs to get the data the way you want, then set the tablespace to read only, then expdp the tablespace metadata.
At a target database, the schema user(s) need to be created, make the tablespace datafile(s) and expdp dump file available at the target, and impdp the metadata dump file.
See the 11g Admin doc on TTS: http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces013.htm#sthref1629