| Partial schema replication without DBA privs [message #421922] |
Fri, 11 September 2009 18:06  |
wakula
Messages: 150
Registered: February 2008
Location: Poland
|
Senior Member |
|
|
Hello,
I'm a developer of some DB which gets updated from time to time.
For development purpose I would like to replicate the content of this production DB into development database.
I would like to perform selective replication of:
- some tables (with configuration data) and related indexes (only definition)
- definitions for other tables (excluding the content) and related indexes (only definition)
- triggers
- constraints
- code (packages and stored procedures)
Problems:
- I don't have DBA privs on the production DB (I can do almost all inside my schema)
- DB is running at SunOS 5.9 with user/group oracle/ora10g - my account does not belong to ora10g
- datapump can create a dump with privs not allowing me reading that dump
Any hints how can I make such replication?
|
|
|
|
|
|
| Re: Partial schema replication without DBA privs [message #421952 is a reply to message #421922] |
Sat, 12 September 2009 02:55  |
wakula
Messages: 150
Registered: February 2008
Location: Poland
|
Senior Member |
|
|
In such case I will be able to replicate data using DB-link or to dump schema DDL using PL/SQL and SQLPLUS - that seems to be obvious.
Previously I did that and have used SQLPLUS "COPY FROM TO" in order to copy data (and I worked with imp & exp as well). Hope that it helps if anyone else is looking for the same thing.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
