Home » RDBMS Server » Server Utilities » how to change the table_name in oracle
how to change the table_name in oracle [message #74121] Wed, 15 September 2004 09:54 Go to next message
Luis
Messages: 29
Registered: November 1999
Junior Member
I need to change the table_name when i export a table .dmp

example table t11 to t20 in a file clientes.dmp when it was exported

Report message to a moderator

Re: how to change the table_name in oracle [message #74122 is a reply to message #74121] Wed, 15 September 2004 16:06 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you can only rename the table in the database, so you'd need to rename it before you export it or after it's re-imported. Depending on the table size, you could also:
create table A as select * from B;

You'll need to consider indexes and constraints too though.

Report message to a moderator

Previous Topic: DDL for Procedure, Triggers, Function, Packages
Next Topic: Migration Workbench HANGS!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:06:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.