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: How to rename a schema

Re: How to rename a schema

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 27 Mar 2003 04:56:38 GMT
Message-ID: <3E8283B7.5F930C35@telusplanet.net>


I'm not sure if it fits, but years ago I used to 'export' + 'import'. Can't remember the syntax right now, but 'import' allowed changing the owner (schema) and you could export without data to ensure the schema was clean. Check out the Utilities manuals (online at http://otn.oracle.com)

/Hans Received on Wed Mar 26 2003 - 22:56:38 CST

Original text of this message

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