I have started working with Oracle and I was recently tasked with importing a data pump export to a different schema. Once all the required roles were created and the correct REMAP_SCHEMA option was sorted out* I was left with one interesting problem. Everything remapped properly except triggers. The trigger name was remapped correctly but the target table still referenced the old schema.
Failing sql is: CREATE TRIGGER "NEW_SCHEMA"."TRIGGER_NAME" BEFORE INSERT ON OLD_SCHEMA.TRIGGER_NAME ...
I'm surprised that something this obvious would go unfixed.
**note Multiple schema remaps are done as follows:
alter table tablename change oldname newname varchar (10);Instead I have to use some sort of SQL Server procedure sp_rename
sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'
Here's a tip for copying a database in SQL Server 2008 (maybe other versions) via the Copy Database wizard.
When I initially tried the wizard it failed with
Message: Access to the path 'E:DataMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATANEWDATABASENAME.mdf' is denied.
In this case the NETWORK SERVICE was not able to create the new MDF file. I had to do add this user with FULL CONTROL to the MSSQLDATA directory and the wizard ran with no complications.
- Navigate to data folder
- Right click -> Properties
- Click the Security tab
- Click the Edit button to change permissions
- Click the Add button to add a new group or user
- Search for "NETWORK SERVICE" and click Add
- Click the Full Control checkbox for the newly added user
In case you're trying to find the wizard, right click the database, pick tasks, then Copy Database.
I want to switch accounts on my Galaxy Note 10.1, so my wife can use it on a trip she's taking, but I want to re-install the same apps. Since it's not rooted at the moment, I have to reset to factory defaults to switch Google accounts which would erase everything I have installed
In order to restore my installed apps and data after resetting, I'm using ADB (Android Debug Bridge) to backup my device. The backup command looks like this:
adb backup -apk -shared -all -f galaxynote.ab
For this particular device, if I didn't enter a password it would create an empty backup file.
Once this is done, I can reset the tablet and then run:
adb restore galaxynote.ab
And my apps are back but using a different Google account.
My plan is to eventually flash the Note 10.1 with Android 4.2 so we can have multi-users but that will have to wait for another day.