Home » RDBMS Server » Enterprise Manager » Creating Tables & Inserting
Creating Tables & Inserting [message #67934] Fri, 19 July 2002 07:52 Go to next message
Alexi Brown
Messages: 1
Registered: July 2002
Junior Member
Can I create a table with a view in OEM?
If so, how (e.g. CREATE TABLE xyz AS (SELECT blah, blah)?
If not, then how do I create a new table in OEM?

Can I drop the contents of a table in a view in OEM and then add new data (e.g. through an INSERT statement)?
If so, how?

Please feel free to reply to any part of this posting. I'm just getting started.
Re: Creating Tables & Inserting [message #67941 is a reply to message #67934] Sun, 21 July 2002 10:57 Go to previous messageGo to next message
Alan
Messages: 68
Registered: October 1999
Member
Try to use dbastudio. U can create tables there.
Re: Creating Tables & Inserting [message #67945 is a reply to message #67934] Tue, 23 July 2002 12:31 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
in OEM, you go to SCHEMA MANAGER
Right Mouse Click on TABLES folder and selecr CREATE
then there is a radio button you can select that says DEFINE QUERY you need to select.
Previous Topic: Could Not Connect to the OMS
Next Topic: Problem while connecting to database using transactions
Goto Forum:
  


Current Time: Thu Mar 28 16:52:03 CDT 2024