Re: database oracle9i structure/schemas

lakshmananl wrote:
> hello Gurus, i have a clarification. is there any scripts or tool to
> extract only the structure and schemas without the data of an existing
> database, and use the same for creating a new one. thanks in advance.

Try

exp schema_name/pwd_at_connect_string full=y indexfile=create_script.sql rows=n

This will create the create_script.sql

with all the ddl. You should be able to modify this script (for tablespaces etc) and use it to create an identical schema without the data.

Hth

Ravi Received on Fri Nov 18 2005 - 12:27:32 CST