1
vote
1answer
24 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
0
votes
0answers
17 views

Software for creating DB alter script that ONLY uses DDL scripts

I am looking for a software which can compare two databases by ONLY using DDL script (i.e. I dont want to create a schema but rather do it on the fly). Is this possible ? Any ideas ?
0
votes
1answer
253 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
1
vote
1answer
2k views

Running Oracle script from Notepad++

Can we configure Notepad++ to run an Oracle script? I mean, once we wrote some script (assume a PL/SQL script containing a procedure), can it be compiled from Notepad++ editor itself? If it is ...
0
votes
2answers
1k views

DataStage Client 8.5 Installation Error on Windows 7

I am trying to install Datastage Client 8.5 on Windows 7 x64 and getting the below error: com.ibm.is.install.exception.ActionException: CDIIN5032E: Exception caught by ExecuteProcessAction.: ...
1
vote
2answers
285 views

How to pull huge table (80 millions rows) from Oracle into SQL DB or SQL dump via VPN

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is ...
1
vote
2answers
20k views

Creating a new user in Oracle Enterprise Manager 11g

I downloaded the Oracle VirtualBox VM containing Oracle SQL Server 11g and all their dev tools. (There's not much documentation along with it and I had to find fragments of info here and there.) ...