Toad for Oracle Base Edition (64-bit)
Add-Ons:
25.1.20.5192
Tables, Sequence: Any way of not having "start with..." or force it to "start with 1", rather than using the current in source database?
Tables, Storage and LOB storage: I specify LOB Parameters: "No Storage Clause", yet the storage including the tablespace is in the file.
Constraints:
- Any way of extracting only Foreign Keys, or filtering by name the only method?
- I get 2 files for each constraint. One has table_name_FK.sql and the second has the name of the constraint. Contents of files are identical. Any way around it?
Sequence: There is a "Start with minval" option, but I see that you can't get to it if exporting DDL for a table with an auto-increment column. Or a trigger that uses a sequence. I'll fix.
Lob storage. This is working as designed. It's not really intuitive, but "tablespace" is not part of the storage clause. According to Oracle, it's in the "Physical Attributes" clause. Try switching between "All Lob Parameters" and "No Storage Clause" and you'll see the difference. Maybe "No Lob Parameters" or "Tablespace only" would be more to your liking. If you need a new option here, let me know.
To export only a specific type of constraint, see below:
I see tablename_NonFK.sql and constraintname.sql, but constraintname.sql actually creates the index, not the constraint so this is as-designed. If you don't want that, check "no constraint indexes" (in the screen shot above). Edit: I see that creates an empty file if you do that. I'll fix. Another option is use "Combine" (on the Objects & Output tab) to not make separate files at all.
Loading Referential only: I find the easiest way is to edit query:
That's very neat and also is a nice way of filtering object names, such as:
Would be nice to be able to save it as some profile for easy reuse.
I cannot see the difference between the 2 files I get when exporting.
Using a dos prompt, I can run del *FK.sql in the library. No harm done 
Lob storage. I've been asked specifically to create a bunch of create table... where every reference to tablespace is removed, so that local default is used at install time. Be nice if I don't have to edit dozens files after export.
Re: Constraints - I don't really have a big picture of what you're doing here. Are you extracting DDL for only constraints? Constraints with tables? If only constraints, you can filter them in the schema browser, then select all, right-click -> Export DDL. If constraints with tables, you don't need to specify constraints at all. Just specify the tables and check the options to include whatever kinds of constraints you want.
I cannot see the difference between the 2 files I get when exporting.
Sounds like maybe you are specifying both the table names and constraint names in export ddl, and that's why constraints are being exported twice.
Ok, so why not use "no lob params"? Is it that you want everything except tablespace?
