Is there anyway to grab the schemas and triggers from an oracle database and import them into another oracle database(an Oracle TimesTen inmemory db to be precise)? I'm trying to setup an in memory database for testing purposes and need to replicate the production schema.
Have a look at Oracle Data Pump. Oracle docs are here. Tim Hall has a writeup here. You might consider the Network Import feature too, as described here.