Yes, using export to create your sample study archive works great. You can also find a few sample archives on labkey.org and checked into the /sampledata directory in our subversion repository.

We've been wanting to add support for Oracle external data sources... wouldn't be too hard...

Adam