Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!l12g2000cwl.googlegroups.com!not-for-mail
From: "EscVector" <Junk@webthere.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: [ora10] Cloning database, Unknown command 'DATAFILE'
Date: 12 Dec 2006 11:38:34 -0800
Organization: http://groups.google.com
Lines: 23
Message-ID: <1165952314.032766.301220@l12g2000cwl.googlegroups.com>
References: <4u7khrF1743hbU1@mid.individual.net>
NNTP-Posting-Host: 72.165.244.50
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165952319 16193 127.0.0.1 (12 Dec 2006 19:38:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 19:38:39 +0000 (UTC)
In-Reply-To: <4u7khrF1743hbU1@mid.individual.net>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l12g2000cwl.googlegroups.com; posting-host=72.165.244.50;
   posting-account=YZW96w0AAABjQaJtmc4mPml4qWWrMr8V
Xref: usenetserver.com comp.databases.oracle.server:419040
X-Received-Date: Tue, 12 Dec 2006 14:38:40 EST (text.usenetserver.com)


Helmut Schneider wrote:
> Hi,
>
> I'm trying to clone a database. I use (e.g. from
> http://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

You probably edited the file and removed this line

-- STANDBY LOGFILE