My World A Blog On All The Things That Happen In My Life

Captured this rainbow enroute home. :rainbow:Hypnotizing, this is.Back when paper manuals were a thing. Loved the @Diablo 2 manual. Must have read over hundred times to soak in the loreWent to Fatty Bao. Was good but not as hyped. Pretty expensive though.Ugadi lunch as prepared by @joshenoy. Bottom Left to top right -  kadgi chakko, tendle and bibbo upkari,daali, chana ghashiOne candle for every decade. #threeOyoSo, I opened the door earlier in the evening to let @joshenoy in and there she was standing with cake in one hand and flowers in the other :blush: #threeOyoTaken last evening over at Yemlur/Wind Tunnel connecting Road
Status » Grid 2 gameplay video - Faceoff run with the Nissan Fairlady Z: http://t.co/IiAPdIA9sS via @YouTube

Posts tagged import

Exporting and Importing An Oracle database from one schema/user to Another schema/user easily
on 01/12/2008 - like it?

Couple of days ago at work I was asked to create a new environment(schema, user) for specific application testing conditions. While that was no big deal, I was also asked to import all the data from existing production environment into a new environment – and I was in a bit of bother here – generally the whole importing/exporting is done by DBA’s not developers. While I knew the usage of exp and imp commands, creating schema would require stuff like tablespace creating, adding data files and more importantly – grants which I had NO clue on. So after a bit of experimenting and consulting with my fellow colleague Rupam, I finally managed to export and import the data. This post is on how-to go about doing it.

If you want to skip all the commands and all just get the import / export done in 1-click try Easy Dump Oracle 1.1 – a tool which I found on the database server after all the headbanging 😐

Anyways here’s a step by step  process on how you export and import the data – do note that Easy Dump Oracle can import data ONLY if required grants are given to the user and tablespace has been allocated. For that you need to follow the below mentioned steps.

(more…)

Tags: , , , , , ,