Tag Info

Hot answers tagged

1

It turns out the user had been granted other privileges by a different account as well as the one we use, so we were unable to see those privileges in ALL_TAB_PRIVS. We had to look in DBA_TAB_PRIVS, and sure enough, there were the other permissions. Thanks to all for chiming in!


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

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