Yes, if you are migrating between environments you need to any database objects you ar eusing between environments. You need to also migrate changes you make between environments too.. Example is you have a tabl ein all environments, but in devl you add 2 columns. You will need to migrate the table changes to beta and prod using an alter table script.
Los Alamos, NM
So I have tables in workspace1 and I want to migrate it to workspace2. I ran the script and it created the table in workspace2. Is there any easy way to migrate data associated within those tables?
If it is a small amount of data, you can use SQL*Developer to create the INSERT script.
If it is for a Brand New Table: Data Pump comes to mind.
You could use SQL*Developer to create a CSV of the data and then import the data via External Table with an INSERT-SELECT statement.
-- or import the data from a CSV into the final table with SQL*Developer -- however, in Production, you would most likely run up against Security policies.
You could also load the data with an INSERT-SELECT statement across a DB Link.
No matter which method you choose., make sure all of your scripts (including "initial data" scripts) are in your code repository.