Create a Backup of a Table in an Oracle Database
Share
Read Time:17 Sec
I seem to have to look this one up each time…
The SQL statement below will create a duplicate of a table in an Oracle Database.
CREATE TABLE NewTableName AS SELECT * FROM ExistingTableName;
Hope this helps someone else.
Let me know how it worked for you or if you have improvements to it in the comments.
Author
Stewart Schatz
Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it.
Side Hustle: Owner/Operator of E1Tips.com
Location: Lancaster, PA USA
What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
More Stories
VirtualBox Fails After Windows 11 Upgrade (NtCreateFile failed)
After upgrading from Windows 10 to Windows 11, VirtualBox fails to start your Virtual Machine. You receive this error: NtCreateFile...
Quick Tip: WebLogic NodeManager Fails To Start As Windows Service
If your Oracle WebLogic NodeManager starts without issue when using startNodeManager.cmd but when configuring the WebLogic NodeManager as a Windows Service, it fails to start. The nodemanager.log file has the following entry: Native version is enabled but NodeManager native library could not be loaded
Quick Tip: Determine Active Directory Account Status From The Windows Commandline
Use the following command to Determine Active Directory Account Status from the Windows Commandline without Powershell or any special software....
Where Is Java Installed?
Below are a few commands that can be run to determine where Java is installed on each Operating System: Windows:...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
Acronyms Seriously Suck – Elon Musk
In May of 2010, Elon Musk sent out an e-mail to the entire SpaceX company: Acronyms Seriously Suck: There is...
Average Rating