How to download or place a copy of original tables with locked-permissions via remote connection in Oracle SQL Developer

exportoracle

N00b question here: I'm still learning Oracle SQL Developer. Although I understand how to query databases/tables remotely, I'm unable to manipulate the data due to permissions-basically I would like to download/export copies of the databases/tables so I can manipulate or adjust the data within the table.

I'm running Oracle SQL Developer on Mac OS X Yosemite and I'm unable to place a copy of the original table in my table space. I've consulted Oracle dox, but I believe these are dated because the GUI isn't as described. I'd appreciate any assistance. Thank you.

Best Answer

Evidently, this is how you copy tables from databases with permissions via remote connection to a local file-folder on Oracle SQL Developer (Mac OS X Yosemite):

Target database and expand to view tables.
Select desired table and right-click.
Hover-over 'Table' and select 'Copy'
A pop-up window will prompt to save copy table-name.

I've attached a screenshot below for clarification. Thanks!

Related Solutions

Oracle 10XE: Stop schemas seeing the all_users table

You have a few options, some of which will make your database unsupportable by Oracle (if you care!) as you need to fiddle with SYS owned objects.

The first option is to revoke select privs from everyone:

revoke select on all_users from public;

Then grant it back to certain users, plus all other internal Oracle users.

The 2nd option is to look at the source for the view, drop it, then recreate an altered version that supports your needs.

Another option that would trick casual users would be to create a table called ALL_USERS in each schema. Unless the logged in person explicitly qualified ALL_USERS (ie: SYS.ALL_USERS) they would get the resultset from the table in their own schema. This trick could also be done with a synonym pointing to a view that does:

select * from all_users where username = (SELECT sys_context('USERENV', 'SESSION_USER') from DUAL);

Not much else you can do with XE I'm afraid.

How to download oracle database to a remote server

Using WGET to download My Oracle Support Patches (Doc ID 980924.1).

wget --http-user=<username> --http-password=<password> --no-check-certificate --output-document=filename "paste the copied download address here in quotes"

Also there are a bit different instructions in https://blogs.oracle.com/supportportal/entry/use_of_wget_instead_of_downloa but I believe things a bit changed now when flash MOS page is retired.

Best Answer

Related Solutions

Oracle 10XE: Stop schemas seeing the all_users table

How to download oracle database to a remote server

Related Question