Printable View
Hi,
Is there anyway i can update all tables have column which has data called "user1" to "user".
my problem is i am trying to drop user "user1" but has referential constraint on lots of table .So i disable all constraint drop user "user1" and create user "user" but now i am not able enable constraint.
Quote:
Originally posted by kpate
Hi,
Is there anyway i can update all tables have column which has data called "user1" to "user".
my problem is i am trying to drop user "user1" but has referential constraint on lots of table .So i disable all constraint drop user "user1" and create user "user" but now i am not able enable constraint.
Hmmm. I am not sure if I understand your requirement.
But if you wanted everything of USER1 to remain "as-is" and that it's just the question of changing the name of USER1 to USER (Can you create a user with the name "user" ?:rolleyes: ) - Then you may do the following:
1)Export All Tables of USER1
2)DROP USER USER1 Cascade;
3)Create the new USER
4)Import the tables into the new USER's Schema
Does that help, not sure.
you will have to recreate the constraints...
as the constraints refer to the user1.table_name.column_name but now its like user.table_name.column_name
now as the user1 no longer exists the constraints cannot be enabled...
HTH