Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_metata export all database with roles and grants
DBMS_metata export all database with roles and grants [message #229850] Tue, 10 April 2007 03:02 Go to next message
danijelv
Messages: 12
Registered: March 2007
Junior Member
Hi all,

I read a lot how to export data with dbms_metadata, i didn't found or i overlook.

I read in this forum how to export roles, but i didn't found how to export schema with tables, indexes,....in right order. It's possible to use one statement or more statements.

REgards Dani
Re: DBMS_metata export all database with roles and grants [message #229854 is a reply to message #229850] Tue, 10 April 2007 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is right order?
Why export does not fit your needs?
What do you want to export exactly?

What is your Oracle version?

Regards
Michel

[Updated on: Tue, 10 April 2007 03:12]

Report message to a moderator

Re: DBMS_metata export all database with roles and grants [message #229857 is a reply to message #229854] Tue, 10 April 2007 03:23 Go to previous message
danijelv
Messages: 12
Registered: March 2007
Junior Member
Right order:
- create tables,
- create indexes,
- create view,
....

I forgot to write with get_ddl('shema', 'shema_name') can i export everything what i need.
My oracle version is 10.2.0.1.0

Thanks for help.

Regards
Dani
Previous Topic: Inserting multiple varchar2 values into a single CLOB row
Next Topic: Table Code
Goto Forum:
  


Current Time: Mon Dec 05 14:59:58 CST 2016

Total time taken to generate the page: 0.08711 seconds