Re: Import and export of oracle

"Robert Vabo" <rvabo_at_msn.com> wrote in message news:<3de721c2$1_at_news.wineasy.se>...
> What is the best way to import and export oracle databases (users) via a
> program ?
> Is it to use shell commands and imp/exp or is there some api call to use ?

Hi,

When you said "import and export oracle databases (users)" you ment only the list of users or all the object of users?

If its is Users and Their Data from one database to another say from production to test - then use export and import.

If its only the USERS that needs to be created on the other databse or for maintaining log in a ASCII file - then simple UNIX Shell Script using SQL would be handy.

Regards,
Sagi Received on Tue Dec 03 2002 - 18:38:52 CET