hi! if it's just a few tables you can use copy
copy from x/x@db to y/y@db create <table_name> using select * from <original_table> if thats not handy i would EXP the scheme and import it with imp y/y@db file=</path > fromuser=x touser=y then drop the old scheme regards daniel [EMAIL PROTECTED] wrote: > > Hi > I have a user with a schema and want to move that schema to another user. > I don't need the original user after the change > > Can I do this without an export/import. > All data and tables in this database I care about is in this schema > > Cheers > > -- > ================================================= > Peter McLarty E-mail: [EMAIL PROTECTED] > Technical Consultant WWW: http://www.mincom.com > APAC Technical Services Phone: +61 (0)7 3303 3461 > Brisbane, Australia Mobile: +61 (0)402 094 238 > Facsimile: +61 (0)7 3303 3048 > ================================================= > A great pleasure in life is doing what people say you cannot do. > > - Walter Bagehot (1826-1877 British Economist) > ================================================= > Mincom "The People, The Experience, The Vision" > > ================================================= > > This transmission is for the intended addressee only and is confidential > information. If you have received this transmission in error, please > delete it and notify the sender. The contents of this e-mail are the > opinion of the writer only and are not endorsed by the Mincom Group of > companies unless expressly stated otherwise. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --------------------------------------------------------------- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
