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

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 10 01:26:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.