Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy a complete database
komsiikomsaa_at_yahoo.com (Eino Komsi) wrote in message news:<10b3c267.0210110645.61e051b_at_posting.google.com>...
> Use the "$ORACLE_HOME/bin/exp"-tool (use parameter full=y)
>
> after that, use the import tool...
After that, ask your DBA why all your objects are in the system tablespace. Put a cold cup of coffee on top of his head and watch it boil.
>
> regards, EK
>
>
> "Huebner, Matthias" <info_at_verkehrsberatung.net> wrote in message news:<3da6a6e1$0$21323$626a54ce_at_news.free.fr>...
> > Salut Joran,
> >
> > "Joran" <jeugdbescherming_at_wanadoo.nl> schrieb im Newsbeitrag
> > news:3da69f26$0$45998$8fcfb86b_at_news.wanadoo.nl...
> > > Does anyone knows how to copy a complete database?
> >
> > Fastest Way to do this very complex job will be exp(ort) from one instance
> > and imp(ort) into another instance.
> >
> > > Or a tutorial for this?
> >
> > See Oracle Documentation Export/Import
> > >
> > > I'm sick of waiting for the DBA-er all the time.
> >
> > I hope, he will give you the rights to do this.
> > >
> > > Joran
> > >
> > Cordialement
> > Matthias
jg
-- @home is bogus. Not to mention if he has weird stuff like create view force or cross-schema references...Received on Mon Oct 14 2002 - 16:34:42 CDT