Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!a35g2000prf.googlegroups.com!not-for-mail
From: Saurabh <online.skolte@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Can Data File be directly copied?
Date: Wed, 12 Dec 2007 01:18:27 -0800 (PST)
Organization: http://groups.google.com
Lines: 12
Message-ID: <d607424a-dfb8-4361-9249-d8957b685fcc@a35g2000prf.googlegroups.com>
References: <bb904def-af09-40ae-b301-fef4e99580b2@i12g2000prf.googlegroups.com> 
 <b229f2a3-a9c1-46aa-a297-0913f7cc85ff@s8g2000prg.googlegroups.com>
NNTP-Posting-Host: 124.30.221.10
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197451107 24348 127.0.0.1 (12 Dec 2007 09:18:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Dec 2007 09:18:27 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a35g2000prf.googlegroups.com; posting-host=124.30.221.10; 
 posting-account=-XUc3goAAADfxxZ3v5DjFqUmLPAxFh7b
User-Agent: G2/1.0
X-HTTP-UserAgent: Opera/9.24 (Windows NT 5.0; U; en),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:438968
X-Received-Date: Wed, 12 Dec 2007 04:18:27 EST (text.usenetserver.com)

On Dec 12, 2:13 pm, one...@gmail.com wrote:
> On Dec 12, 4:32 pm, Saurabh <online.sko...@gmail.com> 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?