Specify tablespace when creating Oracle tables?

November 30 0
Advertisement
I am migrating from MS SQLServer 6.5 to Oracle 9.0.1.2. Whenever I run the OMWB process to load the table data into the destination Oracle database, OMWB creates a tablespace named after my SQLServer database name. This is fine; however, the datafile always ends up in the ORACLE_HOME/dbs directory. Even if I use OMFs, it still creates the datafile for this tablespace in ORACLE_HOME/dbs. Is there any way to specify the tablespace and/or user?
NOTE: OMWB is executed on NT 4.0. Oracle repository and destination database is on Solaris 2.6. I don't think those facts matter for this question, but I want to specify because the O/S field above only allows for one selection.
Thanks!
Advertisement
Reid,
if you expand the tablespace folder in the Oracle Model UI and select the tablespace in question you will note that on the
right-hand-side of the Migration Workbench UI a property pane appears with a General and Storage tab. On the General
tab you will see a list box with column headings including File Name and File Directory. If you select the tablespace name
under the File Name column, you will note that you can change the name of the tablespace file. If you select the File Directory
column for the tablespace in question, you will be able to specify a destination directory for the dbf file. If you use this method
then please remember to choose the Apply button at the bottom of the property pane to save any changes you might make.
Note that you can also rename the Tablespace itself by selecting the tablespace in question from the Tablespaces folder
and choosing Object-Rename from the menu - then simply type in your preferred name.
An alternative is to use the Tablespace discoverer option which can be found under the Tools menu in the Migration Workbench.
This enables you to use the tablespaces currently available in an existing Oracle 8i or 9i database.
I hope this helps,
Regards,
Tom - Team OMWB.
Specify tablespace when creating Oracle tables?

I am migrating from MS SQLServer 6.5 to Oracle 9.0.1.2. Whenever I run the OMWB process to load the table data into the destination Oracle database, OMWB creates a tablespace named after my SQLServer database name. This is fine; however, the datafile

Create Oracle tables from DTD

Hi, are there any tools to create oracle tables from dtd'sNone to my knowledge. DTD's don't provide any data type information or length information on the data, so at best such a tool could create you tons of VARCHAR2(4000) columns.Read other 2 answe

Dynamically creating oracle table with csv file as source

Hi, We have a requirment..TO create a dynamic external table.. Whenever the data or number of columns change in the CSV file the table should be replaced with current data and current number of columns...as we are naive experienced people in oracle p

Create oracle table from sql server

Dear Gurus, I need to create some tables from sql server 2008 to a oracle 11g database. Some tables contain vbinary datatype. Now my queries are 1. How can I do that? 2. If DB link is a solution then would you please provide me a step by step process

How to create Oracle Table in DWB from Oracle external table

Dear all, I have create Oracle External Table by using DWB. Kindly tell me steps that how could i able to import this external oracle table into internal oracle table now. When I deploye this External table message arise "Name is using by an existing

Creating Oracle table is giving ORA-00911 error

Hi, I got a small code which I am trying to implement in order to create a table in Oracle 8i database. The code compiles fine. However, when I run, it is giving ORA-00911 error(invalid character). Any help is highly appreciated in advance. Thanks. C

Problem in Creating a table with Default Tablespace

Hi All, 1) Can anybody plz tell me the syntax to move a table from one tablespace to another. 2) Also, plz tell me the Syntax of when creating a table specifying the tablespace name also. Regards1) Alter table <table_name> move tablespace <tables

Need To Create a table in Sql Server and do some culculation into the table from Oracle and Sql

Hello All, I'm moving a data from Oracle to Sql Server with ETL (80 tables with data) and i want to track the number of records that i moving on the daily basis , so i need to create a table in SQL Server, wilth 4 columns , Table name, OracleRowsCoun

Fields missing in Oracles tables created by Infospokes

Hi S.A.P Gurus! My problem is as follows: We have created Infopokes with Oracle table as destination. Even though, the transport to other systems is correct, and the infospoke have all the fields, when we execute it, some fields are missing in the de

How to create a table in Oracle Lite database?

Hi, I have installed SOA 10.1.3 on my laptop. Now I am trying to create a table in the database to do some own examples. I have problem in installing oracle database. So I am trying to create a table in Oracle Lite database which comes with SOA suite

How to Create a Table in Oracle with XML data type.

Dear ALL, What are the requirements for creating a table with xml datatype in Oracle: The steps would help very much to know the scripting of the table and how to query and either insert/update and remove data from that table. Any help, direction, ad

Error in creating partition table in oracle spatial by ankur

Hi, Am working on Oracle 10.2.0.3 Am not able to create partition table in Oracle i have all the required columns in node and edge table ......the moment i try to create partition table using exec sdo_router_partition.partion_router i get the followi

Easy Loader creates Additional tables in Oracle 10G

Hellow everybody I have uploaded a MapInfo TAB file into OracleSpatial 10G, using EasyLoader utility in MapInfo prof 8.0. To my surprise I found some additional tables created apart from the loaded spatial table. They are BIN$3K6Am/kGSH6qQR1cSxw1yQ==

How to create  hidden column in Oracle Table

Hi folks i have one doubt regarding hidden column creation in Oracle Table.. Let me briefly explain my requirements. I have one table called UWRMC_MAST is table contain the following columns         RMC_N_ID           NUMBER(10)                    NO

Oracle Apps - How to create a table before report execution?

Hi, I'm new to oracle apps, I created a procedure to get some values for a report and created a query to get the remaining values. Now I need to populate those values into a temporary table and after the report execution I have to delete the table. I

What is the best/fastest method to create a table (Oracle 11gR2 dB)?

Assuming there are no statistics for the source tables - tables are every day dropped and recreated My tables have a few million rows I try to create a table populated with data as fast as it is possible via 1. createtable_name as SELECT * from emp;

Procedures Creating a table in Oracle

Hi DBAs I am new to oracle technology. I have created the database using dbca. Is it for creating a table we just require the sql create statement. On a server I have two databases running. If I do a sql create statement how do I specify in which dat

Can we create a table in temp tablespace?

Hi Support , I have confused about on point that Can we create a table in temp tablespace. thanksI so not think the question is so bad except that it was as suggested something you can determine for yourself in 20 seconds: > / create table mark (fld1

How to create a oracle table in PLSQL Stored Procedure ?

Gurus, Any one send the example link to me to create a oracle table through stored procedure ? Thanks. Sbegin EXECUTE IMMEDIATE "CREATE TABLE BLAH (COL1 NUMBER)"; nd;By the way, it raises a question as to why you need to create a table dynamical

Oracle jdbc creating a table, sequence and trigger

I'm trying to create a table with a sequence and with a trigger for that sequence. When I do this within Oracle Express edition I have the following SQL statements. Which DO run correctly inside Oracle Express using the same user I log in with JDBC.