Sample Header Ad - 728x90

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 imp file=E:\Downloads\db_dispatcher\disp.dmp full=y The console shows me there was success. enter image description here 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. enter image description here 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 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