Re: RMAN error: ORA-01031 Insufficient privileges
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 5 Dec 2012 15:07:31 +0000 (UTC)
Message-ID: <k9nnvj$38r$1_at_solani.org>
On Wed, 05 Dec 2012 04:47:14 -0800, gnewsgroup wrote:
Date: Wed, 5 Dec 2012 15:07:31 +0000 (UTC)
Message-ID: <k9nnvj$38r$1_at_solani.org>
On Wed, 05 Dec 2012 04:47:14 -0800, gnewsgroup wrote:
> Thank you. You shouldn't be surprised because I started by saying I am
> new to Oracle, please help by explaining the difference between a
> tablespace and a schema, which I have assumed to be the same.
You should use expdp to dump an Oracle schema. That utility is similar to non-transactional MS SQL backups. You are essentially dumping just the logical structure and the data, not doing a real transactional backup.
-- http://mgogala.byethost5.comReceived on Wed Dec 05 2012 - 16:07:31 CET