Re: Copy tables accross.

Florent wrote:
>
> Hi all.
>
> I hope you can help me with this problem. I am writing an application
> that connects to an oracle database using ODBC.
> I now need to have 2 databases one for test and one for production.
> How can I copy from one database to the other?
> I know the export/import function but I don't know the exact syntax to
> use and I need to transfer everything, the data, the structure, the
> indexes, the users etc.
>
> Can any one send me the syntax for the export/import function. And
> would importing a database create the schema or do I have to create it
> before I do the import.
> what else do i need to do before i import the data?
> I am using SQL plus.
>

1. login on the source machine
2. (sourcehost) > exp full=yes
3. copy expdat.dmp to the target host by OS utils
4. login on the target machine with a fresh RDBMS (same version!)
5. (targethost) > imp full=y

On the target db you have to prepare the tablespaces before importing. Users and all objects are created automatically.

Uwe

-- 
Uwe Schneider - WEB.DE AG  - Amalienbadstr. 41  - 76227 Karlsruhe 
F&E / Database Technologies - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"