Schema Export, Role Export. [message #493059] |
Fri, 04 February 2011 08:22 |
oruorainfo
Messages: 46 Registered: May 2010
|
Member |
|
|
Hello, am in the process of splitting an existing schema into several logical parts. This schema is fairly old and was inherited from a previous project. While most of the DDLs are available, the Schema DDLs and Role DDLs are missing. There are at least 3 Schemas and 2 Roles.
Is there any way please to Export the Schema and Roles definitions (in order to build the Create Statements) either through SQL Developer or by running a specific SQL statement to gather the full Schema and Role "Create" statements?
Goal: Essentially i am attempting to reverse engineer the existing Schema Create statements from the database.
Purpose: I will then use these as a model, to build my new Schema Create statements.
For Example am trying to generate from the Database:
CREATE SCHEMA { [ schemaName AUTHORIZATION user-name ] | [ schemaName ] |
[ AUTHORIZATION user-name ] }
Thank You kindly.
|
|
|
|
Re: Schema Export, Role Export. [message #493068 is a reply to message #493061] |
Fri, 04 February 2011 09:23 |
oruorainfo
Messages: 46 Registered: May 2010
|
Member |
|
|
Thank you LKBrwn_DBA, and my apologies for posting to wrong forum.
I did try your suggestion before posting (also tried with version 3), but neither allows the export of the "Schema Definition" or "Create statement" nor the "Roles" in the database.
What it does allow or generate are all the objects "within" the Schema.
What i require is the actual "Create Statement" for the Schema definition and the "Role". Not the contents (i.e. Objects).
Any other suggestions that i might try please?
Many Thanks!
|
|
|
|
|
|
|
Re: Schema Export, Role Export. [message #493078 is a reply to message #493059] |
Fri, 04 February 2011 10:51 |
John Watson
Messages: 8949 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You do know that CREATE SCHEMA doesn't actually create a schema? From the docs:Quote:
This statement does not actually create a schema. Oracle Database automatically creates a schema when you create a user (see CREATE USER). This statement lets you populate your schema with tables and views and grant privileges on those objects without having to issue multiple SQL statements in multiple transactions.
|
|
|
|
|