Problems and Troubleshooting Archives | Page 3 of 3 | Official TuningSQL.com Blog
Skip to content
  • TuningSQL.com
  • TuningSQL.com
Official TuningSQL.com Blog

Official TuningSQL.com Blog

Oracle Database SQL, Tuning, Features, and Toubleshooting

Category: Problems and Troubleshooting

  • Home
  • Oracle
  • Problems and Troubleshooting
  • Page 3

How to Set a Sequence Value in Oracle

July 24, 2019December 27, 2023 Kaley Crum

If you are running a version of Oracle that is prior to 12.1, there’s no “easy” way to set a sequence value. This changes in Oracle 12.1 though; you can simply issue the ALTER SEQUENCE .. RESTART command to set… Read More

Oracle, Problems and Troubleshooting, Scripts and Queriesnextval, oracle, sequence, set sequenceLeave a comment

ORA-14047 When trying to rename a table

July 22, 2019August 13, 2020 Kaley Crum

A convenient way to rename tables in Oracle is to use the RENAME command. For example, However, if the object that you’re trying to rename does not exist in whatever your CURRENT_SCHEMA is currently set to, then you can’t use… Read More

Oracle, Oracle Error Messages, Problems and Troubleshootingalter table rename, ora-14047, oracle, rename tableLeave a comment

ORA-01439 When trying to change CHAR to VARCHAR2

July 22, 2019August 13, 2020 Kaley Crum

I recently had a coworker ask me about a strange situation: They were trying to modify a column on a table to go from a CHAR(4 BYTE) to a VARCHAR2(5 BYTE). Oracle, however, didn’t seem to want to cooperate. Oracle… Read More

Oracle, Oracle Error Messages, Problems and Troubleshootingchange char to varchar, modify column, ORA-01439, ORA-1439, oracleLeave a comment

Posts navigation

Newer posts

FREE Sql Tuning Tips!

Get FREE tips and tricks for FASTER Oracle SQL queries delivered directly to your email inbox!

Just a minute...

Awesome! You're subscribed!!

Recent Posts

  • When Statistics Help with Filters
  • How to Make a “God User” in Oracle
  • View Hidden Parameters in Oracle
  • KUP-01005: syntax error: found “hash” (How to fix on an External Table)
  • Finding mod(power(x,y)) for Larger Values

Categories

  • Approximate Query Processing
  • Arrays
  • Autonomous
  • Baselines
  • Bind Variables
  • Caching
  • Certification
  • Creating Users
  • Cursors
  • Custom Aggregation
  • Data Dictionary Views
  • Data Types
  • Database Objects
  • Day to Second Interval
  • DBMS_METADATA
  • DBMS_UTILITY
  • Dirty Hacks
  • Execution Plans
  • Explain Plans
  • External Table Problems
  • FORALL
  • Hash Clusters
  • Hash Joins
  • Hints
  • Keywords
  • Network Connections
  • NULL Values
  • NULL Values
  • Oracle
  • Oracle Error Messages
  • Oracle SQL Developer
  • Parameters
  • Pl/SQL
  • Pl/SQL Compiler Flags
  • Pluggable Databases
  • Pragmas
  • Privileges
  • Problems and Troubleshooting
  • Regular Expressions
  • Row Level Security
  • Row Source Statistics
  • Scalar Subqueries
  • Scripts and Queries
  • SQL
  • SQL Monitor Reports
  • SQL Plan Management
  • Table Definition
  • Table Statistics
  • Tuning/Efficiency
  • Uncategorized
  • User Profiles
  • Users
  • Version
  • Virtual Columns
  • Wrapping Pl/SQL Code
  • Writing Queries for Performance
Copyright © TuningSQL.com All rights reserved.
Business Cast by Axle Themes