Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to empty XE database and re-create tables/fields from scratch?

751747Feb 5 2010 — edited Feb 5 2010

Hi,

I've installed XE database to port my VB6/Access application to it, and I know that XE is limited to one single database, so far so good. But I want to erase everything from inside this default database to create my own tables/fields from scratch. How can I do that?

I just want to have one single database file with some tables/fields inside it, and nothing else. The rest will be done through VB straight.

And what is the name of the default XE database file? Where is it stored? If I make a backup of this file, can I restore it after a crash in the future by overwriting the corrupted file? Is that this simple as Access is?

Sorry about those many questions and thanks for reading!
Roger.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2010

Added on Feb 5 2010

4 comments

3,352 views