For more information about Oracle (NYSE:ORCL), visit. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! Note that you cannot roll back a RENAME statement once you executed it. The new name must not be the same as another table in the same schema. RENAME AND OR MOVE A LOGFILE Details Sign In To rename a table, you use the following Oracle RENAME table statement as follows: First, specify the name of the existing table which you want to rename. RENAME AND OR MOVE DATAFILE(S) WITH THE DATABASE SHUT DOWN RENAME OR MOVE DATAFILE(S) WITH THE DATABASE OPEN You have multiple databases on the same machine and you need to rename certain database files to prevent collision and confusion. If the database is up and you try to shut it down normal or immediate, you get ORA-01116 ad ORA-01110. At startup, you get ORA-01157 and ORA-01110. You have moved or renamed a datafile at operating system level but forgot to rename it within Oracle. You have restored a datafile from backup, but the disk where it should normally be placed has crashed and you need to relocate it to a different disk. You want to move a database file to a different disk for performance or maintenance reasons. In many situations, a datafile or logfile must be renamed inside Oracle. Whereas the contents of the file remain valid, you need to define a new physical name or location for it.
Information in this document applies to any platform. Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.4 Įnterprise Manager for Oracle Database - Version 11.2.0.4 to 11.2.0.4
DOES CLEARING A LOGFILE RENAME IT ORACLE HOW TO
How to Rename or Move Datafiles and Logfiles
0 kommentar(er)
