1 person found this helpful
You can also go with the option CSSCAN. Check the below Doc for your Ref
Your proposal is quite straightforward and very helpful, I will try this solution however, there are other problems underneath the structure of the database and I strongly need migrating.
I 've implemented first step, but I couldn't implement the second step. I 've created the second step by using toad editor by clicking Create -> New Database but I can not connect the new database. I must connect new database in order to perform full import. How can I do this?
have your database created successfully(donot know abt the toad tool),Have you checked alert log file, what Error you get during connection
I do not get any error, I still connect to the old database.
Pl elaborate on what you mean by 'cannot connect to the second database' - what tool are you using and what error messages/code do you get ?
In view of the reasons mentioned above, I decided to create a new database via Toad for Oracle as depicted in the picture below:
I've mentioned this newly created database as second database.
I've set up the database and its technical parameters (including the nls_language settings ) in the dialogue box. What must I do in order to enter the newly built up database? This is the
concern, If I am able to do this, I can constitue the tables that I need.
Thanks in advance.
Message was edited by: 966347
First, if your applications run on Windows, do not use WE8ISO8859P9. Use TR8MSWIN1254.
Second, if you create a new database, the database is not necessarily immediately accessible to outer world. I do not know Toad and I have no idea if it performs all necessary steps required for the new database to be visible. For example, in the Toad itself, I assume you should create a new connection that references the new SID of the newly created database and use this new connection to connect. However, connections without a connection string use the ORACLE_SID setting in Registry to tell connecting applications which instance (database) to use. To change the database accessed with an empty connection string you need to modify Registry (unless Toad has an option to do this for you). If you want to connect without changing Registry, you need a connect string. This requires setting up Oracle Listener to serve the new database (unless default configuration is used and the database registers itself with the default listener). It also requires changing tnsnames.ora file to create an alias for the new database. Net Manager and/or Net Configuration Assistant can help you with this.
I wonder if Database Configuration Assistant would not be a better tool to create new Oracle databases.
Thank you for your reply Sergiusz Wolicki.