Articles

 Calculate size of table with BLOB column

Run this script from SQLPLUS: SELECT table_name, sum(bytes)FROM (SELECT s.segment_name AS...

 Can I import database? How?

Yes you can. If performing from your PC: make sure to copy & paste connection string that...

 Can I use a Datasource or DSN to connect to my database?

Datasources/DSN's are used to transfer information to and from a database, such as Oracle, Access...

 Can you add 'DBA access to my user name?

No, you can not have DBA rights on a shared server environemnt.

 Do provide the ability to use the UTL_SMTP, or UTL_HTTP packages?

Yes, any of our packages that includes DAD, pl/sql pr PSP support has ability to use...

 Do you backup my Oracle Database? How often?

Your Oracle database is backed up daily and you can ONLY go back 7 days to restore your data....

 How are the daily backup accessible (oracle backups)?

Backups can be written to your home directory, and can be accessed via ftp or ssh. You can go as...

 How can I check how much Oracle space I have used?

How can I check how much Oracle space I have used? Please login via sqlplus and execute the...

 How can I check if SSL installed correctly?

How can I check if SSL installed correctly? We found great tool that verifies ALL SSL...

 How can I create oracle database objects via control panel?

Currently, you cannot access Oracle from our control panel.  However, you may access Oracle...

 How can we change the ORACLE user password?

Starting from Oracle 8 you can just type password from SQL*Plus, or if you need to change another...

 How can we see the oracle database log?

For security reasons no user can see Database Logs

 How do I calculate tables size in Oracle?

select blocks, empty_blocks, num_freelist_blocksfrom   all_tableswhere  owner =...

 How to Delete All Objects for a User in Oracle?

Normally, it is simplest to drop and add the user. This is the preferred method if you have...

 How to list out the table size of all table?

How to list out the table size of all table?Login to the db via sqlplus and execute: SELECT...

 How to remove everything from my schema?

connect via sqlplus and execute: set heading off set pagesize 0 set feedback off set timing...

 How to resolve: ORA-29248: an unrecognized WRL was used to open a wallet

When using Wallet for paypal or Google checkout the following error may occur: ORA-29248: an...

 How to test Oracle and PHP connectivity?

Use this code as an example: replace scott with your user name replace tige with your...

 I am getting import error IMP-00013. Why?

While importing database you get the following errors: IMP-00013: only a DBA can import a file...

 I see some tables I deleted in my schema that starts with BIN$. How do i purge Oracle rycycle bin?

Please connect to the database via SQL/PLUS and issue the following command: PURGE RECYCLEBIN;

 I want to add a second Oracle user so another programmer can work on my server using SQL*Plus. Is that possible and how do I do it?

Please let us know what user name and password you need and our support team will create it for you.

 In order to use your hosting servie I would need to be able to automate the daily import of data. What options are available for loading data into the database? Can we use: sql loader? the Oracle import (imp) utility? external tables?

You can use sql loader, import or data pump utility.

 In order to use your hosting servie I would need to be able to automate the daily import of data. What options are available for loading data into the database? Can we use: sql loader? the Oracle import (imp) utility? external tables?

You can use sql loader, import or data pump utility.

 Send mail with UTL_MAIL

How to send mail with with UTL_MAIL 1. first you need to contact us to get acl opened. Please...

 Whats the conenction string to connect to database using perl 's DBI module?

In order to connect to our database from your perl script using dbi module, please use the...