How to dump Oracle Data/How to export data in oracle

	Please follow the below steps to dump oracle data into some persistent storage like .txt file or .dmp file ...

	Note: Lets assume we want to dump oracle database where username is myusername; password:mypassword and SID/HostString is XYZ

	Step1:Open command prompt and type exp

	Step2: U will get a prompt like Username: enter myusername/mypassword@XYZ and Press Enter

	Step3:Enter array fetch buffer size: 4096 >Press Enter

	Step4:Export file: EXPDAT.DMP >c:/mydata.dmp and Press Enter

	Step5:(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >U and Press Enter

	Step6: Export grants (yes/no): yes >Press Enter

	Step7: Export table data (yes/no): yes >Press Enter

	Step8: Compress extents (yes/no): yes >Press Enter

	You will get a message like..	Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
	About to export specified users ...
	Step9:User to be exported: (RETURN to quit) >myusername and Press Enter

	Step10:User to be exported: (RETURN to quit) >Press Enter

	Onsuccessful export, you will get like below:
	
			. exporting pre-schema procedural objects and actions
			. exporting foreign function library names for user LOGIN
			. exporting PUBLIC type synonyms
			. exporting private type synonyms
			. exporting object type definitions for user LOGIN
			About to export LOGIN's objects ...
			. exporting database links
			. exporting sequence numbers
			. exporting cluster definitions
			. about to export LOGIN's tables via Conventional Path ...
			. . exporting table                     LOGINTABLE          8 rows exported
			. . exporting table                           TEMP          6 rows exported
			. exporting synonyms
			. exporting views
			. exporting stored procedures
			. exporting operators
			. exporting referential integrity constraints
			. exporting triggers
			. exporting indextypes
			. exporting bitmap, functional and extensible indexes
			. exporting posttables actions
			. exporting materialized views
			. exporting snapshot logs
			. exporting job queues
			. exporting refresh groups and children
			. exporting dimensions
			. exporting post-schema procedural objects and actions
			. exporting statistics
			Export terminated successfully without warnings.
	Step11:type exit and enter