In this blog, I’ll walk you through the need for Oracle and Snowflake and then explore two methods for migration: manual migration and using automated tools. By the end, you’ll have a clear understanding of how to seamlessly transition from Oracle to Snowflake, no matter your expertise l...
Oracle has again proved why it’s a leading player in the database market by releasing its latest version,Oracle Database 23c(code-named “App Simple”), for free on April 3, 2023. This is a bold step by Oracle that will disrupt the database market and make it the go-to database f...
and the last 2th column is "IP" of cut from tnsping output." >>$FILE_DBLINK1 echo "RESULT FILE NAME: $FILE_DBLINK1" echo "=== if had errors to contact weejar@gmail.com ===" echo "done."
Selecting Text In Action Now you see it, now you don’t! On a newer version of SQL Developer? A lot has changed since I first wrote this in 2012. Here’s what it looks like today, and probably since about version 4.1/4.2 time frame. You can also use ctrl+click to add additional ...
The first thing you’ll want to do is create an Oracle folder in your C: drive. You can do that by going to File Explorer and clicking on your(C:)drive in the left column. Then, right-click an open space and navigate toNewandFolder, and click. ...
One option is to fill this third column with a pre-insert trigger on the table instead of filling it via SQL*Loader. Then you could adjust the trigger when necessary and not have to change the control file. This may not be a huge improvement, since it still requires a DDL sta...
Oracle Database uses the data type of the column to convert the data into its final, stored form. Keep in mind the distinction between afieldin a data file and acolumnin the database. Remember also that the field data types defined in a SQL*Loader control file arenotthe same as the ...
sqlplus / as sysdba DECLARE file_name VARCHAR2(256) := 'test.lst'; file_text VARCHAR2(100) := '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'; file_id UTL_FILE.file_type; BEGIN file_id := UTL_FILE.fopen('/tmp', file_name, 'W'); ...
Export of request results in one column I use a script to write the results of the request to SQLPlus. But when I try to output the results to a file, the formatting is lost. Spool command: do not output SQL query to file I want to output the results of the request into a csv fi...
Add the TNS entry of the standby DB HOTBAKSB into tnansmes.local file on HOST_A. For creating standby DB using RMAN, we have to modify the backup script a little bit as follows: run { allocate channel d1 type disk format '/backup/db/finfam/sun/findba/Release12/sttest/hotbkp/new/...