Copy tables accross.

From: Florent <guelfucci_at_my-deja.com>
Date: Mon, 13 Nov 2000 13:40:24 GMT
Message-ID: <8uor07$p84$1@nnrp1.deja.com>

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.

Thank.
Florent.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 13 2000 - 07:40:24 CST