Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!s12g2000prg.googlegroups.com!not-for-mail From: "luup2k@gmail.com" Newsgroups: comp.databases.oracle.server Subject: Re: Can Data File be directly copied? Date: Wed, 12 Dec 2007 03:30:39 -0800 (PST) Organization: http://groups.google.com Lines: 14 Message-ID: <2111d897-ca58-4e64-94ed-714cecca69dc@s12g2000prg.googlegroups.com> References: NNTP-Posting-Host: 195.212.29.67 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1197459039 18288 127.0.0.1 (12 Dec 2007 11:30:39 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 12 Dec 2007 11:30:39 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: s12g2000prg.googlegroups.com; posting-host=195.212.29.67; posting-account=Hga2pQoAAAAp5oR0y7y9zijODFCC-ito User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:438986 X-Received-Date: Wed, 12 Dec 2007 06:30:39 EST (text.usenetserver.com) On 12 dic, 09:32, Saurabh wrote: > hi, > can a data file be directly copied from one server to another? > import/export most trigeers are not imported, so Data file copy , can > it be an alternative to import/eport? the export/import utilities can export triggers... option trigger=y what is your problem?? what is the reason for copy a data file?? the transport tablespaces only is available in Enterprise Edition, and you must copy all datafiles for the tablespace version of oracle rdbms??