Profile cover photo
Profile photo
P Baniya
40 followers -
Dedicated to the people of DBA Republic!
Dedicated to the people of DBA Republic!

40 followers
About
Posts

Post has attachment
Public
Add a comment...

Post has attachment
Splitting Large File into Many Smaller Files
I was involved in a research project where I needed to provide a result set back to the requester. The file contained 7 million records which is big to send it over via an email. Even if I manage to send it to the requester via FTP or similar tools, the fil...
Add a comment...

Post has attachment
Finding Big File & Directory
In most companies, System Admin takes care of space issue on servers. They have tools or scripts to monitor the disk space usages to plan the storage accordingly and avoid server failure. I use Linux to host my Oracle databases in a sand environment and it ...
Add a comment...

Post has attachment
The Most Dangerous SQL Statement.
Why is there a need to Know, Learn and fully Understand "The Most Dangerous SQL Statements"? Let us compare these SQL statements with our life decisions we make. For every decision or action we make in life, we know the risk; that is how we take life's deci...
Add a comment...

Post has attachment
Export Import Utility
Who remembers the Export-Import definition from grade school? According to Investopedia, Export is a function of international trade whereby goods produced in one country are shipped to another country for sales or trade. An Import is a good or service brou...
Add a comment...

Post has attachment
How Complete Refreshable Materialized View Works?
This article is inspired by a question repeatedly asked to me: Why do you use a Complete Materialized View and not a Table or just a View? When the data is not available during refresh. This is a great question and I asked this once to myself and came to kn...
Add a comment...

Post has attachment
Questions Oracle DBA Asks
This is not about Angry Bird? It is about ANGRY DBA? Want to make them happy and get your job done? Whenever you are working on a issue that involves DBA I recommend you to provide as much information as possible. Below, I will list all the questions DBA mi...
Add a comment...

Post has attachment
Converting Excel data into a Flat file for Loading
I WISH, the requester sends the data file in the format we want and then the load is done in few minutes. Hey, it does not hurt to ask the requester back in a format that you need to make your load process easier but you may or may not get what you have req...
Add a comment...

Post has attachment
Read Only Table
Ready only table, what the heck is ready only table? Well, it is self explanatory by it's name. This table type allows user to SELECT but nothing else. Before we discuss more on READ ONLY TABLE. let's talk about the background and history of this type of ta...
Add a comment...

Post has attachment
Dropping Column
You all have dropped or added a column to an employee table. How long does that take? couple seconds, or may be milliseconds. Alter is DDL command therefore, it is not reversible once  the command is executed. The user can drop columns from a table owned by...
Add a comment...
Wait while more posts are being loaded