I have a 350 GIGA database with about 5000 tables, 50 tablespaces, and 500 schemes (or users).
I want to create a new database for developers which will contain all the tables,tablespdces,users and other objects (views, constraints, etc') but without the data in the tables ( so it will be a lot smaller) , only in some few tables.
what are the for and against using full export/import with full = Y and rows = N (can I do it??), export the scemes one by one,
or by extracting the ddl of all the objects and tablespaces, and users. and create the entire database by ddl scripts.n (remember I have 5000 tables, views, triggers, constraints etc')
I know the Oracle docs, so please don't copy and paste it.