Re: Cloning database, Unknown command 'DATAFILE'

On Dec 12, 1:10 pm, "Helmut Schneider" <jumpe..._at_gmx.de> wrote:
> Hi,
>
> I'm trying to clone a database. I use (e.g. fromhttp://www.dba-oracle.com/oracle_tips_db_copy.htm):
> alter database backup controlfile to trace as 'D:\ctrl_old.sql' resetlogs;
>
> When I try to execute @D:\ctrl_old.sql I get an error:
>
> SP2-0042: Unknown command 'DATAFILE'.
>
> What did I miss?
>
> Thanks, Helmut
>
> --
> Please do not feed my mailbox, Swen still does his job well

Typically the output of alter database backup controlfile to trace needs to be edited as it contains redundant text on which it will fail.

-- 
Sybrand Bakker
Senior Oracle DBA