Dear :All
Oh thank now i know where to dig the information, i
will try to read this manual, ... i bet it should have
take me some time :)
thank
Jkean
- Mladen Gogala <mgogala_at_adelphia.net> wrote:
> Read about transportable tablespaces. It works like
> this:
> you export metadata, make a copy of the files in the
> place where the new database
> can access them and import the metadata. There are
> many limitations and stipulations.
> You really need to read the manual for this one. If
> you don't want to read the manual,
> contact Jimmy Hoffa, he can take care of any
> transport.
>
>
> On 2003.12.11 00:29, Kean Jacinta wrote:
> > Dear : All
> >
> > I have 2 database which is DB_A and DB_B. DB_A
> contain
> > schema A with the tablepace name as locus_tblspc.
> >
> > Now DB_B is a newly create database. I would like
> to
> > populate what ever is in schema A to DB_A . This
> > included all the
> table,procedure,trigger,synonym,grant
> > and most of all tablespace.
> >
> > How to do perform this , i have tried using export
> ,
> > but i am not able to export the tablesspace along.
> > What are fastest ways to populate all the object
> over
> > to DB_B .
> >
> > thank in advanced
> >
> > regard
> > JKean
> >
> >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > New Yahoo! Photos - easier uploading and sharing.
> > http://photos.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Kean Jacinta
> > INET: jacintakean_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kean Jacinta
INET: jacintakean_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 11 2003 - 00:29:25 CST
