We're downsizing from enterprise to standard because of licensing reasons.
When I do an import, i get:
. . importing table "TTICPR951101"
IMP-00020: long column too large for column buffer size (22)
IMP-00028: partial import of previous table rolled back: 858363 rows rolled back
At the top of the import, I noticed that the charsets are not quite the same:
Connected to: Oracle9i Release 188.8.131.52.0 - 64bit Production
JServer Release 184.108.40.206.0 - Production
Export file created by EXPORT:V09.02.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set export server uses UTF8 NCHAR character set (possible ncharset conversion)
1- Is the import problem related to the message "possible ncharset conversion" ?
2- Maybe a bad export via direct and unix compress .Z ?
3- How do I create a standard edition database that is exactly the same as my enterprise edition database so that when I import I will have the same charset, lang on both ends ?
I thank You in advance since this is driving me over the brink :-) and your help is greatly appreciated.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…