Re: Copy a complete database

In article <3da69f26$0$45998$8fcfb86b_at_news.wanadoo.nl>, Joran <jeugdbescherming_at_wanadoo.nl> writes:
>Does anyone knows how to copy a complete database?
>Or a tutorial for this?
>
>I'm sick of waiting for the DBA-er all the time.
>
>Joran
>

Full copies of databases can be made in several ways

1- If hardware and OS compitable systems are involved full file copies can be done

2- For non-compitable machines exp full=y and imp full=y into a compitable version of Oracle (same or higher level) can be done. This duplicates the objects but not necessarily the physical structure. See the Utilities manual chapters on exp and imp. Object pre-creation and use of ignore=y parameter or allocation of tablespaces of the same name as existing tablespaces required for a clean successful import.

3- Data can be extracted via sqlplus and programs into flat files and reloaded via sqlldr or programs into new instance or a different db. Obviously you would need to have the same or similar tables defined to be reloaded.

I have a sign at my desk that says "Lack of planning on your part does not constitute an emergency on my part." It usually takes several days to several weeks to write a program so if you need time to do your job perhaps the DBA needs time to do their's. Your best option might be to try to submit your requests in advance of need so the DBA can have them ready by the time you are ready to code/test.

HTH -- Mark D Powell --   

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net