Member Avatar for adobe71

I have installed oracle10g ExpEdition,it hasn't inbuilt table. I need oracle tables emp,dept,salgrade,mgr.If you have installed oracle9i , you can easily export the tables.
I am describing the method.

open command prompt
type C:\>exp scott/tiger file="c:\emp.dmp" tables=(emp,dept,salgrade,mgr)

then go to c drive,You can see the exported emp.dmp file.
Please send me that file to SNIP
THANKS.

Edited by happygeek because: email snipped, keep help onsite please
  • 4 Contributors
  • 4 Replies
  • 124 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by rohinireddy
Member Avatar for jwenting

no, we won't. RTFM.

Member Avatar for debasisdas

The built in tables are there. You need to run the pre-existing scripts to create the tables in the desired schema.

Member Avatar for jwenting

and RTFM to learn how to unlock the user account he's trying to use :)

Member Avatar for rohinireddy

I want oracle boze,am intrested about oracle side.

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.