All geek questions in one place

Oracle: export only schemas

I have an Oracle 10g database, and now I need to export, if possible, only the schema.
(Only tables with an index, etc. Without data!)

Is this possible with exp / imp or do I need expdp / impdp?

greets

+3
source share
3 answers

This is possible when expusing the parameter ROWS=N.

10g documentation here .

Currently, preference is given to the data pump ; equivalent parameter CONTENT=METADATA_ONLY.

+6
source

, Oracle SQL Developer.

SQL Developer 4.0 " | ... , " DDL ", " "- . , ; , " ".

+1

schem2ddl oracle-ddl2svn bundle.

schem2ddl is a command line utility for exporting an oracle schema in a ddl script set. provide many configurations through basic command line options or advanced XML configuration

+1
source

Source: https://habr.com/ru/post/1772058/

More articles:


All Articles