Activity overview
Latest activity by teltest
I maybe should have said: Schema Compare for Oracle version:5.7.8.97 / comments
I maybe should have said:Schema Compare for Oracle version:5.7.8.97
Schema Compare slow when comparing more than one schema
Using Oracle Schema Compare works absolutely fine when comparing one schema in a database with the same schema in another.However, when adding on an additional schema - the process takes hours - it...
Thank you for your reply. I wonder if the issue does not exist in your system because of the version of Schema Compare that you are using or because of the version of the database. We are using Oracle v19c. We fixed the issue at our end by re-creating the table without any INMEMORY parameters. / comments
Thank you for your reply.I wonder if the issue does not exist in your system because of the version of Schema Compare that you are using or because of the version of the database. We are using Orac...
Hi, I am using version 5.7.8.97 although a colleague is using version 5.7.17.1842 and is getting the same issue. It doesn't produce an error - its just that the script is malformed (and subsequently wont work) / comments
Hi,I am using version 5.7.8.97 although a colleague is using version 5.7.17.1842 and is getting the same issue.It doesn't produce an error - its just that the script is malformed (and subsequently ...
INMEMORY objects causing error
The script generated for a table with INMEMORY attribute is malformed.Replicate the issue by running this script to create the table then run Schema Compare -- Create TableCREATE TABLE some_table_n...
rguser12 said:
I managed to replicate locally the situation with a pound sign.
In fact TextPad does not do as well with encoding support compared to modern editors (for example, Notepad ++)
If you want to execute correctly the script generated by Schema Compare set the environment variable NLS_LANG to the value of .AL32UTF8 before running Sql Plus.
SET NLS_LANG=.AL32UTF8
Then execute the script. Hope this helps.
Many thanks for your help. You are very generous with your time. I think that the problem for me is that the file being produced by SchemaCompare is not in a format that I would like. I think also that this is something that I just have to live with. The issue itself could be as a result of the database being housed on a Linux server and therefore the script could be in a specific encoding or character set. I will probably get round that by running some Powershell Script on the output. / comments
rguser12 said:
I managed to replicate locally the situation with a pound sign.
In fact TextPad does not do as well with encoding support compared to modern editors (for example, Notepad ++)
...
I am using Windows 10. I use Schema Compare to Create a Script Folder. I follow all the default steps - this creates a folder structure named after the schema. This folder contains further folders (for each object type) - these now hold scripts for each of the objects. I have a Package Spec that contains a constant which is a pound sign '£'. c_sterling CONSTANT VARCHAR2(1) := '£';The file that has been produced seems to have changed this to '£' - This is only visible in certain editors (e.g. TextPad). However, f I run this script back into the database (for example using SQL Plus) - this line is changed to: c_sterling CONSTANT VARCHAR2(1) := '£';This now means that when this constant is used - it will fail because it has a length of 2 and not 1 as it has been defined. As another annoyance is that the files that Schema Compare produces seem to have a line ending of just LineFeed then the code is unreadable in some editors (such as Notepad). / comments
I am using Windows 10.I use Schema Compare to Create a Script Folder. I follow all the default steps - this creates a folder structure named after the schema. This folder contains further folders (...
rguser12 said:
What is the encoding of your files? I get such a result when I convert a file from UTF-8 encoding to ASCII. ( '£' => '£')
The file generated from Schema Compare appears to be "UTF-8" . It is also produced using Unix (LF) end of line characters. I believe that we need it to be "ANSI" using Windows (CR LF) for End of line. / comments
rguser12 said:
What is the encoding of your files? I get such a result when I convert a file from UTF-8 encoding to ASCII. ( '£' => '£')
The file generated from Schema Compare appears to ...
Schema Compare Character Set
I am running SchemaCompare from a command line. The command is:sco32.exe /source username/password@DB{MRS} /target .{MRS} /i:sdwqgvar /deploy /deployallobjects /report:"MRSPROD.html" /reporttype:...
David Atkinson said:
Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control without even having to consider the files at all.
I have looked at Source Control for Oracle. We are currently using TFS more as a backup and not as a release mechanism. When we start to use Source Control as a release pipeline then this might be of more use. / comments
David Atkinson said:
Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control w...