My Oracle Diary: January 2013

Tuesday, January 29, 2013

Loading records from one oracle database to another using oracle sql developer tool

The source and the destination databases are in different OS platforms. go to table->data(record) In one of the records, do a right click click on "export" tick 'export data' format: insert line terminator: environment default save as single file browse and choose the destination folder to place the output file Encoding: Cp1252/default click next click finish you will see a script click on "run script" Connection: destination connection click "ok"

Sunday, January 27, 2013

Data conversion from sql server to oracle using SSIS package

If you want to load more than 50,000 records using SSIS export/import wizard, the performance will decrease. go to start, you can find "SQL Server Import and Export Wizard". Click on it.

Saturday, January 26, 2013

Oracle 11g installation on windows

get csi number to get access to metalink website download the oracle 11g software from metalink extract the zip folder(s) after extracting, you will find a folder named "database" if there are 2 zipped folders, extract both of them still you will find only 1 folder named "database", but extracting both the zip files are mandatory make sure whether the software is compatible with the computer in terms of bit ie., 32 or 64 bit make sure whether you have the necessary permissions to create files in windows make sure whether you have permissions to access the registry no need to have hummingbird exceed or xmanager or xming as it is windows OS Inside the "database" folder click on "setup.exe"

Friday, January 25, 2013

SQL Developer Installation

Extract the zip file You will find a folder called “sql developer” in the extracted location Double click on it There, you will find a file named “sqldeveloper.exe” Double click on it

Click TEST, you should find the status to be success. Then click on “connect” You will find the schema called “example”

Thursday, January 24, 2013

SQL Server 2008 R2 Installation

go to this website and download the sql server 2008 management studio http://www.microsoft.com/en-us/download/details.aspx?id=22985&hash=uODFOHNf2waeiEVMWyrQEMDB5quislZwUZ4Ge4pJOf2rudke1XpIzXISqw1PIfOfcaeFEhy73OC5daCNYDfaGA%3d%3d if the windows is 64 bit, then go for the first file, else go for the second file.