You saved me! It was my network adapter that kept causing the error earlier!
@-pljfb-25 күн бұрын
my man thank you so much indians always best
@darkoandric4096Ай бұрын
Works! Thanks!
@Marshal098Ай бұрын
Thanks
@aXsc6_l2 ай бұрын
good video short and useful
@manimeena-xh6xm2 ай бұрын
Sir I need Oracle 11g report calling &coding video ,do you have this video?
@patrykbarankiewicz61864 ай бұрын
Can I do it on amd cpu?
@SubhroneelGanguly3 ай бұрын
This is for MacOS for Intel.
@franciscocorbalan93414 ай бұрын
Thanks a lot, i have been spent a lot of my time finding any solution, your video help me. Great!!!!!!!!
@adlenemenai5 ай бұрын
thanks for this solution
@Domanica5 ай бұрын
Bro thanks so much!! I had to force restart my PC almost 7 times! LOL
@zenchen围棋17125 ай бұрын
really great, Will try that thanks !
@2112pjfran7 ай бұрын
Do you have the script for Mac OS Sonoma?
@SubhroneelGanguly7 ай бұрын
Still not successful in installing Sonoma. Will update as soon as done
@YouTube2ndOfficial8 ай бұрын
bootlooping
@SubhroneelGanguly8 ай бұрын
Keep on trying. If don't work. Go to disk utility and erase the disk and reinstall. Alternaly could increase you Ram
@YouTube2ndOfficial8 ай бұрын
booting into verbose mode on startup
@enescivelek33698 ай бұрын
So how can we add an mssql database to mysql phpadmin?
@SubhroneelGanguly7 ай бұрын
I didn't understood your question. You cannot add msssql database to mysql database and if you are trying to connect to mssql database through phpmyadmin it's not possible. Though you can connect it using mysql workbench or oracle sql developer using external driver.
@enescivelek33697 ай бұрын
@@SubhroneelGanguly When I use Mysql workbench, I can transfer the database in MSSQL to MYSQL, but I do not know how to use the database in Mysql Workbench in a project.Or if phpmyadmin is used on a server, I have no experience on how to use Mysql Workbench. I solved my problem through 3rd party software, but they are also paid.
@SubhroneelGanguly5 ай бұрын
MySQL workbench is an interface. Database don't reside in MySQL workbench. If you want to use MySQL in a project you have to use data adaptor, like MySQL connector or MySQL jdbc or odbc driver.
@mrissmann9 ай бұрын
Like that you kept the mistakes in your recording since we will run into the same issues.
@gowealth24789 ай бұрын
Hello there! Are you ready to unlock new possibilities with dblink? I'm seeking your expertise to navigate through a little challenge I'm facing. Your assistance could be the lucky break I need. Mind lending a hand?
@SubhroneelGanguly7 ай бұрын
Expecting response if you are still on it.
@SteveF-nx2zd9 ай бұрын
I tried to use fputcsv but it's almost impossible, mch easier this way!
@Rawaz310 ай бұрын
thank you, works perfectly
@mhenley11 ай бұрын
This was super helpful. Very much appreciate you taking the time to document it.
@nastenkaoo Жыл бұрын
godfather :)
@biswanathbiswas7977 Жыл бұрын
Irritating.
@PeintiumMHX Жыл бұрын
what is that comment
@MikeMike-is2hl Жыл бұрын
Thanks Sir... Getting the "Data Modeler" from within "SQL Developer" was not intuitive.... File->Data Modeler->Data Dictionary->Import (around 1:35). Also, at around 3:08, Import to: panel... Select "New Relational Model"... key to getting the modeler with the Schema and Tables selected.
@ajiramadhanis9411 Жыл бұрын
hello sir, after migrating successfully. How you can login using GREENPLY_16? have you already create it before?
@محمودابوبكر-ك8ح Жыл бұрын
perfect
@Danjames-w4r Жыл бұрын
Thank you, it helped me. Can you partition by month only? I mean table will have only 12 partitions always, dates in the same month but different years still in the same partition?
@freddymora1815 Жыл бұрын
Excelente Muchas Gracias lo que necesitaba.
@patricklee1326 Жыл бұрын
Will the pk of the table also get migrated?
@SubhroneelGanguly Жыл бұрын
Yes
@comptegmail273 Жыл бұрын
will that synchronize the data between the databases?
@SubhroneelGanguly Жыл бұрын
I didn't understood what you mean by synchronization. It's a remote connection directly to the database not any replica.
@1spunch Жыл бұрын
how to convert dateserial to date?
@SubhroneelGanguly Жыл бұрын
Depends in what format your dateserial is. Suppose your date serial is in format yyyymmddmiss then taking an example like 20230509125600, to convert it to date use to_Date function like this to_date(20230509125600, 'yyyymmddmiss')
@tanphuchong3102 Жыл бұрын
If i want to configuring Linked Server in SQL Server to connect to Oracle database from pc to another pc how can I do ?
@SubhroneelGanguly Жыл бұрын
Process will be same. Make sure the remote PC is accessible. Add firewall rules for the port number, configure the tnsnames.ora with proper service name.
@neerajtripathy6526 Жыл бұрын
How to export the resultset of a query(joining multiple table) into excel file last day of each month using stored procedure and involve package
@SubhroneelGanguly Жыл бұрын
create a scheduler job, and call the procedure within the job. Inside the procedure you can set a condition like sysdate = lastday(sysdate) and if successfully executed add a flag into a table to check the export doesn't happens twice.
@arpankumarkar4895 Жыл бұрын
Hello sir how to edit view SQL query
@SubhroneelGanguly Жыл бұрын
Use create or replace view viename. Replace keyword update the view when you execute the ddl
@sameerahmad7592 Жыл бұрын
Mr.Ganguly, kindly let me know how haad you connected different SQL Schemas (DB2/MySQL, etc..) to the one SQL Loader...? Please, I would be thankful to you... Thanks & Regards Sameer Ahmad
@SubhroneelGanguly Жыл бұрын
Database link is used to connect to oracle database from other instances. What you are talking about is connecting to different database for which you need to add third party driver in Oracle SQL Developer application. I am sharing two videos for connecting to SQL Server and DB2. Take a look if it helps. kzbin.info/www/bejne/rYm1f56kbcqVpbs kzbin.info/www/bejne/eGSUh4N9oNd4m8U
@mstechnical19372 жыл бұрын
I want your WhatsApp
@fidafathima8322 жыл бұрын
very easy to understand the concept
@rocknshake2 жыл бұрын
well explained and clear, thank you. I have a requirement to migrate from sql (sql server 2019) to oracle 12c, I tried to migrate using sql developer 19.2 but it is not working. As per the sql developer notes till sql server 2008 are only supported. Can you please help me in this regard? Thank you.
@SubhroneelGanguly2 жыл бұрын
You suppose to use the compatible jar file. I will try to make a video on this give me some time
@rocknshake2 жыл бұрын
@@SubhroneelGanguly Sure, thank you. Sorry for the late reply I just saw the message as it automatically filtered to social in gmail. :(
@segicus2 жыл бұрын
Thanks!, it worked for me on the latest version of Microsoft SSMS to connect to Oracle database
@ahmadisultana67082 жыл бұрын
hi
@barshi2202742 жыл бұрын
very nice video, can you please give me access to this code, sent request, thanks
@SubhroneelGanguly2 жыл бұрын
Done!
@zhteja2 жыл бұрын
Thanks dear, I stuck at this point, unfortunately there is no good stuff available on internet about oracle, today second time i come on your page and my issue is solved Thanks again
@mayurjackson36742 жыл бұрын
Hi Bro can you please send me the source code I have asked for permission
@SubhroneelGanguly2 жыл бұрын
Done
@adileddaou593 Жыл бұрын
😊
@adileddaou593 Жыл бұрын
Hi mate, can you send me the source code please ?😊
Very nice, it worked very well! Thaks for your help!
@sivahanuman44662 жыл бұрын
Great video 👍
@userasdf15462 жыл бұрын
Error report - ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to perform a database operation without the necessary privileges. *Action: Ask your database administrator or designated security administrator to grant you the necessary privileges
@SubhroneelGanguly Жыл бұрын
if you have access to system administrator your have to provide this privilege grant create database link to username, where username is the user who is creating the database link
@anudipray44922 жыл бұрын
Will the stored procedure and functions also get migrated
@SubhroneelGanguly2 жыл бұрын
Yes incase of full export
@onyedikachiadigwe89952 жыл бұрын
How do I get my root password
@SubhroneelGanguly Жыл бұрын
If you are working from database server login to sqlplus using this command. sqlplus / as sysdba. After login in type the command password sys. Then type your new password, retype password. and it's done