Renaming Schema (2)

Post by **admin** » Wed May 23, 2001 4:00 am

This is a topic for an orphaned message.

Post by **admin** » Wed May 23, 2001 4:00 am

It gets worse for DataStage. Even if you could move the schema, you would need to fix UV.ACCOUNT and the licensing information too.

-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Wednesday, 23 May 2001 10:49
To: philw@ardent.co.nz
Cc: informix-mv@oliver.com; informix-datastage@oliver.com
Subject: RE: Renaming Schema

Phil,

Bad news. The only legal way - and there is no illegal way - to rename a schema and tables is DROP followed by CREATE.

Recall that the schema name is in the header of the VOC file when the account is created as or coverted into a schema. Tables in the SQL Catalog can not be edited - they are internally marked "read only" and are only updated by DDL statements and VERIFY.SQL.

You can move a schema, then repair the damage with VERIFY.SQL, but you can not rename a schema.

Regards,
Ray

-----Original Message-----
From: Phil Walker [mailto:philw@gnosys.co.nz]
Sent: Wednesday, 23 May 2001 09:00
To: ray.wurlod@informix.com
Subject:

Hi Ray,

What is the easiest way to rename a schema and tables?

Any ideas?

Phil

Post by **admin** » Wed May 23, 2001 2:11 pm

Transferring a table across schemas and/or systems is a documented
process. Look for the chapter entitled "Transferring Tables Across
Schemas" in the UniVerse SQL Administration for DBAs manual. It gives a
step-by-step process for doing exactly what you wish. Not having used this
myself, you may have to do a little bit of experimenting to get it right.

Good luck!

At 12:00 AM 5/23/01, you wrote:
>It gets worse for DataStage. Even if you could move the schema, you
>would need to fix UV.ACCOUNT and the licensing information too.
>
>-----Original Message-----
>From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
>Sent: Wednesday, 23 May 2001 10:49
>To: philw@ardent.co.nz
>Cc: informix-mv@oliver.com; informix-datastage@oliver.com
>Subject: RE: Renaming Schema
>
>
>Phil,
>
>Bad news. The only legal way - and there is no illegal way - to rename
>a schema and tables is DROP followed by CREATE.
>
>Recall that the schema name is in the header of the VOC file when the
>account is created as or coverted into a schema. Tables in the SQL
>Catalog can not be edited - they are internally marked "read only" and
>are only updated by DDL statements and VERIFY.SQL.
>
>You can move a schema, then repair the damage with VERIFY.SQL, but you
>can not rename a schema.
>
>Regards,
>Ray
>
>-----Original Message-----
>From: Phil Walker [mailto:philw@gnosys.co.nz]
>Sent: Wednesday, 23 May 2001 09:00
>To: ray.wurlod@informix.com
>Subject:
>
>
>Hi Ray,
>
>What is the easiest way to rename a schema and tables?
>
>
>
>Any ideas?
>
>Phil

Post by **admin** » Thu May 24, 2001 12:59 am

Ive transferred tables satisfactorily. Ive even moved a schema. But I am pretty sure theres no way to rename a schema other than creating the new and dropping the old.

-----Original Message-----
From: Glenn Herbert [mailto:glenn.herbert@ascentialsoftware.com]
Sent: Wednesday, 23 May 2001 21:11
To: informix-datastage@oliver.com; informix-MV List
Subject: RE: Renaming Schema (2)

Transferring a table across schemas and/or systems is a documented process. Look for the chapter entitled "Transferring Tables Across
Schemas" in the UniVerse SQL Administration for DBAs manual. It gives a
step-by-step process for doing exactly what you wish. Not having used this myself, you may have to do a little bit of experimenting to get it right.

Good luck!

At 12:00 AM 5/23/01, you wrote:
>It gets worse for DataStage. Even if you could move the schema, you
>would need to fix UV.ACCOUNT and the licensing information too.
>
>-----Original Message-----
>From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
>Sent: Wednesday, 23 May 2001 10:49
>To: philw@ardent.co.nz
>Cc: informix-mv@oliver.com; informix-datastage@oliver.com
>Subject: RE: Renaming Schema
>
>
>Phil,
>
>Bad news. The only legal way - and there is no illegal way - to rename
>a schema and tables is DROP followed by CREATE.
>
>Recall that the schema name is in the header of the VOC file when the
>account is created as or coverted into a schema. Tables in the SQL
>Catalog can not be edited - they are internally marked "read only" and
>are only updated by DDL statements and VERIFY.SQL.
>
>You can move a schema, then repair the damage with VERIFY.SQL, but you
>can not rename a schema.
>
>Regards,
>Ray
>
>-----Original Message-----
>From: Phil Walker [mailto:philw@gnosys.co.nz]
>Sent: Wednesday, 23 May 2001 09:00
>To: ray.wurlod@informix.com
>Subject:
>
>
>Hi Ray,
>
>What is the easiest way to rename a schema and tables?
>
>
>
>Any ideas?
>
>Phil