Is there any better documentation or a reference on how to use the Qualify name option when exporting a schema to SQL? I would like to export a subset of tables and I am guessing that this would be a way to do that.
If you enable Qualify Name, the specified name is used to qualify the object names in the generated SQL statements, e.g. with FOO as the qualifier and a table named BAR, the INSERT statement is generated like this:
INSERT INTO FOO.BAR ...
If you want to export just a subset of tables, select only the tables you want to export in the Object Types tree.