Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail From: Maxim Demenko Newsgroups: comp.databases.oracle.server Subject: Re: Can Data File be directly copied? Date: Wed, 12 Dec 2007 10:36:29 +0100 Organization: T-Online Lines: 23 Message-ID: <475FAB9D.1010406@gmail.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.t-online.com 1197452186 02 13266 vSmP1Yy1iDgsSIgr 071212 09:36:26 X-Complaints-To: usenet-abuse@t-online.de To: Saurabh X-ID: XRLOgvZJweoNTEu5FmOLz8m15vB2uDFOkZGQnuWyplWFUPh1N4rrYp User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) In-Reply-To: Xref: usenetserver.com comp.databases.oracle.server:438971 X-Received-Date: Wed, 12 Dec 2007 04:37:12 EST (text.usenetserver.com) Saurabh schrieb: > On Dec 12, 2:13 pm, one...@gmail.com wrote: >> On Dec 12, 4:32 pm, 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? >> you can transport tablespace > > how can a table spce be tranferred? > do we just need to overwrite the datafile on other server? Before you try just to overwrite datafile on other server, i encourage you to try to read the Utilities documentation at http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm If you after this reading still have specifical problems, you may want to post your detailed problem explanation, specify your Oracle environment/version and most likely you'll get kind of useful replies. Best regards Maxim