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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
