Q:

How to publish oracle database? 

I have a .net website that I built, which is connected to the oracle database on my machine (localhost). 
When I decide to publish my website , how am I supposed to upload my database?  since it's not a single file like MSSQL. 
update I don't have a dedicated server, I am gonna pay for domain and upload the website files to the hosting provider, and then upload my db to where-ever my website can I access it.  I don't have any access to any hosting machine. 

A:

Assuming that the server that will host the database has Oracle RDBMS installed, what you should do is use the "exp" or "expdp" Oracle utilities to export/create a "dump" file which you can then send to the hosted server team, and they would then us "imp" or "impdp" to import the database. 
Or, now this this might be controversial in these modern IDE times, you should have your databse schema scripted into build scripts to:

Create the schema containers (TABLESPACES)
Create the schema owner
Create the tables
Create indexes/PK/FK
Add privileges to any ROLES/USERS
Add PLSQL, trigger code
Add static/lookup data

I presume you do not need to load any transactiona/account/customer data if your source database is where you did your development/testing, just the static data. 
Send the build scripts to the hosted server team for them to apply via sqlplus. 
The exp/imp method will (without delving into details about exclude rules) take everything. 