OraFAQ Forum: Server Utilities » pre-create tables

Home » RDBMS Server » Server Utilities » pre-create tables (AIX, Oracle 10.2.0.3.0)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

pre-create tables [message #504565]

Tue, 26 April 2011 11:03

lg123
Messages: 208
Registered: August 2008

Senior Member

I need to export a schema and import in to another schema in the same database using original export/import method. The user has requested to precreate some of the tables before I do the import. He wants me to take the script of the tables from source schema and create newly the tables in the destination schema. Does it makes sense? Should I separately create those tables in the destination schema and then do the import or when I do export/import, automatically those tables will get transferred correctly? Basically he wants those tables to be pre-created in the destination schema because those tables contain LOB's so that the storage tablespace setting will be correct. Please advice.

Report message to a moderator

Re: pre-create tables [message #504566 is a reply to message #504565]

Tue, 26 April 2011 11:05

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

CREATE TABLE NEW_TABLE AS SELECT * FROM OLD_TABLE;

Report message to a moderator

Re: pre-create tables [message #504567 is a reply to message #504566]

Tue, 26 April 2011 11:10

lg123
Messages: 208
Registered: August 2008

Senior Member

If I take the create table script from source schema and change the name of the tablename alone and paste it in the destination schema, will it work?

Report message to a moderator

Re: pre-create tables [message #504570 is a reply to message #504567]

Tue, 26 April 2011 11:23

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

>If I take the create table script from source schema and change the name of the tablename alone and paste it in the destination schema, will it work?
some/many/most folks actually TEST DDL before applying to Production rather than depend upon unknown & unaccountable strangers.

Report message to a moderator

Re: pre-create tables [message #504575 is a reply to message #504570]

Tue, 26 April 2011 12:01

lg123
Messages: 208
Registered: August 2008

Senior Member

I do have oracle installed in my personal machine. I do not want to test in office servers. If i mess up with something, I will be in to trouble. If someone could test this and let me know it would be helpful for me.

Report message to a moderator