If you mean copy Unix files onto Windows host, create Oracle services, then startup the instance with the Unix datafiles, no (or at least not without a fair amount of hacking).

If you're thinking of tablespace transport in Oracle10g, it is supposedly possible (I've never done it, but I've heard horror stories from colleagues who tried and claimed it didn't work).

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1322 and look for the section titled "Moving Databases Across Platforms Using Transportable Tablespaces" for more info.

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Shekhar Shinde [mailto:oracledba-ezmlmshield-x67648593.[Email address protected]
Sent: Wed 11/28/2007 8:37
To: LazyDBA Discussion
Subject: Help needed



Hi all,

if i have datafiles on unix.can i create a window based db with the same
datafiles.




Oracle LazyDBA home page