Re: local copy of remote database -- how to solve this case?
- From: "Michel Cadot" <micadot{at}altern{dot}org>
- Date: Thu, 31 May 2007 06:08:22 +0200
"T-BAG" <T-BAG@xxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de news: 465df0ce$0$3799$c3e8da3@xxxxxxxxxxxxxxxxxxxx
| hello!
|
| is it possible to create "simplified" local copy of the remote database
| in an automatic/semi-automatic way? I don't need triggers, user roles
| etc., just tables and indexes placed at two local tablespaces.
|
| I am a beginner in databases and till now I only figured out how to copy
| data between two systems using SQLPlus COPY command.
|
| I tried to use DBMS_METADATA packet but I hardly can make it working,
| and the second thing is the incompatibility: local database is version
| 10g, remote version 9.
|
| To replicate remote structure locally I take the script for remote
| tables, modify tablespace names, and run it locally. It is time
| consuming (300 tables) and prone to my errors.
|
| So, here is my question: is there a way to make it faster and better? no
| triggers, roles, etc. just tables and indexes mapped into two local
| tablespaces.
|
| I would greatly appreciate your help and suggestions. any script example
| or solution will be helpful.
|
| thanks,
| T-BAG
Have a look at export/import tools.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm
Regards
Michel Cadot
.
- Prev by Date: Re: Comparison of Oracle commans Vs. SQL Server Commands
- Next by Date: Give you DBA the boots! Crack oracle system password for free Options
- Previous by thread: Re: local copy of remote database -- how to solve this case?
- Next by thread: Re: local copy of remote database -- how to solve this case?
- Index(es):
Relevant Pages
|
