I need your help. I had an requirement to compare db objects from QA instance to Stage instance, find out missing objects and syn up the databases. Import was done by DBA at our work location using impdp command as below. Only metadata was imported from QA to STG instance. After import few of db objects like materialized views, tables, triggers, package, procedure , views and indexes……..are missing. I had a requirement to compare db objects and syn up the objects in schemas in two databases based on last_ddl executed. But there are around 100 schemas with 1000's of db objects. What was the best and preferable way to compare and could some one explain me the process.
impdp system/xxxx dumpfile=dmp.dmp logfile=impdp.log CONTENT=METADATA_ONLY TRANSFORM=SEGMENT_ATTRIBUTES:n
I had used TOAD to compare the db objects but cannot compare schemas as i am looking for a output comparison based on last ddl executed.
There are custom schemas.
How can we compare custom schemas and seeded schemas using dbms metadata.get_ddl API…
Please suggest me how can i use pagination of first an last button pagination used in interactive report while using oracle application express.
Please suggest me code how can i send image to embed into email body while sending email and image getting from database column having blob type and embed image sees on all web email clients like gmail ,yahoo,rediff etc.
I've had a lot of trouble with installing SL 6.3; it booted to a screen with the stylized carbon atom image with no log on GUI. After a while I found that when I moved the mouse and saw a cursor move I could press "Enter" and get a log on GUI for the user that was created first. To log on as someone else I must click cancel to get the list of users. Then when the log on is completed there is just a screen with a background image. Again after a while I discovered that when the "busy" cursor changes to the regular cursor I can press META-P and get the desktop.
Is it really supposed to act this way?
How may it be changed so that when the system is ready for a user log on it will display the log on GUI?
On a successful log on can it be made to go directly to the user desktop?
I'm fairly new to LINUX with my previous experience being with Ubuntu.
Hello, I have Pentium D 3ghz with 2 gb ddr2 ram and nvidia 260 GTX. Sabayon consumes ~600mb ram on boot, without a single running program, where Fedora 17 Gnome 3 uses 200 – 300 mb for example…even Ubuntu 12.04 uses 400mb of ram. I`m talking here about 32 bit distros. I love Sabayon because it has all the software i like preinstalled and i like their community. So my question is, is it me the problem with Sabayon ram usage, is my PC spec or Sabayon by default has high ram usage for everyone…I would also ask should i go with 32 or 64 bit distros for my specs (RAM is not upgradeable, so 2gb i have is a max). Thanks in advance!! Cheers.
supporting oracle 11.2 for Ubuntu 12.04 64 bit ???
Can you use a kickstart file for a centos6 install on Hyper V – let us assume the centos6 iso (or network rpm location) has the required LIS iso's from MS.
Let us also assume the ks procedure in place already works on vmware
This question has lots of discussions on goggle, but still I am not able to figure out convincing answer. Basically I don't understand why should I host my database on ASM when the underneath storage device has needed RAID level. Why would I stripe/mirror my data in this case also using ASM? Well, one of the arguments is ASM is made/optimized for databases, but then again what’s the benefit mirroring/striping something which is also done at SAN level?
Somehow, I have found your site and you seem to be pretty knowledgeable about Oracle and other things. I hope you or one of your readers can assist. I am looking to broaden my education and want to learn Oracle database administration. I have checked Amazon and B
Scenario is this, a physical DB server is showing intermittent controller errors, our server admin is nervous (as am I) as this server is home to one of our more critical databases. Prepped another server and installed OS and 10.2.0.4, exact same platform as current production (I wanted to use the opportunity to go to 11G but vendor is not ready)
Switch over is this Saturday, I've already test restored a (user managed) online backup to the new server,rebuilt the controlfile, and applied available redo to it. I also took the opportunity to move some datafiles and the redo logs to different locations and multiplex the controlfiles better.
My plan is this, the day before the switch over, restore latest online backup from prod to new server, go through the usual controlfile rebuild and put in recovery mode and apply all available redo, then leaving in recovery mode. On switch day, bounce the prod db, startup restrict, switch logfile and shutdown. Copy latest archivelogs to new machine and apply, then open resetlogs. I'm thinking this is the fastest way with minimal downtime.
Just curious how you (or others) would approach this. I actually have time to do a direct datafile copy from server to server, but want to see how fast I can make this happen.