Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Data File be directly copied?

Re: Can Data File be directly copied?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 12 Dec 2007 17:21:05 -0800 (PST)
Message-ID: <656297ff-0de5-4549-b83b-b540ba1a4bc9@d4g2000prg.googlegroups.com>


On Dec 12, 6:30 am, "luu..._at_gmail.com" <luu..._at_gmail.com> wrote:
> On 12 dic, 09:32, Saurabh <online.sko..._at_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?
>
> 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??

The default is for export to include the triggers with the table during an export. Where you traditionally run into problems is where references to tables/view in the trigger code do not exist in the target database possibly just due to the public synonym being missing or for necessary DML object permissions being absent depending on what kind of exp/imp process was used: full, user, tables=.

HTH -- Mark D Powell -- Received on Wed Dec 12 2007 - 19:21:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US