hi i am using oracle 9i and now a days i am learning sql.
due to some problems i have to change my system and i will install oracle 9i in my new system, but problem is that after installing i need all that old tables that i have created in past 3 weeks in my old system.
please can anybody tell me after creating any table with sql plus where it is saved.
so that i successfully transfer that tables (or queries) in my new system.
if it is not possible please suggest me any idea from your self only.
please help me i am totally in trouble.
aman rathi
3
Junior Poster in Training
Recommended Answers
Jump to PostYou need to take an export of the old user schema and import the same into new schema.
You need to use the commands EXP(to export) and IMP (to import).
All 3 Replies
debasisdas
580
Posting Genius
Featured Poster
aman rathi
3
Junior Poster in Training
debasisdas
580
Posting Genius
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.