Tag Info

Hot answers tagged

1

I am not an Oracle expert, but I can answer from DB2 perspective, you may look for similar features/commands in Oracle. In DB2, you can achieve this by: Using Import command with INSERT_UPDATE option. You also have a choice to use MERGE statement to merge data between two tables. Hope it helps you.


1

Ok, I didn't realise that creating such an export file consists of two steps. First, an ordinary dump file must be created, then this dump file is used to create an sql file. Since I didn't have such a dump file, the script as posted would not work. Here are the two steps, so that an sql file can be created declare datapump_job number; job_state ...


1

This problem is related to timezone stuff. Did you execute the pre-upgrade (utlu112i.sql) scripts? And did you follow the instructions?


1

Just from Oracle side there is nothing to worry about. You could even do this operation during normal business hours. BUT! most Applications are not cluster ready. They cannot deal with this situation and will crash. All services are still available since they are migrated to the second node. But the session does not get migrated that's why the client will ...


1

du of asmcmd doesn't support this, just put it in a loop. $ dg=fra; for dir in $(asmcmd ls $dg); do echo $dg/$dir; asmcmd du $dg/$dir; done


1

In fact I too came here to build a sample DB for scott schema in Oracle_v11g. I couldn't find DBCA as told above, but on further search, I found a file called scott.sql. It had lines to create the needed DB. So I connected to Oracle as system and ran it - all the tables were created. Now I couldn't connect using Scott as Id. Changed the password in System ...



Only top voted, non community-wiki answers of a minimum length are eligible