Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!16g2000cwy.googlegroups.com!not-for-mail From: "sybrandb" Newsgroups: comp.databases.oracle.server Subject: Re: Cloning database, Unknown command 'DATAFILE' Date: 12 Dec 2006 05:41:43 -0800 Organization: http://groups.google.com Lines: 27 Message-ID: <1165930903.667476.318430@16g2000cwy.googlegroups.com> References: <4u7khrF1743hbU1@mid.individual.net> NNTP-Posting-Host: 192.33.238.6 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1165930909 7364 127.0.0.1 (12 Dec 2006 13:41:49 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 12 Dec 2006 13:41:49 +0000 (UTC) In-Reply-To: <4u7khrF1743hbU1@mid.individual.net> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 PXYBEBR003 Complaints-To: groups-abuse@google.com Injection-Info: 16g2000cwy.googlegroups.com; posting-host=192.33.238.6; posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC Xref: usenetserver.com comp.databases.oracle.server:418992 X-Received-Date: Tue, 12 Dec 2006 08:41:49 EST (text.usenetserver.com) On Dec 12, 1:10 pm, "Helmut Schneider" 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