Re: copy tables from one user to another

From: Nuno Guerreiro <nuno-v-guerreiro_at_invalid.telecom.pt>
Date: Wed, 09 Dec 1998 17:14:52 GMT
Message-ID: <366faf78.25036420@news.telecom.pt>

On Mon, 07 Dec 1998 00:59:10 -0500, Kevin <chance5_at_mindspring.com> wrote:

>Does anyone know that command to copy all tables from one user to
>another?
>

COPY - That's exactly the name of the command. It's a SQL*Plus command (not SQL).

Type HELP COPY in SQL*Plus and you'll get its syntax and description (hopefully)

But if you want to copy the entire collection of tables, you'd better use import/export.

Good luck,

Nuno Guerreiro

---

As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Wed Dec 09 1998 - 11:14:52 CST