Currently i'm using Oracle 10g XE database and want to upgrade to Oracle 11g XE. When i try to run the installer, it fails because of running instance. I searched the internet and got to know i have to uninstall 10g XE before installing 11g. The problem is i want to retrieve my schemas in 11g. So as stated here, i tried,
exp system/<system_password>@<database> file=<user>.dmp owner=<user>
but i got the following error
SP2-0734: unknown command beginning "exp system..." - rest of line ignored.
i read on the internet i tried using
SQL> expdp system/password full=Y directory=DUMP_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
SP2-0734: unknown command beginning "expdp syst..." - rest of line ignored.
is there a way (preferably GUI) to just back up my data before uninstall so that it can be recovered after upgrade? I know complete databses can be put into an sql script for mysql using phpmyadmin. Does anything similar exist for oracle as well??
Is recreating a table using netbeans a good solution?