Search code examples
oracle-databasedata-structuresclonedatabase-schema

clone oracle database without data

I want to clone my existing oracle database structure without data including packages, users, tablespaces etc. I read some methods but they all copied data as well. Is there anyway out in order to do this?

Thanks in advance.

Solution

  • Use SQL Developer > Tools > Database Export..

    On "Specify Data" do not include any tables.

    alt text

    Omit packages etc here,

    alt text

    Fine tune your selection here,

    alt text

    My trial export has not finished yet but I expect this will work.