| Export and import with cluster information. [message #166064] |
Tue, 04 April 2006 05:28  |
fahania
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
|
When exporting from 10g to 10g, does an SYSTEM export and an import as user (NOT system!) with DBA grants from that export mean that information about clustering from the exported database will be imported into the newly created database?
|
|
|
|
|
|
| Re: Export and import with cluster information. [message #166459 is a reply to message #166064] |
Thu, 06 April 2006 07:05  |
fahania
Messages: 2
Registered: April 2006
|
Junior Member |
|
|
Thanks for your response.
To be more detailed. Our aim was to copy a database instance, containing three users, from one machine to another. We did a System export with exp and got one export file. On the other machine we only needed to have three users and their data and we do not want to import the data as System. Therefore we did three separated imports as user. Before importing the necessary tablespaces and users where already created and the users doing the import do have dba grants. The question is however if any information about Oracle Clusters on the originating machine is copied by this manner to the destination machine, which was not intentionally. If you can give me any clue on this matter i would appreciate that.
|
|
|
|
| Re: Export and import with cluster information. [message #166884 is a reply to message #166064] |
Mon, 10 April 2006 02:49 |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
Have a look at this table. You see "User Mode" include Clusters.
I suggested that you can transport tablespaces by using transport_tablespace options if the prerequisite is met.
Table mode
----------------------
Table definitions
Table data
Owner's table grants
Owner's table indexes
Table constraints
Table triggers
User Mode
-----------------
Table definitions
Table data
Owner's grants
Owner's indexes
Table constraints
Table triggers
Clusters
Database links
Job queues
Refresh groups
Sequences
Snapshots
Snapshot logs
Stored procedures
Private synonyms
Views
Full Database Mode
------------
Table definitions
Table data
Grants
Indexes
Table constraints
All triggers
Clusters
Database links
Job queues
Refresh groups
Sequences
Snapshots
Snapshot logs
Stored procedures
All synonyms
Views
Profiles
Replication catalog
Resource cost
Roles
Rollback segments
System audit options
System privileges
Tablespace definitions
Tablespace quotas
User definitions
ALex zeng |Skype me: hans9zeng
[Updated on: Mon, 10 April 2006 02:55] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
