How to view databases and tables after 'imp' import using Oracle SQL developer
0
votes
1
answer
1311
views
Maybe that's a wrong form of answer...
The problem is:
I've got an Oracle database dump file (very old, created with imp utility)
At last, I've imported it. The command was
Now when I open my Oracle SQL developer and create any connection, I can't list my database (there must be at least one): in 'tables' section I only see this system stuff.
I the DB name should be 'meltshop', so I tried to find it in my Windows Services list. But there's none.
Oracle SQL developer 19, Windows 10. DB was created in 2009.
I am a newbie with Oracle(
The last year I worked with MySql database. Maybe here are any similarities?
I also have
imp file=E:\Downloads\db_dispatcher\disp.dmp full=y
The console shows me there was success. 

php
interface; the config shows me
$DBNAME = "/orcl.meltshop";
$DBLOGIN = "ml2_rt";
Instance, version, etc.:
select instance_name, host_name, version from v$instance;
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION
-----------------
xe
DESKTOP-T6U2873
11.2.0.2.0
The log of my last try:
google disk
Asked by Victor Gorban
(101 rep)
Jun 26, 2019, 01:21 PM
Last activity: Apr 10, 2025, 12:06 AM
Last activity: Apr 10, 2025, 12:06 AM